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
tkprof trace analyze for recommendataion 10.2.0.2.0 By: sudityakumargmailcom on Fri, 22 April 2011	6	3868	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	3477	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	33867	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	3121	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	4893	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	4240	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	4250	Mon, 18 April 2011 13:58 By: pchandna1
Max and delete statment talking lot of time oracle 9i,9.2.0.8,unix By: vickey_sagar1 on Fri, 15 April 2011	4	2355	Mon, 18 April 2011 04:21 By: Michel Cadot
Oracle : Client version < Database version. 8.1.7 vs 10gxe By: SAKOURA on Fri, 15 April 2011	6	3671	Fri, 15 April 2011 06:50 By: SAKOURA
Query Hanging with Sequential Read or Latch free Waits Oracle 9.2.0.6.0 on HP-UX By: OraKaran on Thu, 07 April 2011	14	8611	Thu, 14 April 2011 09:09 By: S.Rajaram
subquery optimization (6 threads merged by bb) By: dave987 on Wed, 30 March 2011	12	5484	Wed, 13 April 2011 12:32 By: Barbara Boehmer
Tuning Insert 10.1.0.5.0 By: sunny17 on Tue, 12 April 2011	4	3509	Wed, 13 April 2011 02:35 By: cookiemonster
Shall I kill these process... Oracle 10g rel 2 By: ramoradba on Mon, 11 April 2011	2	2370	Mon, 11 April 2011 15:01 By: ramoradba
Hier - Query Perfomance (3 Merged) By: mnafehm on Mon, 04 April 2011	3	3534	Sat, 09 April 2011 21:04 By: rleishman
How to index 15 columns when you cannot predict what columns will be used in a where clause? Oracle DB 10gR2 By: vini_au on Mon, 04 April 2011	12	5790	Fri, 08 April 2011 00:20 By: rleishman
Why Oracle don't use my predefined index? Oracle 10G, windows By: Tlg13team on Thu, 07 April 2011	5	3450	Thu, 07 April 2011 02:43 By: Roachcoach
Execution plan question Oracle Database 10g Release 10.2.0.5.0 - 64bit Production By: Buchas on Tue, 05 April 2011	15	5356	Wed, 06 April 2011 08:29 By: cookiemonster
Performance tuning of query with self join By: preethavinay on Wed, 06 April 2011	2	2063	Wed, 06 April 2011 06:08 By: michael_bialik
how to use index on "ON in MERGE statement"? 10g, windows 2003 server. By: kang on Wed, 06 April 2011	19	5637	Wed, 06 April 2011 04:59 By: Roachcoach
Just clarification my mind about redo log file size Oracle 10G By: Tlg13team on Wed, 06 April 2011	3	4402	Wed, 06 April 2011 01:16 By: Michel Cadot
please help me tune this query By: miroconnect@yahoo.com on Sun, 03 April 2011	3	2769	Mon, 04 April 2011 09:10 By: cookiemonster
Query getting slowed running in Oracle 10g compared to Oracle 9i Oracle 10g, Linux By: ram anand on Wed, 30 March 2011	24	7377	Mon, 04 April 2011 06:35 By: John Watson
Query not executing (3 Merged) Oracle 10g By: ajaykumarkona on Mon, 28 March 2011	11	4052	Mon, 04 April 2011 02:26 By: cookiemonster
derived column index oralce 10g By: miroconnect@yahoo.com on Sat, 02 April 2011	3	2641	Sat, 02 April 2011 08:37 By: BlackSwan
using between slows query oralce 10g By: miroconnect@yahoo.com on Sat, 02 April 2011	1	2597	Sat, 02 April 2011 01:24 By: Michel Cadot
Performance tuning of query with self join By: preethavinay on Thu, 31 March 2011	6	3568	Fri, 01 April 2011 02:48 By: Its_me_ved
split a large table to small pieces? Oracle 10G, Solaris 10 By: Tlg13team on Mon, 28 March 2011	12	4071	Thu, 31 March 2011 03:40 By: Kevin Meade
Can I use Oracle Hint to use index in a query which uses UNION Oracle 10g By: arijitdey80 on Thu, 31 March 2011	1	4089	Thu, 31 March 2011 01:52 By: Michel Cadot
Why are these explain plans missing some info and messed up like they've been simultaneously written Windows 7 Pro, x64bit By: ilharco on Tue, 29 March 2011	8	5177	Tue, 29 March 2011 17:06 By: BlackSwan
nested select / instead-of-trigger and views=no index used 10g 10.2.0.4 By: Kevin Meade on Tue, 08 September 2009	10	5080	Tue, 29 March 2011 08:47 By: ipynnonen
Performance issue with long running query Oracle 11i By: prasadpsk on Wed, 23 March 2011	14	7214	Tue, 29 March 2011 03:16 By: rleishman
How to assure partition table is better than non-partition table (2 MERGED) Oracle 10g R2 By: Tlg13team on Fri, 25 March 2011	11	4769	Mon, 28 March 2011 21:19 By: BlackSwan
row cache lock/dc_users?? oracle 11g solaris 10 By: chris32680 on Thu, 17 March 2011	21	25364	Mon, 28 March 2011 09:03 By: Michel Cadot
clarification of query EXPLAIN plan Oracle 10G, Solaris 10 By: Tlg13team on Thu, 24 March 2011	5	4122	Sun, 27 March 2011 20:15 By: Tlg13team
why db need kill session instantly Oracle 10G2, RedHat Linux Enterprice6 By: runinwind on Tue, 22 March 2011	2	2781	Sat, 26 March 2011 00:58 By: vjeedigunta
sql library miss rate (2 Merged) oracle database 10.2.0.4 By: karioookey on Fri, 18 March 2011	15	9380	Tue, 22 March 2011 14:29 By: Michel Cadot
SQL Tuning ... Oracle 11g R2 By: aucrun on Tue, 22 March 2011	1	2556	Tue, 22 March 2011 13:02 By: BlackSwan
9582.69043 gigabytes of physical read total bytes and increasing! 11gR2 on Linux RedHat By: nabeelkhan on Thu, 17 March 2011	8	6757	Sat, 19 March 2011 03:12 By: John Watson
INDEXES on TIMESTAMP Oracle 11.2 WIndows Vista 64bit By: amcghie on Thu, 17 March 2011	0	13275	Thu, 17 March 2011 12:01 By: amcghie
help me tune this 11g By: xpact83 on Sun, 13 March 2011	3	2942	Mon, 14 March 2011 04:55 By: michael_bialik