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
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	13672	Fri, 10 October 2014 09:18 By: Kevin Meade
improve performance for the query Oracle 11g By: sumanh on Wed, 08 October 2014	2	3383	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	3055	Fri, 03 October 2014 09:06 By: cookiemonster
Access Remote Data Slow By: oasisin2014 on Sun, 28 September 2014	22	7827	Tue, 30 September 2014 13:56 By: oasisinsky
Private message By: John Watson on Sun, 28 September 2014	3	3201	Tue, 30 September 2014 06:18 By: pablolee
Data PERFORMANCE ISSUES LINUX 5.3 Oracle 11gr2 By: sakamboh on Sun, 28 September 2014	2	2971	Sun, 28 September 2014 21:57 By: lzfhope
How to tune a slow query By: oasisin2014 on Fri, 26 September 2014	4	3720	Sat, 27 September 2014 11:22 By: Lalit Kumar B
Db servers capacity oracle By: simplesanju on Tue, 23 September 2014	3	3442	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	4963	Fri, 19 September 2014 09:48 By: John Watson
Query requires tuning Oracle 11gr2, sun By: AviatoR on Fri, 12 September 2014	13	6442	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	4754	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	4153	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	5360	Thu, 11 September 2014 13:12 By: John Watson
Materialized view oracle 11gr2 By: guddu_12 on Wed, 03 September 2014	5	3566	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	5917	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	4030	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	3430	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	3481	Wed, 20 August 2014 06:15 By: ishika_20
Regarding sql id 11.2.0.4 By: varunvir on Mon, 18 August 2014	5	3352	Wed, 20 August 2014 02:46 By: cookiemonster
oracle performance metrics 11g By: andrewscharles89 on Mon, 18 August 2014	5	4345	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	3523	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	7430	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	4271	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	3001	Tue, 12 August 2014 21:23 By: BlackSwan
Parallel Threads Waiting By: scottwmackey on Thu, 07 August 2014	8	5777	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	3992	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	5708	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	13681	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	3728	Wed, 30 July 2014 04:14 By: hitesh.bhatt
Partitioning on a VARCHAR2 column 11g By: mafoe on Mon, 28 July 2014	6	4921	Tue, 29 July 2014 04:29 By: Roachcoach
Performance issue 10.2.0.5.0 By: ramanaapps on Fri, 25 July 2014	16	7928	Sat, 26 July 2014 08:55 By: Kevin Meade
A question about SPM 11.2.0.4 on Linux By: orausern on Thu, 24 July 2014	2	3187	Thu, 24 July 2014 12:48 By: orausern
performance lag of the quey 11g By: andrewscharles89 on Tue, 01 July 2014	17	6541	Thu, 24 July 2014 11:36 By: LNossov
Performance Tuning 11g By: andrewscharles89 on Thu, 10 July 2014	11	5416	Tue, 22 July 2014 08:20 By: michael_bialik
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	10679	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	3257	Wed, 16 July 2014 07:18 By: Michel Cadot
Query Performance Oracle 11g By: rohan10k on Tue, 17 June 2014	3	3601	Sat, 12 July 2014 02:09 By: Kevin Meade
How about performance using index on the column which is using in WHERE and SET clause. Oracle 11g By: ramya_162 on Wed, 18 June 2014	3	4326	Sat, 12 July 2014 02:03 By: Kevin Meade
AWR and ASH report analyze Oracle 10g,11g,Linux By: Database admin on Mon, 07 July 2014	13	5766	Mon, 07 July 2014 10:46 By: Lalit Kumar B
Shameless plug By: rleishman on Sat, 05 July 2014	5	5415	Sun, 06 July 2014 07:48 By: rleishman