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
Tuning option selection (merged 2) WIndows XP, Oracle 10g By: a_oracle on Thu, 09 June 2011	2	1390	Tue, 14 June 2011 08:17 By: michael_bialik
Oracle data migration performance issues 10.2.0.3 By: shashikantkale on Tue, 07 June 2011	6	2879	Tue, 14 June 2011 07:51 By: michael_bialik
merging 2 big tables Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production, linux By: orsoghu on Tue, 14 June 2011	4	2465	Tue, 14 June 2011 06:22 By: orsoghu
Database Performance is very slow oracle 10g By: adnanmkm on Tue, 14 June 2011	2	1557	Tue, 14 June 2011 06:17 By: cookiemonster
Delete statement being running for over 2hrs Oracle 11.2.0.1, Red Hat Linux 2.6.18-128.el5 x86_64 By: youngb912 on Fri, 03 June 2011	16	4471	Mon, 06 June 2011 22:31 By: BlackSwan
Speed Up the gathering of stats. Windows XP, Oracle 10g By: oraranjangmailcom on Thu, 02 June 2011	12	5392	Mon, 06 June 2011 21:37 By: hkchital
Tuning Select Not IN statement(2 Merged) 10g R2 By: getzeeshan on Thu, 02 June 2011	15	2743	Fri, 03 June 2011 17:59 By: getzeeshan
Solution Required for Sql Performance issue in oracle due to Null value check(2 Merged) Oracle 10gR2 By: ganeshkn21 on Wed, 01 June 2011	27	4830	Fri, 03 June 2011 09:47 By: BlackSwan
Tuning Merge Statetment Oracle 10.2.0.4 Enterprise Edition By: getzeeshan on Wed, 18 May 2011	28	8557	Thu, 02 June 2011 11:05 By: getzeeshan
Advice on Index Creation Windows 2000, Oracle 10g By: oraranjangmailcom on Wed, 01 June 2011	11	2171	Thu, 02 June 2011 08:56 By: BlackSwan
Slow query with distinct Oracle 10G By: uicmxz on Tue, 31 May 2011	8	3871	Wed, 01 June 2011 10:27 By: BlackSwan
index advises By: hannah00 on Mon, 23 May 2011	20	3647	Fri, 27 May 2011 10:37 By: Kevin Meade
Statistics gathering approach Oracle 10.2.0.3 By: Its_me_ved on Fri, 27 May 2011	4	2128	Fri, 27 May 2011 02:20 By: Michel Cadot
Unable to avoid Indexes (2 Merged) Oracle 10g, Windows 2000 By: oraranjangmailcom on Fri, 20 May 2011	28	4694	Thu, 26 May 2011 08:36 By: oraranjangmailcom
How to Optimize the Query Without Using IN opertator By: dhathri on Thu, 26 May 2011	2	1600	Thu, 26 May 2011 07:01 By: Michel Cadot
Tuning sub queries with function call Oracle 11g By: steve_mavros on Tue, 24 May 2011	6	2143	Tue, 24 May 2011 10:25 By: Michel Cadot
Auto Stats gathering not including my schema? oracle 11g solaris 10 By: chris32680 on Mon, 16 May 2011	16	16749	Fri, 20 May 2011 07:09 By: chris32680
Query tuning Oracle ,10.2.0.2.0,Unix ( 1 2) By: Database admin on Wed, 18 May 2011	47	4691	Thu, 19 May 2011 05:57 By: Michel Cadot
Multiple SELECT statement help TOAD 9 By: gitarooman83 on Fri, 08 April 2011	6	2448	Mon, 16 May 2011 14:12 By: Barbara Boehmer
Question regarding performance impact on disabling foreign key ORACLE 10.2.0.3 By: Its_me_ved on Wed, 11 May 2011	8	3350	Fri, 13 May 2011 15:11 By: Michel Cadot
No row resource operation information in tkprof output Database 10.2.0.4 By: ole2009 on Fri, 13 May 2011	1	1928	Fri, 13 May 2011 14:26 By: BlackSwan
Help in tuning a value set query By: kavitayetakuri on Wed, 11 May 2011	20	10386	Fri, 13 May 2011 03:42 By: cookiemonster
composite index Oracle 11.1.0.7.0 64 bit By: yassirrehman@gmail.com on Thu, 12 May 2011	1	1320	Thu, 12 May 2011 12:52 By: BlackSwan
Query Performance Issue Oracle SQL Developer, v1.0.14.67 By: abdulrahaman288 on Wed, 11 May 2011	5	1794	Wed, 11 May 2011 07:18 By: Yasir Hashmi
ORA-01555 Oracle 11gR2, Linux By: gkrishn on Tue, 10 May 2011	10	15479	Tue, 10 May 2011 10:00 By: BlackSwan
verify if procedure has been completed Oracle 10.2.0.3, Jsp 2.0 By: Its_me_ved on Tue, 10 May 2011	2	1677	Tue, 10 May 2011 03:29 By: John Watson
Table occupying max size oracle 10.2.0.3, unix solaris By: Its_me_ved on Mon, 09 May 2011	30	23728	Tue, 10 May 2011 02:44 By: Michel Cadot
Oracle Buffer Cache vs AIX Filesystem Cache Oracle 10gR2 on AIX 6.1 By: eclipsis on Sat, 07 May 2011	4	3652	Sun, 08 May 2011 01:22 By: Michel Cadot
After trigger causing performance bottleneck Windows Xp, Oracle 10g By: a_oracle on Fri, 06 May 2011	3	2101	Fri, 06 May 2011 07:22 By: John Watson
Elapsed time oracle 10g By: fowjil on Thu, 05 May 2011	2	1217	Thu, 05 May 2011 09:47 By: Littlefoot
Procedure code taking longer time to execute Oracle 10.2.0.2.0 , Unix By: Database admin on Wed, 04 May 2011	3	1747	Wed, 04 May 2011 09:50 By: BlackSwan
Adding +0 and -0 to a number predicate produces differents plans. 10.2.0.4 By: nikko on Fri, 29 April 2011	1	1262	Fri, 29 April 2011 16:03 By: Kevin Meade
What is causing the lock despite such an decent update state Oracle 10gr2, windows 32 By: kytemanaic on Wed, 27 April 2011	2	7637	Fri, 29 April 2011 01:42 By: kytemanaic
tkprof trace analyze for recommendataion 10.2.0.2.0 By: sudityakumargmailcom on Fri, 22 April 2011	6	2969	Wed, 27 April 2011 02:47 By: John Watson
Sql tuning Oracle 10.2.0.3 By: Its_me_ved on Thu, 21 April 2011	7	2486	Wed, 27 April 2011 01:27 By: michael_bialik
Only LOCAL bitmap indexes are permitted on partitioned tables By: Sreedhar Reddy on Fri, 04 February 2005	3	31819	Tue, 26 April 2011 18:46 By: ankitamehani
AWR Oracle 10g 10.2.0.1.0/Windows 2003 Server By: gxeon on Thu, 21 April 2011	6	2161	Sun, 24 April 2011 22:41 By: hkchital
Kill the process Linux, Oracle 10.2.0.3.0 By: lg123 on Thu, 21 April 2011	7	2611	Thu, 21 April 2011 18:17 By: BlackSwan
AUDIT ANALYZE TABLE on 9i database? 9.2.0.8 By: Kevin Meade on Tue, 19 April 2011	2	3015	Wed, 20 April 2011 06:08 By: Kevin Meade
High CPU Utilization in RAC and Log file sequential Read Event Oracle, 10.2.0.4.0, AIX .3 By: pchandna1 on Wed, 13 April 2011	2	3374	Mon, 18 April 2011 13:58 By: pchandna1