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
To Tune or To use Hints (merged) By: ap_karthi on Wed, 15 July 2009	4	3359	Wed, 15 July 2009 23:20 By: Michel Cadot
Enable 10053 Trace information Oracle 10g, Win XP By: ashoka_bl on Sun, 12 July 2009	7	5382	Sun, 12 July 2009 10:33 By: Michel Cadot
Redo Size doesn't increase more than 260MB HP-UX 11.23, Oracle 9.2i By: dongyoon.ka on Fri, 10 July 2009	1	2754	Fri, 10 July 2009 01:45 By: Michel Cadot
Performance question Oracle9.2.0.3 By: Olivia on Tue, 07 July 2009	3	2639	Thu, 09 July 2009 15:40 By: coleing
SYSTEM TS is increasing 10g RAC HP UX By: madhavamanohar on Wed, 08 July 2009	2	4467	Wed, 08 July 2009 07:17 By: madhavamanohar
9i -> 10g causes JAVA performance problems 10.2.0.3 RDBMS, AIX 3 5 By: jmoran on Mon, 06 July 2009	2	2881	Tue, 07 July 2009 04:38 By: jmoran
Performance question Oracle 9.2.0.3 By: prachij593 on Mon, 06 July 2009	5	4521	Tue, 07 July 2009 01:07 By: Michel Cadot
query_rewrite_enabled 10G By: farenheiit on Fri, 03 July 2009	4	6308	Fri, 03 July 2009 17:44 By: farenheiit
Statistics on Empty Partition oracle 10.2.0.3 in HP-UX11 By: d_ponnilavan on Thu, 02 July 2009	1	2686	Thu, 02 July 2009 12:34 By: Michel Cadot
Index on normal and random column data Oracle 9.2.0.3 By: prachij593 on Thu, 02 July 2009	2	2618	Thu, 02 July 2009 08:09 By: JRowbottom
9i cbo mode first_rows Oracle 9i on hp-ux By: TRaj on Tue, 30 June 2009	4	3659	Thu, 02 July 2009 03:15 By: TRaj
choose which index to be create (merged) By: suryakantnirala on Wed, 01 July 2009	2	2447	Wed, 01 July 2009 08:45 By: cookiemonster
oracle 11g - 11.0.7.0 solaris 10 By: dirish on Wed, 01 July 2009	4	4065	Wed, 01 July 2009 07:30 By: JRowbottom
stale or empty statiscs 10.2.0.2.0 By: varunvir on Fri, 26 June 2009	5	3682	Fri, 26 June 2009 16:42 By: varunvir
BACKUP OF HISTOGRAMS Oracle 10g By: arunprasad_bh on Fri, 26 June 2009	1	2588	Fri, 26 June 2009 09:00 By: Michel Cadot
How do you know whether the Index is getting used or not Oracle 10g,Win XP By: ashoka_bl on Wed, 24 June 2009	7	3860	Thu, 25 June 2009 10:29 By: prachij593
Performance tuning Oracle 10.2.0.3.0 By: deepbans on Tue, 23 June 2009	7	3305	Thu, 25 June 2009 10:22 By: prachij593
Parallel and First_rows Hints By: vikram1780 on Tue, 23 June 2009	1	6507	Tue, 23 June 2009 05:29 By: Michel Cadot
import table having 30000000 rows oracle9i,red hat linux rhel3, having only one processor,ram 1gb By: suryakantnirala on Mon, 22 June 2009	3	2584	Tue, 23 June 2009 01:41 By: Michel Cadot
performance problem with query By: vikram1780 on Mon, 22 June 2009	3	2550	Mon, 22 June 2009 17:18 By: rleishman
Database Hung due to CPU utilization Oracle 10.2.0.2.0,Solaris10 By: balaji1482 on Sat, 20 June 2009	4	2525	Sun, 21 June 2009 08:04 By: balaji1482
May you explain to me about AWR? Oracle 10.2.0.1, Solaris Sparc 64bit By: trantuananh24hg on Thu, 18 June 2009	8	9094	Fri, 19 June 2009 02:37 By: trantuananh24hg
Improving Performance of Large Result Set 11g By: jkomorek on Thu, 18 June 2009	9	4419	Thu, 18 June 2009 17:33 By: jkomorek
Database stops responding when run on production server Oracle 10g By: sonikumari on Mon, 15 June 2009	3	2604	Thu, 18 June 2009 09:18 By: JRowbottom
is there any need of rebuild pk index oracle 9i (9.2),linux rhel3 By: suryakantnirala on Thu, 18 June 2009	2	2482	Thu, 18 June 2009 01:35 By: Michel Cadot
ORA-1652: unable to extend temp Oracle 10g R2 ,AIX By: gkrishn on Sun, 14 June 2009	4	3904	Tue, 16 June 2009 23:32 By: trantuananh24hg
reload of statements in library cache oracle 9i, linux rhel3 By: suryakantnirala on Mon, 15 June 2009	8	4735	Tue, 16 June 2009 06:58 By: amitzil
How to tune latch: cache buffers chains Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 By: upendra4321 on Wed, 10 June 2009	2	11334	Fri, 12 June 2009 23:15 By: trantuananh24hg
Group By Behaviors Oracle Database 10g 10.2.0.4.0 - 64bit, UNIX By: ykathirv on Thu, 11 June 2009	12	4640	Fri, 12 June 2009 04:53 By: ykathirv
HINT INDEX Usage 9.2.0.7 By: Brayan on Fri, 12 June 2009	1	1903	Fri, 12 June 2009 04:40 By: Michel Cadot
How to tune memory size in oracle 8i (merged) By: sanjay6713 on Fri, 12 June 2009	12	6059	Fri, 12 June 2009 04:38 By: Michel Cadot
Dynamic_sampling and partitioning 10.2.0.4 By: farenheiit on Thu, 11 June 2009	1	2785	Thu, 11 June 2009 11:16 By: BlackSwan
slow query with MERGE JOIN CARTESIAN and LATCH cache buffer chains 10g By: farenheiit on Thu, 11 June 2009	2	3286	Thu, 11 June 2009 09:57 By: farenheiit
Performance Tuning in Count(DISTINCT Oracle 9i By: sivakumar.rj on Wed, 10 June 2009	7	3211	Wed, 10 June 2009 17:23 By: BlackSwan
Latch:Library Cache Solaris 10, 10.2.0.1 DB By: trantuananh24hg on Tue, 09 June 2009	5	10317	Tue, 09 June 2009 23:54 By: trantuananh24hg
very simple but very slow query Oracle Database 10g, Suse Linux 10 By: beingman on Fri, 05 June 2009	22	4756	Mon, 08 June 2009 05:25 By: beingman
Performance degrades with big block size tablespace oracle 10G R2, Sun solaris 10 By: bangalibor on Sun, 17 May 2009	13	4985	Sat, 06 June 2009 20:57 By: rleishman
Performance of database runnig on RAC 10g with two Solaris nodes Oracle 10g RAC By: alexberi on Mon, 01 June 2009	12	6503	Fri, 05 June 2009 12:59 By: alexberi
stale_stats and STATTYPE_LOCKED in DBA_TAB_STATISTICS By: casttree on Fri, 05 June 2009	1	12302	Fri, 05 June 2009 03:10 By: Michel Cadot
How to judge the slow query? Windows 2003 SP2 Oracle 10.2.0.4 32-bit By: crazypeter2005 on Tue, 19 May 2009	17	5615	Mon, 01 June 2009 04:49 By: crazypeter2005