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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Tuning data deletion that is taking long time 11.2.0.4 on Linux By: orausern on Sat, 11 July 2015	16	1651	Fri, 17 July 2015 05:59 By: orausern
Please provide help for tuning the sql Query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Sun, 12 July 2015	1	682	Sun, 12 July 2015 07:19 By: John Watson
Histograms - good or bad? (split from http://www.orafaq.com/forum/mv/msg/197539/638244/#msg_638244) By: Roachcoach on Fri, 03 July 2015	8	1150	Tue, 07 July 2015 04:22 By: John Watson
'Configuration' wait class in AWR report 12 By: karthik4u on Sun, 05 July 2015	4	2177	Sun, 05 July 2015 08:29 By: John Watson
flashback Oracle 11g By: ashish.tiwari on Sat, 04 July 2015	8	1124	Mon, 06 July 2015 03:22 By: gazzag
Oracle Optimizer cost (merged) Oracle11g By: shrinika on Tue, 30 June 2015	8	1091	Wed, 01 July 2015 10:16 By: Lalit Kumar B
SQL Tuning Advise Oracle 11.2.0.4.0 - 64bit Production By: avineshr on Thu, 18 June 2015	8	2004	Fri, 19 June 2015 11:57 By: BlackSwan
ANALYZE and GATHER STATS windows 2012, oracle 12c By: muktha_22 on Wed, 10 June 2015	17	1326	Thu, 11 June 2015 01:23 By: Lalit Kumar B
Query in active session for more than 2 hours 11.2.0.4 By: varunvir on Mon, 08 June 2015	5	1165	Sun, 06 September 2015 10:14 By: Kevin Meade
Oracle does not use a conditional index oracle 11g By: iblazquez on Mon, 08 June 2015	7	2334	Mon, 06 July 2015 13:46 By: John Watson
Oracle Performance Issue linked to Concurrency 11G By: sachinj on Mon, 01 June 2015	4	1177	Wed, 03 June 2015 02:09 By: John Watson
Please help for improving execution plan Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Mon, 01 June 2015	8	964	Tue, 02 June 2015 02:35 By: Roachcoach
properly tune parallel parameters? By: dba2015 on Sun, 31 May 2015	1	519	Sun, 31 May 2015 13:53 By: Michel Cadot
How Can I Tune this Query Oracle SE 10g R2 - 10.2.0.1.0 By: mdsirajoddin on Fri, 22 May 2015	6	1399	Tue, 26 May 2015 09:04 By: cookiemonster
Select statement taking Long time to execute Oracle 10g By: P1Oracle on Thu, 21 May 2015	7	1821	Thu, 21 May 2015 23:18 By: rleishman
Materialized view option (suggestion) Oracle 11.2.0.4, Linux x86 64 By: hitesh.bhatt on Fri, 22 May 2015	5	708	Fri, 22 May 2015 09:34 By: bpeasland
SQL execution takes long time Oracle 11.2.0.3, Linux x86 64 By: hitesh.bhatt on Thu, 21 May 2015	7	909	Fri, 22 May 2015 01:19 By: hitesh.bhatt
Set NOLOGGING for tables in UAT windows 2012, oracle 12c By: muktha_22 on Wed, 20 May 2015	6	866	Thu, 21 May 2015 09:24 By: bpeasland
Find cpu MHz in Oracle view Linux red hat 6.6, oracle 11.2.0.4 By: Malakay79 on Thu, 14 May 2015	2	621	Thu, 14 May 2015 08:01 By: BlackSwan
How to check index is re-built 11g, 11.2.0.3, Window server By: ashishkumarmahanta80 on Thu, 30 April 2015	3	777	Thu, 30 April 2015 02:21 By: ashishkumarmahanta80
ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner By: paolfili on Sun, 19 April 2015	9	2258	Tue, 12 May 2015 10:29 By: paolfili
indexing nulls oracle 11.2.0.4 on Linux By: orausern on Fri, 10 April 2015	6	1150	Fri, 10 April 2015 11:24 By: Lalit Kumar B
performance By: rameshk0316@gmail.com on Tue, 31 March 2015	3	870	Tue, 31 March 2015 08:57 By: Michel Cadot
Query running very slow oracle 9i, windows 2003 server By: zkdba on Thu, 16 April 2015	5	1094	Sun, 19 April 2015 13:40 By: Kevin Meade
INDEX FULL SCAN (MIN/MAX) 11.2.0.3 By: Roachcoach on Mon, 06 April 2015	4	1430	Mon, 13 April 2015 02:35 By: Roachcoach
performance By: rameshk0316@gmail.com on Tue, 31 March 2015	2	587	Wed, 01 April 2015 00:15 By: Michel Cadot
Image File Size oracle 11 g By: simplesanju on Tue, 24 March 2015	0	702	Tue, 24 March 2015 02:35 By: simplesanju
Bind variable for date type takes longer time in a query toad 10g By: nciteamo on Fri, 20 March 2015	3	1149	Sun, 29 March 2015 07:53 By: Kevin Meade
Performance improvement required Oracle 10G By: saurabh.sha on Wed, 18 March 2015	10	14329	Fri, 11 September 2015 09:12 By: BlackSwan
CPU consumption calculation for sqls Oracle 11.2.0.4, AIX 6.1 By: saurabhshukladba on Mon, 16 March 2015	1	903	Mon, 16 March 2015 11:27 By: Michel Cadot
Compression benefits and options Oracle 11.2.0.4 on Linux By: orausern on Thu, 12 March 2015	8	1028	Sun, 15 March 2015 12:27 By: orausern
Information to provide when asking for tuning help. By: Kevin Meade on Wed, 11 March 2015	0	671	Wed, 11 March 2015 20:43 By: Kevin Meade
Same Data, Two machines but different timings. Why? 10.2.0.1.0 By: bluetooth420 on Mon, 09 March 2015	10	1049	Tue, 10 March 2015 22:43 By: Kevin Meade
Database today's load vs yesterday Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ind9 on Thu, 05 March 2015	9	866	Fri, 06 March 2015 10:49 By: ind9
The differential between Index hint and no hint Oracle 10gr2, RHEL5 By: trantuananh24hg on Mon, 02 March 2015	4	727	Tue, 03 March 2015 01:51 By: trantuananh24hg
v$service_stats information Oracle 11.2.0.4 on Linux RH6 By: Malakay79 on Mon, 02 March 2015	6	888	Mon, 02 March 2015 03:25 By: Michel Cadot
How to take OSWatcher baseline 11.2.0.3 SLES SP 3 By: juniordbanewbie on Fri, 27 February 2015	1	625	Fri, 27 February 2015 00:28 By: BlackSwan
Parallel direct path insert no quicker (merged 2 ) Oracle 11 By: brown_zzz on Tue, 24 February 2015	15	1182	Tue, 24 February 2015 08:39 By: Roachcoach
How to improve performance? (merged) Oracle Database 11g Release 11.2.0.1.0 - Production, WINDOWS 7 By: mokarem on Tue, 17 February 2015	15	1338	Thu, 26 February 2015 01:30 By: mokarem
query to data dictionary tables taking long time 11.2.0.4 on Linux By: orausern on Tue, 24 February 2015	6	790	Tue, 24 February 2015 04:32 By: John Watson