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
Cursor: Pin S Wait on X Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 By: ecivgamer on Thu, 13 November 2014	4	6055	Fri, 14 November 2014 03:44 By: Michel Cadot
PGA_AGREGATE_TARGET parameter Oracle11g 11.2.0.3 By: shrinika on Mon, 10 November 2014	4	4304	Tue, 11 November 2014 12:35 By: Michel Cadot
Plan missing from cursor cache Oracle 12.1 ,OEL 6 By: gkrishn on Sun, 09 November 2014	2	3993	Sun, 09 November 2014 03:10 By: gkrishn
Delete taking long due to index maintenance? Oracle 11.2.0.3 / CentOS By: ThomasG on Thu, 30 October 2014	14	9274	Wed, 05 November 2014 02:35 By: ThomasG
Query in Loop causing performance issue 11i By: nishantranjan00787 on Fri, 10 October 2014	12	7737	Mon, 03 November 2014 00:48 By: michael_bialik
SQL tuning advisor being retarted By: aliyesami on Mon, 22 September 2014	6	5368	Thu, 23 October 2014 05:08 By: michael_bialik
Table creation with nologging clause is stopped in between 10g, 10.2.0.4, hp unix By: ashishkumarmahanta80 on Wed, 15 October 2014	7	4984	Thu, 16 October 2014 04:09 By: gazzag
Materialized view refresh thrashing DBWR In post By: Roachcoach on Tue, 23 September 2014	4	4980	Wed, 15 October 2014 04:38 By: Roachcoach
Need to tune package. Oracle 11.2.0.3.0 By: swap19 on Sat, 11 October 2014	18	8886	Mon, 13 October 2014 01:49 By: John Watson
Default value of SEND_BUF_SIZE and RECV_BUF_SIZE for IBM Aix 7 Aix 7 By: morad_dba on Sun, 12 October 2014	1	5876	Sun, 12 October 2014 09:31 By: BlackSwan
Query chooses bitmap index and runs slower 11.2.0.2/11.2.0.4 Enterprise, RHL By: d_seng on Wed, 01 October 2014	27	14608	Fri, 10 October 2014 09:18 By: Kevin Meade
improve performance for the query Oracle 11g By: sumanh on Wed, 08 October 2014	2	3984	Wed, 08 October 2014 02:12 By: flyboy
code taking long amount of time to execute ORACLE 11G By: manoj12 on Fri, 03 October 2014	2	3520	Fri, 03 October 2014 09:06 By: cookiemonster
Access Remote Data Slow By: oasisin2014 on Sun, 28 September 2014	22	8417	Tue, 30 September 2014 13:56 By: oasisinsky
Private message By: John Watson on Sun, 28 September 2014	3	3973	Tue, 30 September 2014 06:18 By: pablolee
Data PERFORMANCE ISSUES LINUX 5.3 Oracle 11gr2 By: sakamboh on Sun, 28 September 2014	2	3540	Sun, 28 September 2014 21:57 By: lzfhope
How to tune a slow query By: oasisin2014 on Fri, 26 September 2014	4	4340	Sat, 27 September 2014 11:22 By: Lalit Kumar B
Db servers capacity oracle By: simplesanju on Tue, 23 September 2014	3	3943	Wed, 24 September 2014 00:47 By: simplesanju
Is there a way to monitor historical locks in Standard Edition 11.2.0.3 SE, 11.2.0.3 EE, By: kytemanaic on Fri, 19 September 2014	1	5725	Fri, 19 September 2014 09:48 By: John Watson
Query requires tuning Oracle 11gr2, sun By: AviatoR on Fri, 12 September 2014	13	7130	Fri, 19 September 2014 03:01 By: John Watson
sql_id of a sql not the same in different databases Oracle 11.2.0.4 on Linux. By: orausern on Wed, 17 September 2014	7	5506	Wed, 17 September 2014 06:21 By: orausern
High insertion on the database \| Tuning parameters Oracle 10g, Linux 64 By: abhoite on Tue, 26 August 2014	9	4601	Tue, 16 September 2014 23:01 By: trantuananh24hg
Auto stats job window details Oracle 11.2.0.4 on Enterprise linux 6 By: suresh.wst on Thu, 11 September 2014	8	5931	Thu, 11 September 2014 13:12 By: John Watson
Materialized view oracle 11gr2 By: guddu_12 on Wed, 03 September 2014	5	4001	Sun, 07 September 2014 00:27 By: Kevin Meade
dbms_addm.real_time_addm_report DB 12.x By: John Watson on Fri, 05 September 2014	8	6513	Sat, 06 September 2014 10:11 By: Lalit Kumar B
Update non-token column on compressed table Oracle EE 11.2.0.2 By: d_seng on Thu, 28 August 2014	2	4492	Sun, 31 August 2014 05:18 By: d_seng
sql query performance guide Oracle 11.2.4.0 , SunOS By: mc1825263 on Fri, 22 August 2014	2	3857	Fri, 22 August 2014 01:00 By: mc1825263
explain plan details vary between display & display_cursor 11g, 11.2.0.3, solaris10 By: ishika_20 on Wed, 20 August 2014	6	3944	Wed, 20 August 2014 06:15 By: ishika_20
Regarding sql id 11.2.0.4 By: varunvir on Mon, 18 August 2014	5	3776	Wed, 20 August 2014 02:46 By: cookiemonster
oracle performance metrics 11g By: andrewscharles89 on Mon, 18 August 2014	5	4779	Mon, 18 August 2014 10:07 By: Lalit Kumar B
view slowness.. 11.2.0.2, WIndows 2008 R2 By: sant_new1 on Thu, 14 August 2014	4	3956	Thu, 14 August 2014 15:52 By: BlackSwan
cache issue 11.2.0.2, WIndows 2008 R2 By: sant_new1 on Wed, 06 August 2014	12	8080	Thu, 14 August 2014 09:53 By: sant_new1
Reading byte data from BLOB vs File System By: mafoe on Wed, 13 August 2014	5	4941	Wed, 13 August 2014 08:16 By: Michel Cadot
How to calculate ROI on performance gain Oracle 11gr2, sun By: AviatoR on Tue, 12 August 2014	3	3557	Tue, 12 August 2014 21:23 By: BlackSwan
Parallel Threads Waiting By: scottwmackey on Thu, 07 August 2014	8	6991	Sat, 09 August 2014 12:20 By: scottwmackey
Queries "break" after automatic statistic gathering. 11.2.0.3 / CentOS Linux By: ThomasG on Fri, 01 August 2014	4	4738	Fri, 01 August 2014 13:34 By: Lalit Kumar B
gather table stats 11.2.0.3, sun sol 10 By: AviatoR on Wed, 30 July 2014	8	6250	Thu, 31 July 2014 19:31 By: BlackSwan
How to remove left join and ON JOIN from query and use better things in place of that 11i ( 1 2) By: nishantranjan00787 on Mon, 21 July 2014	51	14602	Thu, 31 July 2014 05:50 By: John Watson
After Table analyze, the number of blocks goes Down Oracle 11gR2 By: hitesh.bhatt on Thu, 24 July 2014	7	4490	Wed, 30 July 2014 04:14 By: hitesh.bhatt
Partitioning on a VARCHAR2 column 11g By: mafoe on Mon, 28 July 2014	6	5995	Tue, 29 July 2014 04:29 By: Roachcoach