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
Why size log_buffer have no equal? By: kamunias on Thu, 06 July 2006	0	4076	Thu, 06 July 2006 05:09 By: kamunias
Report taking long time By: srinivas4u2 on Wed, 05 July 2006	3	2652	Thu, 06 July 2006 03:12 By: JRowbottom
fast_start_mttr_target By: yash_v on Wed, 05 July 2006	1	2853	Wed, 05 July 2006 13:35 By: srinivas4u2
how to speed up By: dude4084 on Tue, 04 July 2006	1	2288	Tue, 04 July 2006 03:10 By: Mahesh Rajendran
Global Temporary Table - Creating Locks By: gentleman777us on Fri, 30 June 2006	3	10025	Mon, 03 July 2006 06:53 By: Mahesh Rajendran
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006	8	3170	Mon, 03 July 2006 06:15 By: Mahesh Rajendran
Index Creation Speed-up By: ithanver on Mon, 03 July 2006	2	3392	Mon, 03 July 2006 02:46 By: ithanver
Query is slow By: Tai on Sun, 02 July 2006	2	2686	Mon, 03 July 2006 02:02 By: Littlefoot
Pls advice about this EXECUTION PLAN By: gkrishn on Fri, 30 June 2006	4	2180	Sun, 02 July 2006 21:57 By: rleishman
NORMALIZATION AND DENORMALIZATION By: oradba16 on Thu, 29 June 2006	1	5520	Thu, 29 June 2006 05:20 By: JSI2001
RedoLog Contention By: Kavitha Suresh on Wed, 28 June 2006	3	3509	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	3464	Wed, 28 June 2006 02:12 By: SASA
Query performance: Hard code values vs. parmeterized values By: lamhe2804 on Tue, 27 June 2006	1	2553	Tue, 27 June 2006 22:23 By: rleishman
Server Parameters !! By: AlinaC on Thu, 22 June 2006	3	2081	Tue, 27 June 2006 07:24 By: AlinaC
Log filesize By: yash_v on Tue, 27 June 2006	1	1755	Tue, 27 June 2006 06:16 By: JSI2001
low buffer hit ratio By: abs_amit on Mon, 26 June 2006	2	4532	Mon, 26 June 2006 10:08 By: Mahesh Rajendran
convert partition table to normal table By: shaygilad on Mon, 26 June 2006	1	3961	Mon, 26 June 2006 09:05 By: Frank Naude
Configuration of PGA Aggregate Target By: kumarsz on Tue, 06 June 2006	2	8075	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	4037	Sun, 25 June 2006 19:23 By: Mahesh Rajendran
improve performance of query over dblink. By: rajd on Sun, 25 June 2006	5	6647	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	4315	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	4745	Wed, 21 June 2006 09:52 By: Jaime Stuardo
capture users & statements causing archive log full By: jasbosky on Wed, 21 June 2006	1	3059	Wed, 21 June 2006 05:09 By: orausern
How to find the loading session By: akudba on Wed, 21 June 2006	1	2090	Wed, 21 June 2006 04:48 By: Mahesh Rajendran
How to Improve Oracle View Performance By: TheStupid on Tue, 20 June 2006	6	11527	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	2129	Mon, 19 June 2006 10:49 By: Mahesh Rajendran
Req. help on Temporary Tablespace By: jimit_shaili on Sun, 18 June 2006	1	3526	Sun, 18 June 2006 07:19 By: Mahesh Rajendran
Improving materialized view performance By: ajithgk73 on Fri, 16 June 2006	3	3282	Sat, 17 June 2006 10:47 By: Littlefoot
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006	1	2114	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	5577	Thu, 15 June 2006 17:26 By: BlackSwan
Latch Contention By: vikramjogi on Thu, 15 June 2006	4	3676	Thu, 15 June 2006 13:59 By: vikramjogi
queries on collecting schema statistics (oracle 9i) By: orausern on Wed, 14 June 2006	5	6129	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	1981	Wed, 14 June 2006 02:35 By: JSI2001
database slow By: chidellanr on Mon, 12 June 2006	2	2195	Mon, 12 June 2006 01:23 By: chidellanr
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING By: orausern on Fri, 09 June 2006	2	5266	Fri, 09 June 2006 09:28 By: orausern
PL/SQL code review tool By: kumarsz on Fri, 09 June 2006	2	4173	Fri, 09 June 2006 07:29 By: kumarsz
Advice By: puneetsachar on Thu, 08 June 2006	2	2318	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	2306	Thu, 08 June 2006 13:03 By: BlackSwan
Require Information By: bhoite_amol83 on Thu, 08 June 2006	3	2344	Thu, 08 June 2006 07:36 By: Mahesh Rajendran
Considering constraints By: ehegagoka on Thu, 08 June 2006	3	2327	Thu, 08 June 2006 03:38 By: ehegagoka