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
Please help me to understand why the query works longer of server_A than on server_B Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: ecivgamer on Wed, 26 November 2014	10	8680	Thu, 27 November 2014 06:22 By: ecivgamer
A question about execution plan Oracle 11.2.0.4. on Linux By: orausern on Tue, 25 November 2014	2	5403	Tue, 25 November 2014 12:52 By: orausern
Index vs Full table scan on sysdate 11.2.0.3,Linux X86_64 By: preet_kumar on Wed, 12 November 2014	7	7609	Tue, 25 November 2014 08:38 By: Andrey_R
Decide on Partitioning Column/Purge Approach Oracle 11g Release 2 By: azeem87 on Thu, 13 November 2014	9	8050	Fri, 14 November 2014 08:33 By: cookiemonster
Logging operation takes longer but no wait events Oracle 11.2.0.4 EE, Linux 64 bit By: d_seng on Mon, 01 September 2014	15	11651	Fri, 14 November 2014 05:54 By: d_seng
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	8669	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	6389	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	5954	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	12901	Wed, 05 November 2014 02:35 By: ThomasG
Query in Loop causing performance issue 11i By: nishantranjan00787 on Fri, 10 October 2014	12	10913	Mon, 03 November 2014 00:48 By: michael_bialik
SQL tuning advisor being retarted By: aliyesami on Mon, 22 September 2014	6	7739	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	7455	Thu, 16 October 2014 04:09 By: gazzag
Materialized view refresh thrashing DBWR In post By: Roachcoach on Tue, 23 September 2014	4	7145	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	12567	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	8414	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	19749	Fri, 10 October 2014 09:18 By: Kevin Meade
improve performance for the query Oracle 11g By: sumanh on Wed, 08 October 2014	2	5990	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	5439	Fri, 03 October 2014 09:06 By: cookiemonster
Access Remote Data Slow By: oasisin2014 on Sun, 28 September 2014	22	12474	Tue, 30 September 2014 13:56 By: oasisinsky
Private message By: John Watson on Sun, 28 September 2014	3	5985	Tue, 30 September 2014 06:18 By: pablolee
Data PERFORMANCE ISSUES LINUX 5.3 Oracle 11gr2 By: sakamboh on Sun, 28 September 2014	2	6269	Sun, 28 September 2014 21:57 By: lzfhope
How to tune a slow query By: oasisin2014 on Fri, 26 September 2014	4	6570	Sat, 27 September 2014 11:22 By: Lalit Kumar B
Db servers capacity oracle By: simplesanju on Tue, 23 September 2014	3	5808	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	7762	Fri, 19 September 2014 09:48 By: John Watson
Query requires tuning Oracle 11gr2, sun By: AviatoR on Fri, 12 September 2014	13	10367	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	8433	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	7188	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	8407	Thu, 11 September 2014 13:12 By: John Watson
Materialized view oracle 11gr2 By: guddu_12 on Wed, 03 September 2014	5	6188	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	9011	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	6418	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	6440	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	6150	Wed, 20 August 2014 06:15 By: ishika_20
Regarding sql id 11.2.0.4 By: varunvir on Mon, 18 August 2014	5	5876	Wed, 20 August 2014 02:46 By: cookiemonster
oracle performance metrics 11g By: andrewscharles89 on Mon, 18 August 2014	5	8741	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	6081	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	11095	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	7416	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	7043	Tue, 12 August 2014 21:23 By: BlackSwan
Parallel Threads Waiting By: scottwmackey on Thu, 07 August 2014	8	9776	Sat, 09 August 2014 12:20 By: scottwmackey