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
Pro C report not working . Is the problem PC -related ? By: vivekpatil on Fri, 07 July 2006	4	3307	Fri, 07 July 2006 07:37 By: JSI2001
VW_NSO_1 !! By: AlinaC on Fri, 07 July 2006	1	10805	Fri, 07 July 2006 07:14 By: Art Metzer
Why size log_buffer have no equal? By: kamunias on Thu, 06 July 2006	0	4245	Thu, 06 July 2006 05:09 By: kamunias
Report taking long time By: srinivas4u2 on Wed, 05 July 2006	3	2914	Thu, 06 July 2006 03:12 By: JRowbottom
fast_start_mttr_target By: yash_v on Wed, 05 July 2006	1	3052	Wed, 05 July 2006 13:35 By: srinivas4u2
how to speed up By: dude4084 on Tue, 04 July 2006	1	2498	Tue, 04 July 2006 03:10 By: Mahesh Rajendran
Global Temporary Table - Creating Locks By: gentleman777us on Fri, 30 June 2006	3	10393	Mon, 03 July 2006 06:53 By: Mahesh Rajendran
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006	8	3563	Mon, 03 July 2006 06:15 By: Mahesh Rajendran
Index Creation Speed-up By: ithanver on Mon, 03 July 2006	2	3624	Mon, 03 July 2006 02:46 By: ithanver
Query is slow By: Tai on Sun, 02 July 2006	2	2933	Mon, 03 July 2006 02:02 By: Littlefoot
Pls advice about this EXECUTION PLAN By: gkrishn on Fri, 30 June 2006	4	2537	Sun, 02 July 2006 21:57 By: rleishman
NORMALIZATION AND DENORMALIZATION By: oradba16 on Thu, 29 June 2006	1	5738	Thu, 29 June 2006 05:20 By: JSI2001
RedoLog Contention By: Kavitha Suresh on Wed, 28 June 2006	3	3792	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	3757	Wed, 28 June 2006 02:12 By: SASA
Query performance: Hard code values vs. parmeterized values By: lamhe2804 on Tue, 27 June 2006	1	2752	Tue, 27 June 2006 22:23 By: rleishman
Server Parameters !! By: AlinaC on Thu, 22 June 2006	3	2369	Tue, 27 June 2006 07:24 By: AlinaC
Log filesize By: yash_v on Tue, 27 June 2006	1	1975	Tue, 27 June 2006 06:16 By: JSI2001
low buffer hit ratio By: abs_amit on Mon, 26 June 2006	2	4783	Mon, 26 June 2006 10:08 By: Mahesh Rajendran
convert partition table to normal table By: shaygilad on Mon, 26 June 2006	1	4160	Mon, 26 June 2006 09:05 By: Frank Naude
Configuration of PGA Aggregate Target By: kumarsz on Tue, 06 June 2006	2	8352	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	4249	Sun, 25 June 2006 19:23 By: Mahesh Rajendran
improve performance of query over dblink. By: rajd on Sun, 25 June 2006	5	7026	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	4589	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	5181	Wed, 21 June 2006 09:52 By: Jaime Stuardo
capture users & statements causing archive log full By: jasbosky on Wed, 21 June 2006	1	3259	Wed, 21 June 2006 05:09 By: orausern
How to find the loading session By: akudba on Wed, 21 June 2006	1	2290	Wed, 21 June 2006 04:48 By: Mahesh Rajendran
How to Improve Oracle View Performance By: TheStupid on Tue, 20 June 2006	6	11938	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	2324	Mon, 19 June 2006 10:49 By: Mahesh Rajendran
Req. help on Temporary Tablespace By: jimit_shaili on Sun, 18 June 2006	1	3727	Sun, 18 June 2006 07:19 By: Mahesh Rajendran
Improving materialized view performance By: ajithgk73 on Fri, 16 June 2006	3	3548	Sat, 17 June 2006 10:47 By: Littlefoot
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006	1	2319	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	5841	Thu, 15 June 2006 17:26 By: BlackSwan
Latch Contention By: vikramjogi on Thu, 15 June 2006	4	4016	Thu, 15 June 2006 13:59 By: vikramjogi
queries on collecting schema statistics (oracle 9i) By: orausern on Wed, 14 June 2006	5	6552	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	2194	Wed, 14 June 2006 02:35 By: JSI2001
database slow By: chidellanr on Mon, 12 June 2006	2	2401	Mon, 12 June 2006 01:23 By: chidellanr
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING By: orausern on Fri, 09 June 2006	2	5498	Fri, 09 June 2006 09:28 By: orausern
PL/SQL code review tool By: kumarsz on Fri, 09 June 2006	2	4465	Fri, 09 June 2006 07:29 By: kumarsz
Advice By: puneetsachar on Thu, 08 June 2006	2	2594	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	2515	Thu, 08 June 2006 13:03 By: BlackSwan