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
configuring undo_retention. By: tridentadm on Mon, 04 May 2009	1	3048	Mon, 04 May 2009 02:26 By: Michel Cadot
dynamic view to get 'SQL ordered by...' section from AWR By: tridentadm on Mon, 04 May 2009	1	2590	Mon, 04 May 2009 01:08 By: Michel Cadot
Hint is not working oracle10g By: shrinika on Thu, 23 April 2009	8	4831	Sun, 03 May 2009 20:49 By: iamadba
value BETWEEN x AND y Oracle 10.2G By: wakula on Thu, 12 March 2009	8	3481	Fri, 01 May 2009 17:33 By: rleishman
keep pool 10g By: grpatwari on Wed, 22 April 2009	10	4596	Wed, 29 April 2009 08:53 By: JRowbottom
Job queue process takes more then 90 % cpu oracle 10.2.0.4.0,Unbrekable linux By: sameer_2230 on Wed, 29 April 2009	5	5914	Wed, 29 April 2009 05:33 By: babuknb
DBWR writes entire dirty block ? By: tridentadm on Mon, 27 April 2009	4	3884	Mon, 27 April 2009 12:12 By: BlackSwan
Hints USE_HASH (merged) By: Anne Simms on Tue, 31 March 2009	14	8002	Mon, 27 April 2009 08:28 By: Anne Simms
SQL PERFORMANCE ANALYZER Oracle 11g Rel1 , RHEL AS4 By: rsreddy28 on Sun, 26 April 2009	1	3072	Sun, 26 April 2009 08:09 By: Mahesh Rajendran
Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Fri, 17 April 2009	10	6328	Sat, 25 April 2009 21:31 By: rleishman
PL SQL performance tuning Oracle 10g By: vinod_tiwari on Tue, 21 April 2009	3	3099	Tue, 21 April 2009 22:01 By: rleishman
The difference of execution plans By: dingwei on Sun, 19 April 2009	0	6663	Sun, 19 April 2009 01:11 By: dingwei
SQL too slow 10g 10.1.0.2.0 - xp By: rzkhan on Thu, 16 April 2009	8	3645	Fri, 17 April 2009 08:47 By: BlackSwan
Query is getting stuck after adding one filter condition is where clause 9I, Windows By: gurinder_mann2004 on Fri, 10 April 2009	8	4677	Fri, 17 April 2009 00:15 By: gurinder_mann2004
problem while generating AWR report By: rituraj on Tue, 14 April 2009	8	9409	Thu, 16 April 2009 12:01 By: Mahesh Rajendran
improve the performance (merged 2) By: swas_fly on Wed, 15 April 2009	10	2884	Thu, 16 April 2009 06:40 By: JRowbottom
want to change snap level in 10g r2 By: rituraj on Tue, 14 April 2009	1	4420	Tue, 14 April 2009 12:42 By: BlackSwan
improving query performance oracle 10g By: swas_fly on Tue, 14 April 2009	1	2260	Tue, 14 April 2009 12:29 By: Michel Cadot
Explain Plan Oracle Database 10g Release 10.1.0.2.0 - 64bi ,HP-UX B.11.23 By: vinniora on Tue, 14 April 2009	1	2439	Tue, 14 April 2009 01:13 By: Michel Cadot
TKprof shows fetching taking long time Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: spur230 on Wed, 01 April 2009	7	8682	Sun, 12 April 2009 23:16 By: rleishman
create dynamic partitions in oracle 9 oracle9i/ windows By: parasuramchekuri on Fri, 10 April 2009	9	8372	Sat, 11 April 2009 07:25 By: rleishman
Bind variable versus CURSOR_SHARING='SIMILAR' oracle10g By: shrinika on Fri, 10 April 2009	3	6246	Fri, 10 April 2009 23:19 By: trantuananh24hg
List partition and Index partitioning (merged) By: jimit_shaili on Mon, 06 April 2009	14	4102	Fri, 10 April 2009 00:34 By: jimit_shaili
Can any one help me to tune this query. By: vipinsonkar2000 on Sat, 04 April 2009	9	3029	Thu, 09 April 2009 05:07 By: JRowbottom
PCTFREE and PCTUSED 10g Warehouse database on RHEL4 By: nandusb on Sat, 21 March 2009	5	5203	Thu, 09 April 2009 02:39 By: Michel Cadot
Report Taking So Much Of Time and goes into ORA-01555 Oracle Apps 11.5.10.2 By: sumitgarg on Wed, 08 April 2009	4	4935	Wed, 08 April 2009 23:13 By: sumitgarg
how to optimize sql for query big table? (merged 3) By: kevin_ye on Wed, 08 April 2009	3	3769	Wed, 08 April 2009 21:25 By: kevin_ye
SQL Tuning Help Oracle 10g By: crazykuda on Wed, 08 April 2009	1	2971	Wed, 08 April 2009 15:08 By: BlackSwan
ORA-00604: error occurred at recursive SQL level x Oracle 10.1.2.0 Windows 2003 By: rakesh.c.purohit on Wed, 08 April 2009	1	2172	Wed, 08 April 2009 08:47 By: Mahesh Rajendran
v$session output oracle 10203 /AIX 5.3 By: loveoracle on Mon, 06 April 2009	9	4323	Tue, 07 April 2009 05:55 By: Michel Cadot
Temp Tablespace usage Oracle 9.2.0.7 AIX By: dbcop on Sat, 04 April 2009	1	3294	Sat, 04 April 2009 19:18 By: oraxperts
difference between analyze table and dbms_stats.gatherstatistic By: rituraj on Thu, 02 April 2009	2	4013	Thu, 02 April 2009 09:25 By: BlackSwan
'show parameter allow' doesnt work oracle 9.2 By: rituraj on Wed, 01 April 2009	5	3241	Wed, 01 April 2009 13:55 By: rituraj
how to give kill session priviledge to normal user By: rituraj on Wed, 01 April 2009	3	3054	Wed, 01 April 2009 11:14 By: Michel Cadot
contention on temprary tablespace oracle 9.2 By: rituraj on Wed, 01 April 2009	3	2546	Wed, 01 April 2009 11:12 By: Mahesh Rajendran
Performance degrades suddenly. 10.2.0.4/Solaris 10 By: it_me24 on Mon, 30 March 2009	10	4009	Wed, 01 April 2009 05:12 By: rleishman
bad index choose when using rownum < 9 or less 10.2.0.4 AIX 5 By: lionel.ducret on Tue, 31 March 2009	1	1924	Wed, 01 April 2009 03:15 By: dingwei
KEEP POOL Oacle 11g on Solaris10 By: AlinaC on Tue, 31 March 2009	3	2970	Tue, 31 March 2009 21:06 By: BlackSwan
What if not give any ext in datafile........ By: sameer_2230 on Sat, 28 March 2009	2	2507	Mon, 30 March 2009 10:09 By: JRowbottom
AWR report analysis Oracle Serer, 10g R2 , RH By: John Charles on Mon, 30 March 2009	0	8950	Mon, 30 March 2009 02:34 By: John Charles