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
The time of 1 Query is more than 1 hour, HELP Â¡Â¡Â¡ By: IngRMP on Mon, 19 September 2005	1	818	Mon, 19 September 2005 08:05 By: Art Metzer
Difference in retrieving number of rows between two queries By: sharan_it on Mon, 05 September 2005	3	1683	Fri, 16 September 2005 04:12 By: sharan_it
Execution plan misleads me (merged cross-posts) By: randres on Thu, 15 September 2005	9	1107	Fri, 16 September 2005 02:28 By: randres
how to find out if a table has dirty blocks in buffers By: nile on Thu, 08 September 2005	23	7063	Fri, 16 September 2005 01:41 By: nile
Oracle9i Function Base index? By: mitra fatolahi on Tue, 13 September 2005	1	1738	Tue, 13 September 2005 16:00 By: smartin
different performance results in Oracle9i vs. MSSQL Server 2000 By: mitra fatolahi on Mon, 12 September 2005	2	1044	Mon, 12 September 2005 14:12 By: Mahesh Rajendran
Can I change the DB_BLOCK_SIZE in Oracle 9i? By: merovingio on Fri, 09 September 2005	7	24400	Mon, 12 September 2005 14:07 By: merovingio
Resolving "latch free" problems By: cubittm on Thu, 01 September 2005	1	34399	Mon, 12 September 2005 08:29 By: Frank Naude
Function Index, is there a limit to the complexity ? By: deadpoet on Fri, 09 September 2005	1	1006	Fri, 09 September 2005 10:27 By: smartin
error while taking snapshot..!! By: balavignesh on Wed, 07 September 2005	3	1545	Thu, 08 September 2005 11:57 By: rsone
How to stop the Cache Effect ? By: deadpoet on Tue, 09 August 2005	21	2518	Wed, 07 September 2005 14:19 By: nile
How I can remove the table from cache? Which command I should execute By: lanag on Fri, 12 August 2005	4	1115	Tue, 06 September 2005 15:49 By: smartin
index ignored problem By: mjschwenger on Fri, 02 September 2005	5	1421	Fri, 02 September 2005 14:29 By: mjschwenger
Using Hint By: ynaiyer on Fri, 02 September 2005	2	1025	Fri, 02 September 2005 11:27 By: Art Metzer
Multiple Tablespaces By: David King on Wed, 31 August 2005	2	1018	Thu, 01 September 2005 09:56 By: smartin
Union takes more time please help By: misha603 on Wed, 31 August 2005	3	2651	Thu, 01 September 2005 09:48 By: smartin
To increase performance Delete statement By: ashishodia on Wed, 31 August 2005	5	4820	Thu, 01 September 2005 06:23 By: IngRMP
query tuning with NVL By: hrishy on Wed, 24 August 2005	1	3987	Thu, 01 September 2005 03:59 By: Frank Naude
performance tuning By: dinakar5008 on Sun, 28 August 2005	4	1300	Wed, 31 August 2005 16:15 By: ChrisJr
How to use index in date column By: d.dineshkumar on Thu, 18 August 2005	5	5206	Wed, 31 August 2005 09:16 By: d.dineshkumar
Update issue with high volume table By: Nits on Mon, 29 August 2005	2	986	Tue, 30 August 2005 09:23 By: Nits
highly skewed data distribution By: sebastianR on Thu, 25 August 2005	5	1960	Mon, 29 August 2005 08:21 By: sebastianR
clustering vs. reorganization By: sebastianR on Mon, 29 August 2005	0	1935	Mon, 29 August 2005 05:15 By: sebastianR
slow DB server By: manu_jariwala on Wed, 17 August 2005	5	7251	Fri, 26 August 2005 08:18 By: manu_jariwala
Optimizer=Choose Error By: Scott Cowan on Fri, 26 August 2005	0	1963	Fri, 26 August 2005 06:58 By: Scott Cowan
How test performance of table? and how to calucalate row size min and max of the Table By: sponguru_dba on Tue, 23 August 2005	2	939	Thu, 25 August 2005 14:34 By: vjeedigunta
tune the query By: ponnilavan on Tue, 23 August 2005	2	1466	Thu, 25 August 2005 14:27 By: vjeedigunta
Query Performance By: jilpangs on Wed, 24 August 2005	1	1069	Thu, 25 August 2005 14:25 By: vjeedigunta
how to figure out checkpoint running slow By: rkl1 on Mon, 22 August 2005	1	975	Wed, 24 August 2005 07:43 By: deepa_balu
Partitioning of tables need sugession By: ashishodia on Wed, 24 August 2005	1	666	Wed, 24 August 2005 04:25 By: girish.rohini
Users and default optimizer_mode By: Scott Cowan on Tue, 23 August 2005	2	1403	Tue, 23 August 2005 07:57 By: Scott Cowan
log file sync waits By: mjschwenger on Wed, 17 August 2005	5	8188	Mon, 22 August 2005 08:37 By: smartin
precise question: use a histogram here? By: sebastianR on Mon, 22 August 2005	1	992	Mon, 22 August 2005 07:46 By: smartin
How to rewrite a query By: mjschwenger on Sun, 21 August 2005	4	2547	Sun, 21 August 2005 17:10 By: Barbara Boehmer
Hints on a poor performing view By: scottwmackey on Thu, 18 August 2005	7	1927	Fri, 19 August 2005 11:41 By: scottwmackey
index performing bad By: sebastianR on Fri, 19 August 2005	6	1248	Fri, 19 August 2005 09:25 By: smartin
Strange Database Shutdowns By: rkl1 on Tue, 16 August 2005	1	888	Fri, 19 August 2005 02:24 By: kugenuma
Drill to Evaluate By: rkl1 on Thu, 18 August 2005	1	761	Fri, 19 August 2005 02:20 By: kugenuma
tuning with statpack By: mjschwenger on Thu, 18 August 2005	1	1214	Fri, 19 August 2005 01:59 By: kugenuma
Selecivity on like in a query By: stsy on Thu, 18 August 2005	0	1824	Thu, 18 August 2005 07:18 By: stsy