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	4090	Thu, 06 July 2006 05:09 By: kamunias
Report taking long time By: srinivas4u2 on Wed, 05 July 2006	3	2670	Thu, 06 July 2006 03:12 By: JRowbottom
fast_start_mttr_target By: yash_v on Wed, 05 July 2006	1	2869	Wed, 05 July 2006 13:35 By: srinivas4u2
how to speed up By: dude4084 on Tue, 04 July 2006	1	2306	Tue, 04 July 2006 03:10 By: Mahesh Rajendran
Global Temporary Table - Creating Locks By: gentleman777us on Fri, 30 June 2006	3	10057	Mon, 03 July 2006 06:53 By: Mahesh Rajendran
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006	8	3206	Mon, 03 July 2006 06:15 By: Mahesh Rajendran
Index Creation Speed-up By: ithanver on Mon, 03 July 2006	2	3416	Mon, 03 July 2006 02:46 By: ithanver
Query is slow By: Tai on Sun, 02 July 2006	2	2713	Mon, 03 July 2006 02:02 By: Littlefoot
Pls advice about this EXECUTION PLAN By: gkrishn on Fri, 30 June 2006	4	2248	Sun, 02 July 2006 21:57 By: rleishman
NORMALIZATION AND DENORMALIZATION By: oradba16 on Thu, 29 June 2006	1	5553	Thu, 29 June 2006 05:20 By: JSI2001
RedoLog Contention By: Kavitha Suresh on Wed, 28 June 2006	3	3539	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	3489	Wed, 28 June 2006 02:12 By: SASA
Query performance: Hard code values vs. parmeterized values By: lamhe2804 on Tue, 27 June 2006	1	2578	Tue, 27 June 2006 22:23 By: rleishman
Server Parameters !! By: AlinaC on Thu, 22 June 2006	3	2113	Tue, 27 June 2006 07:24 By: AlinaC
Log filesize By: yash_v on Tue, 27 June 2006	1	1776	Tue, 27 June 2006 06:16 By: JSI2001
low buffer hit ratio By: abs_amit on Mon, 26 June 2006	2	4571	Mon, 26 June 2006 10:08 By: Mahesh Rajendran
convert partition table to normal table By: shaygilad on Mon, 26 June 2006	1	3989	Mon, 26 June 2006 09:05 By: Frank Naude
Configuration of PGA Aggregate Target By: kumarsz on Tue, 06 June 2006	2	8108	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	4062	Sun, 25 June 2006 19:23 By: Mahesh Rajendran
improve performance of query over dblink. By: rajd on Sun, 25 June 2006	5	6685	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	4350	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	4783	Wed, 21 June 2006 09:52 By: Jaime Stuardo
capture users & statements causing archive log full By: jasbosky on Wed, 21 June 2006	1	3080	Wed, 21 June 2006 05:09 By: orausern
How to find the loading session By: akudba on Wed, 21 June 2006	1	2107	Wed, 21 June 2006 04:48 By: Mahesh Rajendran
How to Improve Oracle View Performance By: TheStupid on Tue, 20 June 2006	6	11573	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	2141	Mon, 19 June 2006 10:49 By: Mahesh Rajendran
Req. help on Temporary Tablespace By: jimit_shaili on Sun, 18 June 2006	1	3541	Sun, 18 June 2006 07:19 By: Mahesh Rajendran
Improving materialized view performance By: ajithgk73 on Fri, 16 June 2006	3	3304	Sat, 17 June 2006 10:47 By: Littlefoot
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006	1	2137	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	5597	Thu, 15 June 2006 17:26 By: BlackSwan
Latch Contention By: vikramjogi on Thu, 15 June 2006	4	3700	Thu, 15 June 2006 13:59 By: vikramjogi
queries on collecting schema statistics (oracle 9i) By: orausern on Wed, 14 June 2006	5	6171	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	2004	Wed, 14 June 2006 02:35 By: JSI2001
database slow By: chidellanr on Mon, 12 June 2006	2	2211	Mon, 12 June 2006 01:23 By: chidellanr
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING By: orausern on Fri, 09 June 2006	2	5299	Fri, 09 June 2006 09:28 By: orausern
PL/SQL code review tool By: kumarsz on Fri, 09 June 2006	2	4234	Fri, 09 June 2006 07:29 By: kumarsz
Advice By: puneetsachar on Thu, 08 June 2006	2	2355	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	2332	Thu, 08 June 2006 13:03 By: BlackSwan
Require Information By: bhoite_amol83 on Thu, 08 June 2006	3	2381	Thu, 08 June 2006 07:36 By: Mahesh Rajendran
Considering constraints By: ehegagoka on Thu, 08 June 2006	3	2372	Thu, 08 June 2006 03:38 By: ehegagoka