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
The 10 Longest Running Query By: rkl1 on Tue, 20 February 2007	3	3145	Thu, 22 February 2007 04:23 By: gintsp
update performance By: rcd70 on Wed, 21 February 2007	3	4093	Thu, 22 February 2007 02:37 By: michael_bialik
performance tuning By: donind on Thu, 22 February 2007	1	2932	Thu, 22 February 2007 02:02 By: michael_bialik
Questions By: california_6_1 on Wed, 21 February 2007	1	1994	Wed, 21 February 2007 23:47 By: nmacdannald
Memory question By: california_6_1 on Wed, 21 February 2007	1	1900	Wed, 21 February 2007 15:37 By: BlackSwan
Data Buffer Cache and Dirty Blocks By: Anand Ramaswamy on Fri, 16 February 2007	1	3084	Wed, 21 February 2007 07:02 By: cbruhn2
ora-1555 By: pramodgarre on Wed, 21 February 2007	1	2445	Wed, 21 February 2007 06:10 By: Mohammad Taj
SQL Tuning - Distinct Vs Group by By: amit_nanote on Wed, 21 February 2007	1	8285	Wed, 21 February 2007 05:07 By: tahpush
NOt EXISTS & NOT IN ??? By: yogeshse on Mon, 19 February 2007	1	2515	Mon, 19 February 2007 06:09 By: michael_bialik
WHERE CLAUSE TUNING By: bm_souj on Sun, 18 February 2007	7	4147	Mon, 19 February 2007 06:07 By: michael_bialik
Tunig of query By: jaydba on Fri, 16 February 2007	1	2002	Sun, 18 February 2007 20:22 By: nmacdannald
transaction By: vipersting on Sat, 17 February 2007	1	2433	Sun, 18 February 2007 20:04 By: nmacdannald
DBA_SEGMENTS: Criteria for a DB/Table export By: kishinevetz on Fri, 09 February 2007	7	5077	Fri, 16 February 2007 06:26 By: JRowbottom
Power Builder Data window linkage performance By: afreen on Thu, 15 February 2007	2	2895	Fri, 16 February 2007 01:26 By: afreen
straight sql vs procedural ASAP By: kishinevetz on Thu, 15 February 2007	6	2825	Thu, 15 February 2007 22:52 By: rleishman
Updating a BIG table By: gulabo on Wed, 07 February 2007	4	3285	Thu, 15 February 2007 10:33 By: gulabo
Data file init write By: Frank on Wed, 14 February 2007	2	10328	Wed, 14 February 2007 04:03 By: Frank
How to approach this By: laiko on Tue, 13 February 2007	2	2787	Tue, 13 February 2007 20:03 By: rleishman
Load on Oracle server By: manish mendiratta on Tue, 13 February 2007	3	2429	Tue, 13 February 2007 13:16 By: BlackSwan
ORA-12520: TNS:listener could not find available handler for requested type of server By: rvnair123 on Tue, 07 March 2006	10	128829	Mon, 12 February 2007 18:42 By: BlackSwan
9i to 10g By: jfrano on Thu, 18 January 2007	4	3151	Mon, 12 February 2007 07:27 By: cbruhn2
how to tune query By: mjschwenger on Wed, 07 February 2007	8	3359	Sun, 11 February 2007 05:03 By: michael_bialik
SQL with high consistent gets By: vipin on Tue, 06 February 2007	10	12477	Fri, 09 February 2007 14:06 By: michael_bialik
Database Triggers performance issues By: amit_nanote on Thu, 08 February 2007	1	2651	Fri, 09 February 2007 00:19 By: rleishman
query fast in one session slow in another By: henriec on Wed, 07 February 2007	1	2449	Wed, 07 February 2007 14:46 By: skooman
data guard query By: rajan.csp on Wed, 07 February 2007	1	1918	Wed, 07 February 2007 08:02 By: ebrian
Index based on subtype By: tlahyani on Wed, 07 February 2007	0	6207	Wed, 07 February 2007 05:36 By: tlahyani
Single Join Query vs Individual Table Queries By: tolas on Fri, 02 February 2007	4	4644	Wed, 07 February 2007 02:39 By: michael_bialik
STATSPACK By: sagar_bhat on Tue, 06 February 2007	2	2816	Tue, 06 February 2007 06:19 By: Mohammad Taj
SQL Statement Tuning By: irfanr on Tue, 06 February 2007	1	2208	Tue, 06 February 2007 05:52 By: Mahesh Rajendran
How to push Hash Anti join without HINT or code modification ? By: deadpoet69 on Tue, 06 February 2007	1	3185	Tue, 06 February 2007 04:05 By: michael_bialik
Help Required in Tunning By: oracle_guy on Tue, 06 February 2007	1	2229	Tue, 06 February 2007 03:38 By: vamsi kasina
Full table scan By: rawat_me on Thu, 01 February 2007	3	3096	Sat, 03 February 2007 11:28 By: michael_bialik
Insert from 2 million rows By: prashant_pathak on Fri, 02 February 2007	3	2372	Fri, 02 February 2007 12:40 By: prashant_pathak
Basic question in INDEXing By: premchellam on Thu, 18 January 2007	3	2528	Thu, 01 February 2007 03:20 By: premchellam
Group By By: tookep on Mon, 29 January 2007	6	2785	Wed, 31 January 2007 01:31 By: michael_bialik
Cost in the Explain Plan By: a_developer on Thu, 25 January 2007	2	2626	Tue, 30 January 2007 14:18 By: michael_bialik
Performance Implications of a Generic Lookup Table Design By: artmt on Mon, 29 January 2007	4	2476	Tue, 30 January 2007 11:17 By: BlackSwan
Optimizing Queries Against UNIONed View By: artmt on Tue, 23 January 2007	8	4101	Mon, 29 January 2007 11:02 By: srinivas4u2
Which one best ? By: babuknb on Mon, 29 January 2007	2	2495	Mon, 29 January 2007 05:17 By: babuknb