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
Redo Size doesn't increase more than 260MB HP-UX 11.23, Oracle 9.2i By: dongyoon.ka on Fri, 10 July 2009	1	2643	Fri, 10 July 2009 01:45 By: Michel Cadot
Performance question Oracle9.2.0.3 By: Olivia on Tue, 07 July 2009	3	2502	Thu, 09 July 2009 15:40 By: coleing
SYSTEM TS is increasing 10g RAC HP UX By: madhavamanohar on Wed, 08 July 2009	2	4350	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	2774	Tue, 07 July 2009 04:38 By: jmoran
Performance question Oracle 9.2.0.3 By: prachij593 on Mon, 06 July 2009	5	4330	Tue, 07 July 2009 01:07 By: Michel Cadot
query_rewrite_enabled 10G By: farenheiit on Fri, 03 July 2009	4	6104	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	2566	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	2408	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	3431	Thu, 02 July 2009 03:15 By: TRaj
choose which index to be create (merged) By: suryakantnirala on Wed, 01 July 2009	2	2332	Wed, 01 July 2009 08:45 By: cookiemonster
oracle 11g - 11.0.7.0 solaris 10 By: dirish on Wed, 01 July 2009	4	3909	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	3400	Fri, 26 June 2009 16:42 By: varunvir
BACKUP OF HISTOGRAMS Oracle 10g By: arunprasad_bh on Fri, 26 June 2009	1	2489	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	3484	Thu, 25 June 2009 10:29 By: prachij593
Performance tuning Oracle 10.2.0.3.0 By: deepbans on Tue, 23 June 2009	7	3100	Thu, 25 June 2009 10:22 By: prachij593
Parallel and First_rows Hints By: vikram1780 on Tue, 23 June 2009	1	6398	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	2438	Tue, 23 June 2009 01:41 By: Michel Cadot
performance problem with query By: vikram1780 on Mon, 22 June 2009	3	2384	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	2382	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	8761	Fri, 19 June 2009 02:37 By: trantuananh24hg
Improving Performance of Large Result Set 11g By: jkomorek on Thu, 18 June 2009	9	4064	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	2474	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	2364	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	3742	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	4392	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	11186	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	4342	Fri, 12 June 2009 04:53 By: ykathirv
HINT INDEX Usage 9.2.0.7 By: Brayan on Fri, 12 June 2009	1	1793	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	5755	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	2679	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	3163	Thu, 11 June 2009 09:57 By: farenheiit
Performance Tuning in Count(DISTINCT Oracle 9i By: sivakumar.rj on Wed, 10 June 2009	7	3012	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	10108	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	4367	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	4724	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	6251	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	12133	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	5287	Mon, 01 June 2009 04:49 By: crazypeter2005
IOT - what is that? By: wakula on Fri, 29 May 2009	5	5883	Sat, 30 May 2009 16:54 By: BlackSwan
JDBC connection performance By: estola on Fri, 29 May 2009	1	2545	Sat, 30 May 2009 07:29 By: rleishman