OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Query tuning By: preethavinay on Mon, 21 February 2011	7	2977	Thu, 10 March 2011 07:36 By: marcodba
Stored Procedure is taking too long time to Execute. (2 Merged) Oracle 11.2 By: nanuvamsi on Fri, 04 March 2011	6	5723	Wed, 09 March 2011 12:36 By: BlackSwan
SQL Tuning Oracle 10.2.0.4 By: sathik on Tue, 22 February 2011	12	4462	Tue, 08 March 2011 07:43 By: marcodba
inserting data using FOR ALL 9i/10g By: ashish_sun123 on Sun, 06 March 2011	3	3364	Sun, 06 March 2011 17:35 By: Barbara Boehmer
performance tuning oracle 10g By: manidotkandan on Thu, 03 March 2011	7	3519	Fri, 04 March 2011 03:43 By: cookiemonster
Tunning the query and 4000-5000 parameter in IN clause By: forroughuse on Wed, 02 March 2011	12	3953	Thu, 03 March 2011 12:12 By: Littlefoot
Collecting stats oracle 10.2.0.1.0 - windows XP By: muktha_22 on Thu, 03 March 2011	1	1730	Thu, 03 March 2011 04:14 By: Michel Cadot
Dynamic SQL performance Oracle 10G By: uicmxz on Mon, 28 February 2011	1	2156	Mon, 28 February 2011 17:19 By: BlackSwan
faster processing of records needed: performance isue oracle 9i/10g/11g By: ashish_sun123 on Sat, 26 February 2011	2	1843	Mon, 28 February 2011 08:01 By: michael_bialik
Wrong REDO log file location Oracle 10G, Solaris 10 By: Tlg13team on Fri, 25 February 2011	4	3747	Fri, 25 February 2011 20:43 By: wkk1020
help to wrire the procedure oracle,10g,unix By: vickey_sagar1 on Fri, 25 February 2011	2	1587	Fri, 25 February 2011 15:10 By: cookiemonster
performance tuning general By: goldenshot2727 on Thu, 22 April 2010	4	2410	Fri, 25 February 2011 07:31 By: samosimo
Cursor_sharing setting in OLTP environment Oracle 9i R2, 10g R2 By: OraKaran on Tue, 22 February 2011	11	4491	Wed, 23 February 2011 08:13 By: OraKaran
Identify blocking sessions 11.1.0.7, Standard Edition By: John Watson on Mon, 21 February 2011	4	4226	Tue, 22 February 2011 03:49 By: John Watson
Slow Sql query Oracle 10.2.0.3 By: Its_me_ved on Thu, 17 February 2011	8	4600	Sun, 20 February 2011 06:00 By: Its_me_ved
full table scan 10.2.0.4 By: sathik123 on Sat, 19 February 2011	2	1862	Sun, 20 February 2011 00:26 By: Michel Cadot
Performance tuning of PL/SQL Procedure Oracle 10.2.0.5 By: Santrupta on Sun, 13 February 2011	10	4047	Thu, 17 February 2011 09:26 By: cookiemonster
Performance issue in jsp application Oracle 10.2.0.3,jsp By: Its_me_ved on Wed, 16 February 2011	2	1860	Wed, 16 February 2011 05:52 By: rleishman
Bulk Update Oracle 11g By: rcd70 on Tue, 15 February 2011	1	2309	Tue, 15 February 2011 18:54 By: BlackSwan
Optimal REDO log file size Oracle 10G, Solaris 10 By: Tlg13team on Thu, 10 February 2011	9	12683	Mon, 14 February 2011 03:44 By: Tlg13team
Performance tuning oracle 9i/10g/11g By: ashish_sun123 on Sun, 13 February 2011	6	1585	Sun, 13 February 2011 23:32 By: Michel Cadot
SELECT query Oracle,11.1.0.6,RHEL 5 By: arunb1982 on Fri, 11 February 2011	6	2035	Fri, 11 February 2011 12:44 By: Michel Cadot
Queries on PGA Settings and related Memory Management Oracle 9i on RHEL By: OraKaran on Fri, 11 February 2011	8	6633	Fri, 11 February 2011 11:14 By: OraKaran
Delete command running taking long time windows server 2003, oracle 11g DB By: pradies on Fri, 11 February 2011	9	3604	Fri, 11 February 2011 05:33 By: OraKaran
Application is slow when no of connections goes up Oracle Database 8.1.7 on Solaris By: rajan69 on Wed, 09 February 2011	2	1765	Wed, 09 February 2011 07:19 By: cookiemonster
How to Change execution plan of Currently Executing Statement? Oracle 10.2.4.0 on RHEL By: OraKaran on Tue, 08 February 2011	6	4900	Wed, 09 February 2011 03:21 By: OraKaran
data caching oraclge 10g By: gamba on Mon, 07 February 2011	7	2150	Tue, 08 February 2011 03:30 By: cookiemonster
Real time speed improvements & autotrace results. Oracle 9.2/Solaris By: Roachcoach on Fri, 04 February 2011	11	4878	Mon, 07 February 2011 09:43 By: Roachcoach
Update columns of one table using another table Oracle 10G By: priyankt on Sun, 06 February 2011	4	2340	Mon, 07 February 2011 02:08 By: priyankt
tunning oracle 10g/windows 2003 By: gxeon on Fri, 04 February 2011	5	2108	Fri, 04 February 2011 08:11 By: gxeon
Query Regarding Nested Loop Oracle 9i R2 on RHEL By: OraKaran on Thu, 27 January 2011	27	3382	Thu, 03 February 2011 06:34 By: Michel Cadot
No Snapshot Avaliable for AWR Report Oracle 11g, Windows 2003 By: pradies on Tue, 01 February 2011	8	13081	Wed, 02 February 2011 01:35 By: Michel Cadot
Problem queries of Materialized Views Oracle 9.2.0.8 , HP-UX B11.23 By: indrajit2002 on Fri, 28 January 2011	21	2950	Tue, 01 February 2011 11:36 By: Art Trifonov
Disable ADR By: renafi on Fri, 28 January 2011	2	2169	Sat, 29 January 2011 09:07 By: daverich
Index usage in order by clause on nullable column Oracle 10gR2 on RHEL By: OraKaran on Fri, 28 January 2011	5	6127	Fri, 28 January 2011 19:12 By: rleishman
Using a stats table instead of regular stats to get a plan 9i By: Kevin Meade on Thu, 27 January 2011	2	1973	Fri, 28 January 2011 02:48 By: Kevin Meade
Long Running Query Oracle 9,Unix By: gurukrishnan on Fri, 28 January 2011	1	1301	Fri, 28 January 2011 00:36 By: BlackSwan
Create Index vs Rebuild Index Oracle 9iR2 on RHEL By: OraKaran on Thu, 27 January 2011	2	2453	Thu, 27 January 2011 07:52 By: OraKaran
Optimizer question/ Date handling Oracle 9.2.0.8.0 By: Roachcoach on Mon, 17 January 2011	9	3259	Wed, 26 January 2011 02:57 By: Roachcoach
Locker and waiter problem oraccle 10g RAC environment By: swadeshi on Tue, 25 January 2011	1	1361	Tue, 25 January 2011 07:39 By: Michel Cadot