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
SYSTEM TS is increasing 10g RAC HP UX By: madhavamanohar on Wed, 08 July 2009	2	3449	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	2003	Tue, 07 July 2009 04:38 By: jmoran
Performance question Oracle 9.2.0.3 By: prachij593 on Mon, 06 July 2009	5	2990	Tue, 07 July 2009 01:07 By: Michel Cadot
query_rewrite_enabled 10G By: farenheiit on Fri, 03 July 2009	4	5411	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	1874	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	1573	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	2393	Thu, 02 July 2009 03:15 By: TRaj
choose which index to be create (merged) By: suryakantnirala on Wed, 01 July 2009	2	1524	Wed, 01 July 2009 08:45 By: cookiemonster
oracle 11g - 11.0.7.0 solaris 10 By: dirish on Wed, 01 July 2009	4	3057	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	2933	Fri, 26 June 2009 16:42 By: varunvir
BACKUP OF HISTOGRAMS Oracle 10g By: arunprasad_bh on Fri, 26 June 2009	1	2016	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	2926	Thu, 25 June 2009 10:29 By: prachij593
Performance tuning Oracle 10.2.0.3.0 By: deepbans on Tue, 23 June 2009	7	2476	Thu, 25 June 2009 10:22 By: prachij593
Parallel and First_rows Hints By: vikram1780 on Tue, 23 June 2009	1	5690	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	1675	Tue, 23 June 2009 01:41 By: Michel Cadot
performance problem with query By: vikram1780 on Mon, 22 June 2009	3	1981	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	1963	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	8145	Fri, 19 June 2009 02:37 By: trantuananh24hg
Improving Performance of Large Result Set 11g By: jkomorek on Thu, 18 June 2009	9	3491	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	2166	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	1489	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	2842	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	2567	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	10346	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	3774	Fri, 12 June 2009 04:53 By: ykathirv
HINT INDEX Usage 9.2.0.7 By: Brayan on Fri, 12 June 2009	1	1503	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	3691	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	2111	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	2845	Thu, 11 June 2009 09:57 By: farenheiit
Performance Tuning in Count(DISTINCT Oracle 9i By: sivakumar.rj on Wed, 10 June 2009	7	2590	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	9676	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	3723	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	4217	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	5613	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	11664	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	4652	Mon, 01 June 2009 04:49 By: crazypeter2005
IOT - what is that? By: wakula on Fri, 29 May 2009	5	4504	Sat, 30 May 2009 16:54 By: BlackSwan
JDBC connection performance By: estola on Fri, 29 May 2009	1	2180	Sat, 30 May 2009 07:29 By: rleishman
DIFF B/W V$SQL AND V$SQLAREA Oracle Database 10g Release 10.2.0.3.0 By: scaria.grg on Fri, 29 May 2009	1	4197	Fri, 29 May 2009 13:30 By: Michel Cadot
import sql profile with opt_param hnt By: loveoracle on Fri, 29 May 2009	0	7071	Fri, 29 May 2009 04:12 By: loveoracle