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
Find cpu MHz in Oracle view Linux red hat 6.6, oracle 11.2.0.4 By: Malakay79 on Thu, 14 May 2015	2	1249	Thu, 14 May 2015 08:01 By: BlackSwan
ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner By: paolfili on Sun, 19 April 2015	9	4108	Tue, 12 May 2015 10:29 By: paolfili
How to check index is re-built 11g, 11.2.0.3, Window server By: ashishkumarmahanta80 on Thu, 30 April 2015	3	1557	Thu, 30 April 2015 02:21 By: ashishkumarmahanta80
Query running very slow oracle 9i, windows 2003 server By: zkdba on Thu, 16 April 2015	5	1906	Sun, 19 April 2015 13:40 By: Kevin Meade
Do we need to rebound instance when we Determine the Practical Range for FAST_START_MTTR_TARGET 11.2.0.3 Enterprise Edition By: juniordbanewbie on Tue, 20 January 2015	3	2510	Fri, 17 April 2015 20:38 By: juniordbanewbie
INDEX FULL SCAN (MIN/MAX) 11.2.0.3 By: Roachcoach on Mon, 06 April 2015	4	2983	Mon, 13 April 2015 02:35 By: Roachcoach
indexing nulls oracle 11.2.0.4 on Linux By: orausern on Fri, 10 April 2015	6	2276	Fri, 10 April 2015 11:24 By: Lalit Kumar B
Index skip scan 11.2.0.4 By: Roachcoach on Thu, 02 April 2015	7	2711	Mon, 06 April 2015 02:41 By: Roachcoach
performance By: rameshk0316@gmail.com on Tue, 31 March 2015	2	1155	Wed, 01 April 2015 00:15 By: Michel Cadot
performance By: rameshk0316@gmail.com on Tue, 31 March 2015	3	1806	Tue, 31 March 2015 08:57 By: Michel Cadot
ORA-00439: feature not enabled: Bit-mapped indexes By: Sunil Bassi on Mon, 29 March 2004	14	30261	Tue, 31 March 2015 01:39 By: ramanakakarla
Bind variable for date type takes longer time in a query toad 10g By: nciteamo on Fri, 20 March 2015	3	2014	Sun, 29 March 2015 07:53 By: Kevin Meade
Image File Size oracle 11 g By: simplesanju on Tue, 24 March 2015	0	1231	Tue, 24 March 2015 02:35 By: simplesanju
Union (all) and outline hints 11.2.0.3 By: Roachcoach on Fri, 20 February 2015	3	1772	Sat, 21 March 2015 04:05 By: billgate123
CPU consumption calculation for sqls Oracle 11.2.0.4, AIX 6.1 By: saurabhshukladba on Mon, 16 March 2015	1	1580	Mon, 16 March 2015 11:27 By: Michel Cadot
Compression benefits and options Oracle 11.2.0.4 on Linux By: orausern on Thu, 12 March 2015	8	1957	Sun, 15 March 2015 12:27 By: orausern
Information to provide when asking for tuning help. By: Kevin Meade on Wed, 11 March 2015	0	1227	Wed, 11 March 2015 20:43 By: Kevin Meade
Same Data, Two machines but different timings. Why? 10.2.0.1.0 By: bluetooth420 on Mon, 09 March 2015	10	2771	Tue, 10 March 2015 22:43 By: Kevin Meade
Performance Monitor looked ugly 11.2.04 By: bvo65 on Wed, 07 January 2015	5	3621	Mon, 09 March 2015 07:42 By: paolfili
Database today's load vs yesterday Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ind9 on Thu, 05 March 2015	9	1909	Fri, 06 March 2015 10:49 By: ind9
The differential between Index hint and no hint Oracle 10gr2, RHEL5 By: trantuananh24hg on Mon, 02 March 2015	4	1451	Tue, 03 March 2015 01:51 By: trantuananh24hg
v$service_stats information Oracle 11.2.0.4 on Linux RH6 By: Malakay79 on Mon, 02 March 2015	6	1737	Mon, 02 March 2015 03:25 By: Michel Cadot
How to take OSWatcher baseline 11.2.0.3 SLES SP 3 By: juniordbanewbie on Fri, 27 February 2015	1	1169	Fri, 27 February 2015 00:28 By: BlackSwan
How to improve performance? (merged) Oracle Database 11g Release 11.2.0.1.0 - Production, WINDOWS 7 By: mokarem on Tue, 17 February 2015	15	3644	Thu, 26 February 2015 01:30 By: mokarem
Parallel direct path insert no quicker (merged 2 ) Oracle 11 By: brown_zzz on Tue, 24 February 2015	15	3549	Tue, 24 February 2015 08:39 By: Roachcoach
query to data dictionary tables taking long time 11.2.0.4 on Linux By: orausern on Tue, 24 February 2015	6	1550	Tue, 24 February 2015 04:32 By: John Watson
A oracle query causing 100% cpu utilization and blocking other sessions. oracle 11g,(11.2.0.3), Sun Solaris By: RamanaRocks on Sun, 22 February 2015	10	2217	Mon, 23 February 2015 04:00 By: John Watson
Execution plan oracle,11.2.0.2,RHEL By: Prathikesh on Thu, 12 February 2015	4	1663	Fri, 20 February 2015 16:31 By: Kevin Meade
Why does monitoring index fix performance? Oracle Database/Forms 11g, Windows 7 By: nait1234 on Sun, 15 February 2015	8	2561	Wed, 18 February 2015 15:04 By: Michel Cadot
Alert log file size can impact database performance 10g, 10.2.0.1, window server 2008 By: ashishkumarmahanta80 on Tue, 10 February 2015	3	1511	Tue, 10 February 2015 07:31 By: cookiemonster
Updating text string to mask address characters Oracle 11 By: brown_zzz on Thu, 05 February 2015	20	4544	Sun, 08 February 2015 23:42 By: FDAVIDOV
Oracle Database 11g 11.2.0.4.0 running slow Oracle Database 11g 11.2.0.4.0 By: DevilzAdvocate on Sat, 03 January 2015	14	11671	Sat, 07 February 2015 17:02 By: LNossov
update statement takes too long 11.2.0.1.0 By: OraFerro on Sun, 01 February 2015	16	4444	Sat, 07 February 2015 09:20 By: Kevin Meade
what is ** TRANSIENT: 12029568 oracle db 11.2.0.3 on solaris By: mshrkshl on Fri, 30 January 2015	2	2559	Thu, 05 February 2015 03:13 By: Michel Cadot
Explain plan oracle 10g windows 7 By: hdba on Thu, 29 January 2015	10	2554	Thu, 29 January 2015 06:26 By: hdba
What should be recommended percentage of memory to be used for oracle 11.2.0.3 Standard Edition, SLES SP 3 64 bit By: juniordbanewbie on Wed, 28 January 2015	6	3090	Thu, 29 January 2015 01:31 By: John Watson
AWR - licensing question By: piotrtal on Tue, 12 July 2011	28	15999	Mon, 19 January 2015 10:58 By: Kevin Meade
Updating compressed rows All with compression options By: Roachcoach on Tue, 13 January 2015	0	2702	Tue, 13 January 2015 08:22 By: Roachcoach
table lock in past Oracle 10.2.0.4.0, Aix 6.1 By: oradba123 on Mon, 12 January 2015	7	1565	Mon, 12 January 2015 13:42 By: BlackSwan
advice to rewrite a query with a bad desing By: jojoyk on Sat, 10 January 2015	9	2496	Sat, 10 January 2015 14:59 By: John Watson