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
code taking long amount of time to execute ORACLE 11G By: manoj12 on Fri, 03 October 2014	2	789	Fri, 03 October 2014 09:06 By: cookiemonster
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	4819	Fri, 10 October 2014 09:18 By: Kevin Meade
Data PERFORMANCE ISSUES LINUX 5.3 Oracle 11gr2 By: sakamboh on Sun, 28 September 2014	2	595	Sun, 28 September 2014 21:57 By: lzfhope
Private message By: John Watson on Sun, 28 September 2014	3	801	Tue, 30 September 2014 06:18 By: pablolee
How to tune a slow query By: oasisin2014 on Fri, 26 September 2014	4	806	Sat, 27 September 2014 11:22 By: Lalit Kumar B
Db servers capacity oracle By: simplesanju on Tue, 23 September 2014	3	828	Wed, 24 September 2014 00:47 By: simplesanju
Materialized view refresh thrashing DBWR In post By: Roachcoach on Tue, 23 September 2014	4	1554	Wed, 15 October 2014 04:38 By: Roachcoach
SQL tuning advisor being retarted By: aliyesami on Mon, 22 September 2014	6	1481	Thu, 23 October 2014 05:08 By: michael_bialik
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	1176	Fri, 19 September 2014 09:48 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	947	Wed, 17 September 2014 06:21 By: orausern
Query requires tuning Oracle 11gr2, sun By: AviatoR on Fri, 12 September 2014	13	2185	Fri, 19 September 2014 03:01 By: John Watson
Auto stats job window details Oracle 11.2.0.4 on Enterprise linux 6 By: suresh.wst on Thu, 11 September 2014	8	1187	Thu, 11 September 2014 13:12 By: John Watson
dbms_addm.real_time_addm_report DB 12.x By: John Watson on Fri, 05 September 2014	8	1973	Sat, 06 September 2014 10:11 By: Lalit Kumar B
Materialized view oracle 11gr2 By: guddu_12 on Wed, 03 September 2014	5	953	Sun, 07 September 2014 00:27 By: Kevin Meade
Update non-token column on compressed table Oracle EE 11.2.0.2 By: d_seng on Thu, 28 August 2014	2	1197	Sun, 31 August 2014 05:18 By: d_seng
High insertion on the database \| Tuning parameters Oracle 10g, Linux 64 By: abhoite on Tue, 26 August 2014	9	1295	Tue, 16 September 2014 23:01 By: trantuananh24hg
sql query performance guide Oracle 11.2.4.0 , SunOS By: mc1825263 on Fri, 22 August 2014	2	815	Fri, 22 August 2014 01:00 By: mc1825263
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	1961	Fri, 14 November 2014 05:54 By: d_seng
explain plan details vary between display & display_cursor 11g, 11.2.0.3, solaris10 By: ishika_20 on Wed, 20 August 2014	6	998	Wed, 20 August 2014 06:15 By: ishika_20
Regarding sql id 11.2.0.4 By: varunvir on Mon, 18 August 2014	5	1123	Wed, 20 August 2014 02:46 By: cookiemonster
oracle performance metrics 11g By: andrewscharles89 on Mon, 18 August 2014	5	845	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	1081	Thu, 14 August 2014 15:52 By: BlackSwan
Reading byte data from BLOB vs File System By: mafoe on Wed, 13 August 2014	5	1097	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	645	Tue, 12 August 2014 21:23 By: BlackSwan
Parallel Threads Waiting By: scottwmackey on Thu, 07 August 2014	8	1491	Sat, 09 August 2014 12:20 By: scottwmackey
cache issue 11.2.0.2, WIndows 2008 R2 By: sant_new1 on Wed, 06 August 2014	12	1658	Thu, 14 August 2014 09:53 By: sant_new1
Queries "break" after automatic statistic gathering. 11.2.0.3 / CentOS Linux By: ThomasG on Fri, 01 August 2014	4	1275	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	1403	Thu, 31 July 2014 19:31 By: BlackSwan
Access Remote Data Slow By: oasisin2014 on Sun, 28 September 2014	22	1949	Tue, 30 September 2014 13:56 By: oasisinsky
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	4423	Thu, 31 July 2014 05:50 By: John Watson
Partitioning on a VARCHAR2 column 11g By: mafoe on Mon, 28 July 2014	6	1422	Tue, 29 July 2014 04:29 By: Roachcoach
Performance issue 10.2.0.5.0 By: ramanaapps on Fri, 25 July 2014	16	1831	Sat, 26 July 2014 08:55 By: Kevin Meade
After Table analyze, the number of blocks goes Down Oracle 11gR2 By: hitesh.bhatt on Thu, 24 July 2014	7	995	Wed, 30 July 2014 04:14 By: hitesh.bhatt
A question about SPM 11.2.0.4 on Linux By: orausern on Thu, 24 July 2014	2	784	Thu, 24 July 2014 12:48 By: orausern
How to revert the work done by accept_sql_profile procedure & Issues to watch out with SPM (merged) Oracle 11.2.0.4 on Linux By: orausern on Mon, 14 July 2014	20	2307	Wed, 16 July 2014 11:16 By: orausern
Oracle 11g on VMWARE Oracle 11g, Windows Server 2008 By: josephmaan on Wed, 16 July 2014	3	811	Wed, 16 July 2014 07:18 By: Michel Cadot
Performance Tuning 11g By: andrewscharles89 on Thu, 10 July 2014	11	1383	Tue, 22 July 2014 08:20 By: michael_bialik
AWR and ASH report analyze Oracle 10g,11g,Linux By: Database admin on Mon, 07 July 2014	13	1419	Mon, 07 July 2014 10:46 By: Lalit Kumar B
I/O calibration By: John Watson on Wed, 02 July 2014	9	1338	Fri, 04 July 2014 06:34 By: Roachcoach
Shameless plug By: rleishman on Sat, 05 July 2014	5	1424	Sun, 06 July 2014 07:48 By: rleishman