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
How to Optimise this query Oracle 11G By: tarundas2016 on Mon, 22 August 2016	3	2573	Thu, 01 September 2016 04:10 By: Kevin Meade
SQL Query - Just too big 11g By: nathan59 on Thu, 01 September 2016	16	4340	Thu, 01 September 2016 03:50 By: Kevin Meade
Driving site hint on a single remote table OEL 6.5,Oracle 10g By: swas_recall on Thu, 01 September 2016	7	4992	Thu, 01 September 2016 03:35 By: Michel Cadot
Tuning Multiple Not Exists Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ricky_s on Mon, 22 August 2016	10	5342	Fri, 26 August 2016 01:00 By: Michel Cadot
improve performance using partitioning oracle 11g By: tarundas2016 on Mon, 22 August 2016	3	2574	Tue, 23 August 2016 02:39 By: Roachcoach
slow running sql 10g By: arifmd1705 on Mon, 08 August 2016	16	5040	Sat, 13 August 2016 23:22 By: arifmd1705
server session exceed By: rameshrk0206@gmail.com on Mon, 08 August 2016	1	2061	Mon, 08 August 2016 01:30 By: Michel Cadot
Data related to DB Metrics for a period Oracle 11.2.0.4 on Linux By: orausern on Thu, 04 August 2016	5	2639	Thu, 04 August 2016 03:52 By: John Watson
Why rownum is not used in the query By: samiran_cts on Tue, 02 August 2016	13	5453	Wed, 03 August 2016 08:14 By: cookiemonster
Approach for Oracle Profiles to tune queries Oracle 11.2.0.4 on LInux By: orausern on Tue, 02 August 2016	4	2862	Tue, 02 August 2016 04:19 By: orausern
consecutive executions Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: bibhuti037 on Wed, 27 July 2016	7	3024	Thu, 28 July 2016 02:24 By: pablolee
Compare spatial and attributive query Oracle Locator 11g By: moehre on Tue, 05 July 2016	11	4453	Wed, 13 July 2016 03:55 By: Barbara Boehmer
Whast is connect$_by$_pump$ in explain plan Oracle Database 11g Release 11.2.0.3.0 - 64bit By: javed.khan on Tue, 28 June 2016	1	2887	Tue, 28 June 2016 23:35 By: javed.khan
Performance worse for given workflow query 11i By: nishant87 on Wed, 22 June 2016	16	4155	Wed, 22 June 2016 09:48 By: John Watson
How to make sure no archivelog being generated for a particular table 11.2.0.2 SE, windows 2008 r2 By: juniordbanewbie on Tue, 14 June 2016	10	3148	Tue, 14 June 2016 09:37 By: Michel Cadot
Is there a way to find out a killed session associated sql 11.2.0.2,SE windows 2008 r2 By: juniordbanewbie on Tue, 14 June 2016	6	2948	Tue, 14 June 2016 06:11 By: juniordbanewbie
Performance degrade after migration from 11g exadata to 12c 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: knw15pwr on Tue, 07 June 2016	2	2599	Wed, 08 June 2016 14:42 By: knw15pwr
LEFT OUTER JOIN of Large Tables - Performance issue ORACLE, 12.1.0.2.0, WINDOWS 10 By: anil_mk on Thu, 28 April 2016	8	10318	Tue, 07 June 2016 08:15 By: Kevin Meade
count(*) anomaly DB 12.1.0.2, Windows 10 By: John Watson on Sat, 28 May 2016	5	2892	Sat, 28 May 2016 12:24 By: John Watson
performance issue with oracle AQ while dequeueing the table 11.2.0.3 , 3 node-RAC, solaris 11 By: pavanintouch on Tue, 17 May 2016	1	3338	Tue, 17 May 2016 03:20 By: Michel Cadot
ORA-03137 11.1.0.6.0 By: AlinaC on Tue, 11 May 2010	17	78369	Thu, 12 May 2016 17:38 By: valdba
SGA_MAX_SIZE and SGA_TARGET Unix, ORacle 12C By: ninan on Mon, 02 May 2016	16	6567	Thu, 05 May 2016 11:09 By: Michel Cadot
Cluster table access IO is unexpected 11.2.0.4 By: Roachcoach on Thu, 28 April 2016	3	2487	Fri, 29 April 2016 02:32 By: Roachcoach
Performance Issue after upgrade to 11.2.0.4 Oracle Database, 11.2.0.4, RHEL 6.7 x64 By: sadiq106 on Fri, 15 April 2016	7	10003	Sun, 17 April 2016 04:13 By: John Watson
What Is The Correct Formula For Buffer Cache Hit Ratio 11.2.0.4 SE, Redhat 7.1 By: juniordbanewbie on Fri, 15 April 2016	6	3467	Fri, 15 April 2016 11:15 By: John Watson
ASH data to identify CPU 100% By: orausern on Fri, 15 April 2016	4	2787	Fri, 15 April 2016 05:46 By: orausern
Taking more time to Drop interval Partitions Oracle Enterprise,11.2.0.4,Solaris By: eswararaodba@gmail.com on Sun, 10 April 2016	2	2497	Sun, 10 April 2016 08:04 By: John Watson
How to calculate Index creation time Oracle 11gr2 Linux By: hitesh.bhatt on Wed, 06 April 2016	11	3913	Sat, 09 April 2016 13:22 By: LNossov
stale (local) index statistics on partitioned table Oracle 12c By: quirks on Wed, 06 April 2016	6	4786	Wed, 06 April 2016 08:12 By: quirks
Performance tuning Oracle 11g By: lappi on Wed, 30 March 2016	7	3285	Thu, 31 March 2016 04:20 By: pablolee
Clustering Factor for LOB Index_Type is NULL Oracle 11gr2 RHEL By: hitesh.bhatt on Tue, 29 March 2016	3	2424	Tue, 29 March 2016 07:44 By: John Watson
dynamic sql oracle 11.2.0.3 By: pointers on Sat, 09 January 2016	6	3483	Tue, 22 March 2016 09:31 By: BlackSwan
improve sql performance (long sql here) 11g By: marzbuzz on Thu, 10 March 2016	27	8089	Tue, 22 March 2016 09:22 By: michael_bialik
Long running Query Windows, Oracle 11g By: narendra_bagur on Fri, 11 March 2016	12	5026	Tue, 22 March 2016 03:45 By: Michel Cadot
Why din table fetch continued row increase after fetching every columns 12.1.0.2.0 SLES SP3 By: juniordbanewbie on Fri, 18 March 2016	6	3563	Sun, 20 March 2016 20:24 By: juniordbanewbie
Tablespace and Partition Oracle 12C By: deepakdot on Thu, 17 March 2016	2	2507	Thu, 17 March 2016 04:56 By: deepakdot
How to deal with 'Free buffer waits' event Oracle 11g R2 , Linux 64bit By: kangfei on Sun, 13 March 2016	7	4124	Mon, 14 March 2016 06:56 By: John Watson
Query Optimization Oracle SQL Devloper By: Ranjeet29590 on Fri, 11 March 2016	4	3103	Sun, 13 March 2016 11:15 By: garan
Size of SYSAUX is getting bigger Oracle 10g R2 10.2.0.4 By: snehalgandhi on Wed, 02 March 2016	9	4928	Wed, 02 March 2016 03:17 By: Michel Cadot
Select with Union Performance issue Oracle 11g By: emyk on Tue, 01 March 2016	3	2885	Wed, 02 March 2016 02:59 By: cookiemonster