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
Very slow commit Oracle XE By: emeded on Fri, 22 May 2009	12	13391	Thu, 28 May 2009 12:43 By: coleing
Need help on Query Tuning By: sivakumar.rj on Thu, 28 May 2009	1	1514	Thu, 28 May 2009 01:05 By: Michel Cadot
Delete statement taking long time in Test database Oracle 9i By: ashwin_1202 on Tue, 26 May 2009	5	2555	Wed, 27 May 2009 21:53 By: rleishman
Database Performance (merged2) 10.2 By: grpatwari on Tue, 26 May 2009	1	3199	Tue, 26 May 2009 01:30 By: Michel Cadot
Oracle 9i Cost very high Oracle 9i By: manoj12 on Mon, 25 May 2009	1	3728	Mon, 25 May 2009 13:34 By: cookiemonster
More archivelogs are generating. Oracle 10.2.0.4, Windows 2003 server By: padhuoracle on Thu, 21 May 2009	9	5403	Sat, 23 May 2009 09:49 By: Michel Cadot
Query tuning By: mukundsahare on Thu, 21 May 2009	7	5669	Fri, 22 May 2009 16:47 By: BlackSwan
Index issue 10.2.0.3, Windows 2003 By: sant_new on Thu, 21 May 2009	11	3259	Fri, 22 May 2009 09:55 By: cookiemonster
Difference between awr metrics By: orausern on Fri, 22 May 2009	4	2426	Fri, 22 May 2009 09:40 By: orausern
Full scan even index being added By: greentea on Thu, 21 May 2009	6	2076	Fri, 22 May 2009 02:01 By: rleishman
setting up performance monitoring on my schema oracle 10.1.0.2.0,red hat linux By: nash12 on Fri, 22 May 2009	1	1265	Fri, 22 May 2009 01:25 By: BlackSwan
Question about AWR 10.2.0.3 on Solaris 10 By: orausern on Thu, 21 May 2009	2	1538	Thu, 21 May 2009 23:28 By: orausern
Performance in joins Oracle,9i,AIX 5.2 By: shahnazurs on Thu, 21 May 2009	4	2181	Thu, 21 May 2009 02:48 By: rleishman
Mysterious Insufficient TEMP Tablespace... By: aimy on Fri, 13 March 2009	24	5201	Wed, 20 May 2009 13:00 By: bangalibor
Query Slow Oracle-9i and 10g By: sbmk_design on Fri, 17 April 2009	10	2801	Wed, 20 May 2009 12:41 By: bangalibor
PERFORMANCE ISSUE - QUERY TUNING Oracle 10g, linux By: sridharst on Mon, 18 May 2009	3	2267	Tue, 19 May 2009 03:40 By: rleishman
performance Tunning By: ORAGENASHOK on Wed, 13 May 2009	13	4105	Tue, 19 May 2009 03:26 By: rleishman
Increasing number of Processes By: nishantprabhakar on Wed, 13 May 2009	8	15032	Mon, 18 May 2009 10:24 By: BlackSwan
Queries on the fly using DBMS_ADVANCED_REWRITE By: nawazijaz on Mon, 26 January 2009	4	3034	Mon, 18 May 2009 08:56 By: JRowbottom
Index is not working properly in my query ? By: tondapi on Sat, 25 April 2009	6	2354	Sun, 17 May 2009 11:00 By: bangalibor
Inner workings: how often is data written to disk By: Joppybt on Tue, 12 May 2009	4	2405	Thu, 14 May 2009 12:08 By: Joppybt
query oracle 10g, Linux By: manijash on Thu, 14 May 2009	3	2024	Thu, 14 May 2009 08:24 By: manijash
Query Optimization (merged) By: sdey on Mon, 11 May 2009	23	3593	Wed, 13 May 2009 10:31 By: JRowbottom
No performance boost after upgrading database server RAM from 3GB to 16G win 3000 Server Enterprise Edition, Oracle 9i (9.2.0.7.0) Enterprise Edition By: dbanukesh on Tue, 05 May 2009	22	11269	Wed, 13 May 2009 04:20 By: dbanukesh
Regarding AWR report 10.2.0.4, Solaris 10 By: harshkumar on Sun, 10 May 2009	1	1619	Sun, 10 May 2009 23:07 By: BlackSwan
Gets and GetHits difference ? By: tridentadm on Sat, 09 May 2009	3	1597	Sun, 10 May 2009 00:14 By: BlackSwan
Query "Statements run in past 24 hrs with execution time" Oracle 10.2.0.4 By: harshkumar on Fri, 08 May 2009	3	2470	Fri, 08 May 2009 12:25 By: Michel Cadot
get list of all sql's executed in a session with out sql trace Oracle, 10g, Unix By: yugi.adapala on Thu, 07 May 2009	6	4364	Fri, 08 May 2009 09:29 By: JRowbottom
10-15 seconds on a 200 record DataSet 9.1 By: rboggess on Thu, 07 May 2009	3	2474	Fri, 08 May 2009 08:03 By: rboggess
Query taking time By: sunilcse1 on Tue, 05 May 2009	14	3230	Fri, 08 May 2009 02:10 By: varu123
Transaction memory/space amount configuration Oracle 10g By: robmaggi on Thu, 07 May 2009	1	1387	Thu, 07 May 2009 09:19 By: BlackSwan
What is High water mark? oracle By: user2004 on Thu, 07 May 2009	6	2351	Thu, 07 May 2009 06:36 By: Michel Cadot
Use of Btree in Oracle: Concept Oracle By: user2004 on Thu, 07 May 2009	1	1383	Thu, 07 May 2009 02:57 By: Michel Cadot
Slow Order by, Index needed? 10g By: filiprus on Tue, 05 May 2009	2	1883	Wed, 06 May 2009 03:27 By: rleishman
UPDATE query with JOIN By: jaytav001 on Tue, 05 May 2009	5	2487	Wed, 06 May 2009 03:22 By: rleishman
Locks in Oracle Oracle 9i By: manoj12 on Tue, 05 May 2009	1	1392	Tue, 05 May 2009 08:24 By: Mahesh Rajendran
configuring undo_retention. By: tridentadm on Mon, 04 May 2009	1	2456	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	2175	Mon, 04 May 2009 01:08 By: Michel Cadot
Hint is not working oracle10g By: shrinika on Thu, 23 April 2009	8	4173	Sun, 03 May 2009 20:49 By: iamadba
value BETWEEN x AND y Oracle 10.2G By: wakula on Thu, 12 March 2009	8	2894	Fri, 01 May 2009 17:33 By: rleishman