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
stale (local) index statistics on partitioned table Oracle 12c By: quirks on Wed, 06 April 2016	6	2602	Wed, 06 April 2016 08:12 By: quirks
Performance tuning Oracle 11g By: lappi on Wed, 30 March 2016	7	2095	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	1251	Tue, 29 March 2016 07:44 By: John Watson
dynamic sql oracle 11.2.0.3 By: pointers on Sat, 09 January 2016	6	2247	Tue, 22 March 2016 09:31 By: BlackSwan
improve sql performance (long sql here) 11g By: marzbuzz on Thu, 10 March 2016	27	6136	Tue, 22 March 2016 09:22 By: michael_bialik
Long running Query Windows, Oracle 11g By: narendra_bagur on Fri, 11 March 2016	12	3549	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	2168	Sun, 20 March 2016 20:24 By: juniordbanewbie
Tablespace and Partition Oracle 12C By: deepakdot on Thu, 17 March 2016	2	1374	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	2271	Mon, 14 March 2016 06:56 By: John Watson
Query Optimization Oracle SQL Devloper By: Ranjeet29590 on Fri, 11 March 2016	4	1889	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	3066	Wed, 02 March 2016 03:17 By: Michel Cadot
Select with Union Performance issue Oracle 11g By: emyk on Tue, 01 March 2016	3	1610	Wed, 02 March 2016 02:59 By: cookiemonster
Performance issue enq: TX index contention Linux, Oracle 11g RAC By: ninan on Tue, 23 February 2016	22	8098	Tue, 23 February 2016 10:03 By: John Watson
Please help for Improving the Explain plan Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 08 December 2015	8	2447	Wed, 10 February 2016 00:30 By: Kevin Meade
Oracle index creation Oracle 10g By: donep on Mon, 18 January 2016	13	11709	Wed, 10 February 2016 00:26 By: Kevin Meade
Please help for Improving Query Performance Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 15 December 2015	31	4594	Wed, 03 February 2016 20:57 By: Kevin Meade
Sql Query Tuning 11.2 By: mnraju999 on Mon, 11 January 2016	4	2563	Wed, 03 February 2016 20:23 By: Kevin Meade
Oracle ROWID RANGE SCAN AIX 6 By: sinida1984 on Wed, 20 January 2016	9	4830	Wed, 03 February 2016 20:14 By: Kevin Meade
Oracle SQL performance analysis oracle 12c By: gorants on Sun, 31 January 2016	2	1844	Wed, 03 February 2016 20:04 By: Kevin Meade
Tune query for Sum function By: rohit_shinez on Wed, 03 February 2016	7	1794	Wed, 03 February 2016 19:48 By: Kevin Meade
Wich index is used. Confusion in SQL-trace Oracle 12.1.0.2.0 By: mats-larsson@iname.com on Mon, 25 January 2016	3	1463	Mon, 25 January 2016 10:59 By: mats-larsson@iname.com
Application slow down Database 11.2.0.3.0 By: samiyabulushi on Sun, 24 January 2016	2	3340	Sun, 24 January 2016 03:10 By: samiyabulushi
Understanding oracle sql explain plan 12c By: gorants on Mon, 18 January 2016	1	1308	Mon, 18 January 2016 14:02 By: Michel Cadot
Parallel Server for Dummies Checklist By: WolfBrother on Wed, 06 January 2016	2	1388	Thu, 07 January 2016 01:08 By: John Watson
Insert from Select - Performance Issue Oracle 11 g By: ram50958 on Thu, 20 August 2015	8	2445	Tue, 05 January 2016 23:36 By: garan
Materialized View Oracle 11g-Windows By: arunOracle on Thu, 31 December 2015	4	2261	Fri, 01 January 2016 11:42 By: John Watson
use_concat hint DB12.1.0.2 By: John Watson on Wed, 23 December 2015	3	2033	Thu, 24 December 2015 04:22 By: Alien
Database slowness and high load due to IO Latencies? Oracle 11.2.0.4 on Linux By: orausern on Thu, 10 December 2015	9	2442	Tue, 15 December 2015 04:12 By: Roachcoach
PLAN_TABLE_OUTPUT Oracle 11g By: P1Oracle on Thu, 10 December 2015	12	3798	Thu, 10 December 2015 10:49 By: cookiemonster
Export from table vs external table Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: mokarem on Mon, 07 December 2015	9	2875	Tue, 08 December 2015 04:52 By: Michel Cadot
MULTI TABLE INSERT USING BULK COLLECT Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ramanaapps on Mon, 07 December 2015	8	1952	Mon, 07 December 2015 05:40 By: Michel Cadot
Please help for tuning .sql query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 03 November 2015	17	3241	Tue, 01 December 2015 22:24 By: Kevin Meade
OPT_PARAM - WORK_AREA_POLICY 11.2.0.4 By: rasikeg@gmail.com on Tue, 03 November 2015	2	1781	Tue, 01 December 2015 21:57 By: Kevin Meade
Testing SPM Oracle 11.2.0.4 on Linux By: orausern on Fri, 27 November 2015	12	2376	Tue, 01 December 2015 09:18 By: orausern
Making Oracle generate and use different execution plans for any sql 11.2.0.4 By: orausern on Sat, 28 November 2015	2	2815	Sun, 29 November 2015 05:56 By: orausern
Execution plan cost 11.2.0.3 By: pointers on Wed, 25 November 2015	3	2815	Thu, 26 November 2015 00:25 By: pointers
dbms_xplan Oracle 11.2.0.3 By: pointers on Tue, 27 October 2015	3	1641	Tue, 24 November 2015 05:54 By: pointers
Locking modes 10g By: m.abdulhaq on Fri, 23 October 2015	14	3867	Wed, 11 November 2015 10:35 By: cookiemonster
SQL*Net roundtrips Oracle 12c on LInux By: gkrishn on Sat, 07 November 2015	9	2020	Sun, 08 November 2015 01:41 By: gkrishn
dynamic sampling precedence Oracle DB 12.1.0.2 By: kal_youssef on Tue, 03 November 2015	2	1321	Tue, 03 November 2015 16:12 By: John Watson