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
VW_NSO_1 !! By: AlinaC on Fri, 07 July 2006	1	10606	Fri, 07 July 2006 07:14 By: Art Metzer
Why size log_buffer have no equal? By: kamunias on Thu, 06 July 2006	0	4130	Thu, 06 July 2006 05:09 By: kamunias
Report taking long time By: srinivas4u2 on Wed, 05 July 2006	3	2724	Thu, 06 July 2006 03:12 By: JRowbottom
fast_start_mttr_target By: yash_v on Wed, 05 July 2006	1	2922	Wed, 05 July 2006 13:35 By: srinivas4u2
how to speed up By: dude4084 on Tue, 04 July 2006	1	2358	Tue, 04 July 2006 03:10 By: Mahesh Rajendran
Global Temporary Table - Creating Locks By: gentleman777us on Fri, 30 June 2006	3	10156	Mon, 03 July 2006 06:53 By: Mahesh Rajendran
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006	8	3320	Mon, 03 July 2006 06:15 By: Mahesh Rajendran
Index Creation Speed-up By: ithanver on Mon, 03 July 2006	2	3471	Mon, 03 July 2006 02:46 By: ithanver
Query is slow By: Tai on Sun, 02 July 2006	2	2767	Mon, 03 July 2006 02:02 By: Littlefoot
Pls advice about this EXECUTION PLAN By: gkrishn on Fri, 30 June 2006	4	2318	Sun, 02 July 2006 21:57 By: rleishman
NORMALIZATION AND DENORMALIZATION By: oradba16 on Thu, 29 June 2006	1	5608	Thu, 29 June 2006 05:20 By: JSI2001
RedoLog Contention By: Kavitha Suresh on Wed, 28 June 2006	3	3596	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	3551	Wed, 28 June 2006 02:12 By: SASA
Query performance: Hard code values vs. parmeterized values By: lamhe2804 on Tue, 27 June 2006	1	2630	Tue, 27 June 2006 22:23 By: rleishman
Server Parameters !! By: AlinaC on Thu, 22 June 2006	3	2190	Tue, 27 June 2006 07:24 By: AlinaC
Log filesize By: yash_v on Tue, 27 June 2006	1	1846	Tue, 27 June 2006 06:16 By: JSI2001
low buffer hit ratio By: abs_amit on Mon, 26 June 2006	2	4635	Mon, 26 June 2006 10:08 By: Mahesh Rajendran
convert partition table to normal table By: shaygilad on Mon, 26 June 2006	1	4038	Mon, 26 June 2006 09:05 By: Frank Naude
Configuration of PGA Aggregate Target By: kumarsz on Tue, 06 June 2006	2	8182	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	4129	Sun, 25 June 2006 19:23 By: Mahesh Rajendran
improve performance of query over dblink. By: rajd on Sun, 25 June 2006	5	6800	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	4430	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	4883	Wed, 21 June 2006 09:52 By: Jaime Stuardo
capture users & statements causing archive log full By: jasbosky on Wed, 21 June 2006	1	3124	Wed, 21 June 2006 05:09 By: orausern
How to find the loading session By: akudba on Wed, 21 June 2006	1	2149	Wed, 21 June 2006 04:48 By: Mahesh Rajendran
How to Improve Oracle View Performance By: TheStupid on Tue, 20 June 2006	6	11708	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	2197	Mon, 19 June 2006 10:49 By: Mahesh Rajendran
Req. help on Temporary Tablespace By: jimit_shaili on Sun, 18 June 2006	1	3599	Sun, 18 June 2006 07:19 By: Mahesh Rajendran
Improving materialized view performance By: ajithgk73 on Fri, 16 June 2006	3	3377	Sat, 17 June 2006 10:47 By: Littlefoot
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006	1	2191	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	5663	Thu, 15 June 2006 17:26 By: BlackSwan
Latch Contention By: vikramjogi on Thu, 15 June 2006	4	3776	Thu, 15 June 2006 13:59 By: vikramjogi
queries on collecting schema statistics (oracle 9i) By: orausern on Wed, 14 June 2006	5	6268	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	2056	Wed, 14 June 2006 02:35 By: JSI2001
database slow By: chidellanr on Mon, 12 June 2006	2	2268	Mon, 12 June 2006 01:23 By: chidellanr
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING By: orausern on Fri, 09 June 2006	2	5361	Fri, 09 June 2006 09:28 By: orausern
PL/SQL code review tool By: kumarsz on Fri, 09 June 2006	2	4295	Fri, 09 June 2006 07:29 By: kumarsz
Advice By: puneetsachar on Thu, 08 June 2006	2	2426	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	2388	Thu, 08 June 2006 13:03 By: BlackSwan
Require Information By: bhoite_amol83 on Thu, 08 June 2006	3	2456	Thu, 08 June 2006 07:36 By: Mahesh Rajendran