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
DIFF B/W V$SQL AND V$SQLAREA Oracle Database 10g Release 10.2.0.3.0 By: scaria.grg on Fri, 29 May 2009	1	4746	Fri, 29 May 2009 13:30 By: Michel Cadot
import sql profile with opt_param hnt By: loveoracle on Fri, 29 May 2009	0	7299	Fri, 29 May 2009 04:12 By: loveoracle
Very slow commit Oracle XE By: emeded on Fri, 22 May 2009	12	14126	Thu, 28 May 2009 12:43 By: coleing
Need help on Query Tuning By: sivakumar.rj on Thu, 28 May 2009	1	2026	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	3877	Wed, 27 May 2009 21:53 By: rleishman
Database Performance (merged2) 10.2 By: grpatwari on Tue, 26 May 2009	1	3569	Tue, 26 May 2009 01:30 By: Michel Cadot
Oracle 9i Cost very high Oracle 9i By: manoj12 on Mon, 25 May 2009	1	4035	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	5916	Sat, 23 May 2009 09:49 By: Michel Cadot
Query tuning By: mukundsahare on Thu, 21 May 2009	7	6080	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	3786	Fri, 22 May 2009 09:55 By: cookiemonster
Difference between awr metrics By: orausern on Fri, 22 May 2009	4	3114	Fri, 22 May 2009 09:40 By: orausern
Full scan even index being added By: greentea on Thu, 21 May 2009	6	2789	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	1692	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	2349	Thu, 21 May 2009 23:28 By: orausern
Performance in joins Oracle,9i,AIX 5.2 By: shahnazurs on Thu, 21 May 2009	4	2621	Thu, 21 May 2009 02:48 By: rleishman
Mysterious Insufficient TEMP Tablespace... By: aimy on Fri, 13 March 2009	24	6060	Wed, 20 May 2009 13:00 By: bangalibor
Query Slow Oracle-9i and 10g By: sbmk_design on Fri, 17 April 2009	10	4625	Wed, 20 May 2009 12:41 By: bangalibor
PERFORMANCE ISSUE - QUERY TUNING Oracle 10g, linux By: sridharst on Mon, 18 May 2009	3	2782	Tue, 19 May 2009 03:40 By: rleishman
performance Tunning By: ORAGENASHOK on Wed, 13 May 2009	13	4907	Tue, 19 May 2009 03:26 By: rleishman
Increasing number of Processes By: nishantprabhakar on Wed, 13 May 2009	8	15628	Mon, 18 May 2009 10:24 By: BlackSwan
Queries on the fly using DBMS_ADVANCED_REWRITE By: nawazijaz on Mon, 26 January 2009	4	3386	Mon, 18 May 2009 08:56 By: JRowbottom
Index is not working properly in my query ? By: tondapi on Sat, 25 April 2009	6	3802	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	2784	Thu, 14 May 2009 12:08 By: Joppybt
query oracle 10g, Linux By: manijash on Thu, 14 May 2009	3	2700	Thu, 14 May 2009 08:24 By: manijash
Query Optimization (merged) By: sdey on Mon, 11 May 2009	23	4407	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	13517	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	2024	Sun, 10 May 2009 23:07 By: BlackSwan
Gets and GetHits difference ? By: tridentadm on Sat, 09 May 2009	3	1993	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	3326	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	5503	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	3371	Fri, 08 May 2009 08:03 By: rboggess
Query taking time By: sunilcse1 on Tue, 05 May 2009	14	3907	Fri, 08 May 2009 02:10 By: varu123
Transaction memory/space amount configuration Oracle 10g By: robmaggi on Thu, 07 May 2009	1	1847	Thu, 07 May 2009 09:19 By: BlackSwan
What is High water mark? oracle By: user2004 on Thu, 07 May 2009	6	3487	Thu, 07 May 2009 06:36 By: Michel Cadot
Use of Btree in Oracle: Concept Oracle By: user2004 on Thu, 07 May 2009	1	1716	Thu, 07 May 2009 02:57 By: Michel Cadot
Slow Order by, Index needed? 10g By: filiprus on Tue, 05 May 2009	2	2208	Wed, 06 May 2009 03:27 By: rleishman
UPDATE query with JOIN By: jaytav001 on Tue, 05 May 2009	5	2844	Wed, 06 May 2009 03:22 By: rleishman
Locks in Oracle Oracle 9i By: manoj12 on Tue, 05 May 2009	1	1922	Tue, 05 May 2009 08:24 By: Mahesh Rajendran
configuring undo_retention. By: tridentadm on Mon, 04 May 2009	1	2925	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	2482	Mon, 04 May 2009 01:08 By: Michel Cadot