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
fast_start_mttr_target By: yash_v on Wed, 05 July 2006	1	2358	Wed, 05 July 2006 13:35 By: srinivas4u2
how to speed up By: dude4084 on Tue, 04 July 2006	1	1536	Tue, 04 July 2006 03:10 By: Mahesh Rajendran
Global Temporary Table - Creating Locks By: gentleman777us on Fri, 30 June 2006	3	9546	Mon, 03 July 2006 06:53 By: Mahesh Rajendran
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006	8	2803	Mon, 03 July 2006 06:15 By: Mahesh Rajendran
Index Creation Speed-up By: ithanver on Mon, 03 July 2006	2	2642	Mon, 03 July 2006 02:46 By: ithanver
Query is slow By: Tai on Sun, 02 July 2006	2	2074	Mon, 03 July 2006 02:02 By: Littlefoot
Pls advice about this EXECUTION PLAN By: gkrishn on Fri, 30 June 2006	4	1828	Sun, 02 July 2006 21:57 By: rleishman
NORMALIZATION AND DENORMALIZATION By: oradba16 on Thu, 29 June 2006	1	5046	Thu, 29 June 2006 05:20 By: JSI2001
RedoLog Contention By: Kavitha Suresh on Wed, 28 June 2006	3	2909	Wed, 28 June 2006 11:54 By: Kavitha Suresh
slow insert/update - same schema on two servers By: SASA on Tue, 27 June 2006	4	2480	Wed, 28 June 2006 02:12 By: SASA
Query performance: Hard code values vs. parmeterized values By: lamhe2804 on Tue, 27 June 2006	1	2072	Tue, 27 June 2006 22:23 By: rleishman
Server Parameters !! By: AlinaC on Thu, 22 June 2006	3	1467	Tue, 27 June 2006 07:24 By: AlinaC
Log filesize By: yash_v on Tue, 27 June 2006	1	1479	Tue, 27 June 2006 06:16 By: JSI2001
low buffer hit ratio By: abs_amit on Mon, 26 June 2006	2	3978	Mon, 26 June 2006 10:08 By: Mahesh Rajendran
convert partition table to normal table By: shaygilad on Mon, 26 June 2006	1	3258	Mon, 26 June 2006 09:05 By: Frank Naude
Configuration of PGA Aggregate Target By: kumarsz on Tue, 06 June 2006	2	7412	Mon, 26 June 2006 06:52 By: jimit_shaili
Question on 10.2.0.2 patch application on 10.2.0.1 database By: rajd on Sun, 25 June 2006	1	3771	Sun, 25 June 2006 19:23 By: Mahesh Rajendran
improve performance of query over dblink. By: rajd on Sun, 25 June 2006	5	5750	Sun, 25 June 2006 17:19 By: rajd
Can I use Pragma Autonomous Transactions for Performance Improvement? By: Abhishek_Gupta on Tue, 20 June 2006	1	3913	Thu, 22 June 2006 17:22 By: andrew again
How to reduce nested loops in a big query? By: Jaime Stuardo on Wed, 21 June 2006	6	3482	Wed, 21 June 2006 09:52 By: Jaime Stuardo
capture users & statements causing archive log full By: jasbosky on Wed, 21 June 2006	1	2302	Wed, 21 June 2006 05:09 By: orausern
How to find the loading session By: akudba on Wed, 21 June 2006	1	1631	Wed, 21 June 2006 04:48 By: Mahesh Rajendran
How to Improve Oracle View Performance By: TheStupid on Tue, 20 June 2006	6	11140	Tue, 20 June 2006 09:39 By: Mahesh Rajendran
Is there any way for defrage the tablespace in linux Os By: jimit_shaili on Mon, 19 June 2006	1	1659	Mon, 19 June 2006 10:49 By: Mahesh Rajendran
Req. help on Temporary Tablespace By: jimit_shaili on Sun, 18 June 2006	1	3129	Sun, 18 June 2006 07:19 By: Mahesh Rajendran
Improving materialized view performance By: ajithgk73 on Fri, 16 June 2006	3	2346	Sat, 17 June 2006 10:47 By: Littlefoot
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006	1	1408	Fri, 16 June 2006 13:08 By: Frank Naude
More "SQL*Net message to/from client" than expected By: YodaBoy on Thu, 15 June 2006	3	4920	Thu, 15 June 2006 17:26 By: BlackSwan
Latch Contention By: vikramjogi on Thu, 15 June 2006	4	2701	Thu, 15 June 2006 13:59 By: vikramjogi
queries on collecting schema statistics (oracle 9i) By: orausern on Wed, 14 June 2006	5	5366	Wed, 14 June 2006 13:15 By: asmishra
is unique index helpful in making query fast? By: a_developer on Wed, 14 June 2006	1	1524	Wed, 14 June 2006 02:35 By: JSI2001
database slow By: chidellanr on Mon, 12 June 2006	2	1360	Mon, 12 June 2006 01:23 By: chidellanr
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING By: orausern on Fri, 09 June 2006	2	4448	Fri, 09 June 2006 09:28 By: orausern
PL/SQL code review tool By: kumarsz on Fri, 09 June 2006	2	3335	Fri, 09 June 2006 07:29 By: kumarsz
Advice By: puneetsachar on Thu, 08 June 2006	2	1701	Fri, 09 June 2006 02:53 By: JSI2001
From where can I get all available SQL tuning HINTS for Oracle? By: mburukimethu on Thu, 08 June 2006	1	1858	Thu, 08 June 2006 13:03 By: BlackSwan
Require Information By: bhoite_amol83 on Thu, 08 June 2006	3	1364	Thu, 08 June 2006 07:36 By: Mahesh Rajendran
Considering constraints By: ehegagoka on Thu, 08 June 2006	3	1291	Thu, 08 June 2006 03:38 By: ehegagoka
I Need information about the value of "row cache enqueue latch" By: crozas on Wed, 07 June 2006	0	3625	Wed, 07 June 2006 14:53 By: crozas
Query is really taking a long time. Please help By: pzlj6x on Fri, 02 June 2006	4	1956	Wed, 07 June 2006 13:18 By: pzlj6x