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
Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high times on USER_IO_WAIT_TIME 11.2.0.4 on Linux By: orausern on Fri, 04 September 2015	6	1448	Fri, 04 September 2015 13:07 By: orausern
Oracle noforce view creates force view By: ram50958 on Tue, 25 August 2015	8	3040	Tue, 25 August 2015 11:13 By: Michel Cadot
Response time 12.1.0.1.0, solaris By: kapilavastu on Tue, 21 July 2015	5	1571	Mon, 24 August 2015 21:02 By: Kevin Meade
Interesting performance bottle neck issue Oracle 11g By: ram50958 on Wed, 19 August 2015	10	1828	Wed, 19 August 2015 10:09 By: BlackSwan
Please help for Resolving Issue for Explain plan as query taking long time for execution Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Sun, 09 August 2015	15	2974	Fri, 14 August 2015 12:27 By: Kevin Meade
statistics update 11.2.0.3 on Windows 2008 R2 By: sant_new1 on Thu, 13 August 2015	11	1766	Fri, 14 August 2015 12:07 By: BlackSwan
query with hundreds of bind variables Oracle database 11gR2 11.2.0.2.3 By: fplatel on Tue, 11 August 2015	2	1018	Tue, 11 August 2015 21:55 By: John Watson
Help to tune the query 11.2.0 By: grpatwari on Mon, 03 August 2015	11	2625	Fri, 07 August 2015 08:56 By: Kevin Meade
Cost Issue while using row_number() By: AJAYRAM on Thu, 06 August 2015	11	2032	Fri, 07 August 2015 04:48 By: cookiemonster
A way to identify the top sql other than AWR 11.2.0.4 on Linux By: orausern on Tue, 04 August 2015	5	1194	Tue, 04 August 2015 11:46 By: orausern
TKPROF output analysis windows 2012, oracle 12c By: muktha_22 on Wed, 22 July 2015	4	2008	Thu, 23 July 2015 01:39 By: Michel Cadot
Tuning data deletion that is taking long time 11.2.0.4 on Linux By: orausern on Sat, 11 July 2015	16	2541	Fri, 17 July 2015 05:59 By: orausern
Drop Unused columns 12.1.0.2.0,Linux x86_64 By: preet_kumar on Thu, 16 July 2015	3	939	Thu, 16 July 2015 09:28 By: bpeasland
Help for tuning the sql Query 11.2.0.1 By: grpatwari on Wed, 15 July 2015	9	1907	Thu, 16 July 2015 03:22 By: cookiemonster
Change in he execution plan 12c By: jinga on Mon, 13 July 2015	8	1590	Wed, 15 July 2015 02:48 By: cookiemonster
Query not have much cost on Explain Plan but very very slow oracle 10g By: toom2525 on Sun, 12 July 2015	4	1448	Mon, 13 July 2015 02:07 By: John Watson
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	1096	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	1904	Tue, 07 July 2015 04:22 By: John Watson
Oracle does not use a conditional index oracle 11g By: iblazquez on Mon, 08 June 2015	7	2928	Mon, 06 July 2015 13:46 By: John Watson
flashback Oracle 11g By: ashish.tiwari on Sat, 04 July 2015	8	1999	Mon, 06 July 2015 03:22 By: gazzag
'Configuration' wait class in AWR report 12 By: karthik4u on Sun, 05 July 2015	4	4235	Sun, 05 July 2015 08:29 By: John Watson
Oracle Optimizer cost (merged) Oracle11g By: shrinika on Tue, 30 June 2015	8	1899	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	3057	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	2281	Thu, 11 June 2015 01:23 By: Lalit Kumar B
Oracle Performance Issue linked to Concurrency 11G By: sachinj on Mon, 01 June 2015	4	1601	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	1559	Tue, 02 June 2015 02:35 By: Roachcoach
properly tune parallel parameters? By: dba2015 on Sun, 31 May 2015	1	826	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	1908	Tue, 26 May 2015 09:04 By: cookiemonster
Materialized view option (suggestion) Oracle 11.2.0.4, Linux x86 64 By: hitesh.bhatt on Fri, 22 May 2015	5	1145	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	1437	Fri, 22 May 2015 01:19 By: hitesh.bhatt
Select statement taking Long time to execute Oracle 10g By: P1Oracle on Thu, 21 May 2015	7	2704	Thu, 21 May 2015 23:18 By: rleishman
Set NOLOGGING for tables in UAT windows 2012, oracle 12c By: muktha_22 on Wed, 20 May 2015	6	1314	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	956	Thu, 14 May 2015 08:01 By: BlackSwan
ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner By: paolfili on Sun, 19 April 2015	9	3427	Tue, 12 May 2015 10:29 By: paolfili
How to check index is re-built 11g, 11.2.0.3, Window server By: ashishkumarmahanta80 on Thu, 30 April 2015	3	1200	Thu, 30 April 2015 02:21 By: ashishkumarmahanta80
Query running very slow oracle 9i, windows 2003 server By: zkdba on Thu, 16 April 2015	5	1551	Sun, 19 April 2015 13:40 By: Kevin Meade
Do we need to rebound instance when we Determine the Practical Range for FAST_START_MTTR_TARGET 11.2.0.3 Enterprise Edition By: juniordbanewbie on Tue, 20 January 2015	3	2080	Fri, 17 April 2015 20:38 By: juniordbanewbie
INDEX FULL SCAN (MIN/MAX) 11.2.0.3 By: Roachcoach on Mon, 06 April 2015	4	2323	Mon, 13 April 2015 02:35 By: Roachcoach
indexing nulls oracle 11.2.0.4 on Linux By: orausern on Fri, 10 April 2015	6	1772	Fri, 10 April 2015 11:24 By: Lalit Kumar B
Index skip scan 11.2.0.4 By: Roachcoach on Thu, 02 April 2015	7	2142	Mon, 06 April 2015 02:41 By: Roachcoach

Pages (117): [ « ‹ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Thu Oct 18 11:18:01 CDT 2018