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
How to re-write th eprocedure...? oracle 9.0.1 By: gksenthilkumar on Tue, 01 April 2008	5	1734	Tue, 01 April 2008 23:28 By: BlackSwan
optimzier RULE 10, sun By: lioracle on Mon, 31 March 2008	6	2447	Tue, 01 April 2008 21:56 By: BlackSwan
Bucketing Query Performance By: verpies on Fri, 28 March 2008	19	7482	Tue, 01 April 2008 17:34 By: rleishman
Oracle execution plan help needed Oracle 8i By: gangulyz on Tue, 01 April 2008	2	1165	Tue, 01 April 2008 07:22 By: gangulyz
'EXISTS' vs 'IN' By: vkrn on Tue, 01 April 2008	1	1501	Tue, 01 April 2008 00:21 By: Michel Cadot
SQL Query behaving weirdly in 10g 10g By: hrsiddareddy on Fri, 28 March 2008	4	1852	Mon, 31 March 2008 16:37 By: Kevin Meade
db_cache_size Oracle 10.2.3, SunOS sun11 5.9 By: lotusdeva on Fri, 28 March 2008	6	13553	Mon, 31 March 2008 11:33 By: lotusdeva
Statspack oracle 9i By: sudhir1582 on Mon, 31 March 2008	4	1653	Mon, 31 March 2008 06:31 By: sudhir1582
reg performance tuning concept oracle 10g By: ram anand on Mon, 31 March 2008	3	1344	Mon, 31 March 2008 05:34 By: Michel Cadot
performance problem with DATE field Comparison Oracle 9i By: me_arindam on Wed, 26 March 2008	4	2704	Mon, 31 March 2008 02:23 By: me_arindam
Creating Materialized View using Union All Operator Windows, Oracle 9iR2 By: ajitpal.s on Sun, 30 March 2008	4	5112	Sun, 30 March 2008 22:07 By: ajitpal.s
bulkloading oracle9i By: hindolsaha on Fri, 28 March 2008	1	1353	Fri, 28 March 2008 08:22 By: Frank Naude
Query takes long time to execute first time By: emilSverige on Thu, 20 March 2008	9	3826	Thu, 27 March 2008 17:11 By: emilSverige
How to do update statistics on oracle 10g database 10g By: brandond on Thu, 27 March 2008	3	7277	Thu, 27 March 2008 12:58 By: Michel Cadot
CAN ANY ONE PROVIDE ME THE STATSPACK SCRIPTS By: manoj12 on Thu, 27 March 2008	4	1724	Thu, 27 March 2008 05:37 By: manoj12
Check and telll whether the following configuration is correct or not By: manoj12 on Mon, 24 March 2008	10	1982	Thu, 27 March 2008 00:19 By: manoj12
Summary table Update statement. By: arksjd on Wed, 26 March 2008	3	1309	Wed, 26 March 2008 21:00 By: rleishman
Partitioning effect By: hadinatayp on Wed, 26 March 2008	4	1254	Wed, 26 March 2008 06:51 By: rleishman
Usuage of hints. By: vkrn on Tue, 25 March 2008	2	1185	Tue, 25 March 2008 18:34 By: gintsp
Oracle HASH GROUP BY & SORT GROUP BY performance Oracle 10g By: rkg_007 on Tue, 25 March 2008	8	26649	Tue, 25 March 2008 18:32 By: gintsp
altering rollback segment oracle 9i By: chriswitt on Tue, 25 March 2008	5	1735	Tue, 25 March 2008 15:17 By: Michel Cadot
usuage of DECODE By: vkrn on Tue, 25 March 2008	9	2178	Tue, 25 March 2008 09:01 By: vkrn
Performance of a query By: manoj12 on Tue, 25 March 2008	1	1239	Tue, 25 March 2008 02:23 By: Mahesh Rajendran
When I should increase the size of datafile,tablespace,redolog files as well as sort area size Oracle 9i,Windows XP/2000 By: manoj12 on Tue, 18 March 2008	4	2321	Mon, 24 March 2008 08:27 By: manoj12
BAD performing query, OR Clause Oracle 10g By: stghag on Sat, 22 March 2008	5	1986	Sun, 23 March 2008 07:10 By: michael_bialik
ADDM Findings from OEM 10g Rel 2 By: azeem87 on Fri, 21 March 2008	0	8447	Fri, 21 March 2008 10:52 By: azeem87
Analytical Functions and Backward Index scans By: verpies on Tue, 18 March 2008	17	11973	Thu, 20 March 2008 16:54 By: coleing
Efficient Data Management. Solaris , 10.2g By: Oraclist on Thu, 20 March 2008	2	1428	Thu, 20 March 2008 07:43 By: rleishman
Selection of driving table By: vkrn on Tue, 18 March 2008	8	2127	Thu, 20 March 2008 05:25 By: vkrn
About Oracle Database Link Solaris , 10.2g By: Oraclist on Thu, 20 March 2008	7	2180	Thu, 20 March 2008 04:50 By: Michel Cadot
How can we write this query in a better or more efficeint way? oracle 10g By: vijay.nimmakuri@gmail.com on Wed, 05 March 2008	4	2674	Thu, 20 March 2008 04:47 By: Michel Cadot
lockwait By: sidd_411 on Thu, 20 March 2008	2	1214	Thu, 20 March 2008 03:48 By: msmallya
Can anybody explain this index oracle 10g, AIX By: cycloscott on Wed, 19 March 2008	6	1854	Wed, 19 March 2008 17:23 By: cycloscott
9i-Clearing cache and memory oracle 9i, Aix By: shlomi_bt on Mon, 17 March 2008	3	1397	Wed, 19 March 2008 12:15 By: shlomi_bt
PERFORMANCE OF A QUERY ; By: sispk6 on Wed, 19 March 2008	4	1823	Wed, 19 March 2008 09:29 By: ThomasG
database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) By: manoj12 on Tue, 18 March 2008	15	6681	Wed, 19 March 2008 06:56 By: manoj12
tablespace related By: sidd_411 on Wed, 19 March 2008	1	1074	Wed, 19 March 2008 06:00 By: Michel Cadot
Simple query going for a full table scan By: Flash on Tue, 18 March 2008	4	1831	Wed, 19 March 2008 01:19 By: rleishman
Procedure taking long time to execute By: anandhi80 on Wed, 12 March 2008	16	4368	Tue, 18 March 2008 22:00 By: rleishman
Database parameters for tuning By: manoj12 on Tue, 18 March 2008	2	3288	Tue, 18 March 2008 04:57 By: manoj12