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	2415	Thu, 22 February 2007 04:23 By: gintsp
update performance By: rcd70 on Wed, 21 February 2007	3	3933	Thu, 22 February 2007 02:37 By: michael_bialik
performance tuning By: donind on Thu, 22 February 2007	1	2471	Thu, 22 February 2007 02:02 By: michael_bialik
Questions By: california_6_1 on Wed, 21 February 2007	1	1836	Wed, 21 February 2007 23:47 By: nmacdannald
Memory question By: california_6_1 on Wed, 21 February 2007	1	1762	Wed, 21 February 2007 15:37 By: BlackSwan
Data Buffer Cache and Dirty Blocks By: Anand Ramaswamy on Fri, 16 February 2007	1	2823	Wed, 21 February 2007 07:02 By: cbruhn2
ora-1555 By: pramodgarre on Wed, 21 February 2007	1	2274	Wed, 21 February 2007 06:10 By: Mohammad Taj
SQL Tuning - Distinct Vs Group by By: amit_nanote on Wed, 21 February 2007	1	7905	Wed, 21 February 2007 05:07 By: tahpush
NOt EXISTS & NOT IN ??? By: yogeshse on Mon, 19 February 2007	1	2157	Mon, 19 February 2007 06:09 By: michael_bialik
WHERE CLAUSE TUNING By: bm_souj on Sun, 18 February 2007	7	2881	Mon, 19 February 2007 06:07 By: michael_bialik
Tunig of query By: jaydba on Fri, 16 February 2007	1	1893	Sun, 18 February 2007 20:22 By: nmacdannald
transaction By: vipersting on Sat, 17 February 2007	1	1929	Sun, 18 February 2007 20:04 By: nmacdannald
DBA_SEGMENTS: Criteria for a DB/Table export By: kishinevetz on Fri, 09 February 2007	7	4398	Fri, 16 February 2007 06:26 By: JRowbottom
Power Builder Data window linkage performance By: afreen on Thu, 15 February 2007	2	2724	Fri, 16 February 2007 01:26 By: afreen
straight sql vs procedural ASAP By: kishinevetz on Thu, 15 February 2007	6	2706	Thu, 15 February 2007 22:52 By: rleishman
Updating a BIG table By: gulabo on Wed, 07 February 2007	4	2295	Thu, 15 February 2007 10:33 By: gulabo
Data file init write By: Frank on Wed, 14 February 2007	2	10142	Wed, 14 February 2007 04:03 By: Frank
How to approach this By: laiko on Tue, 13 February 2007	2	2258	Tue, 13 February 2007 20:03 By: rleishman
Load on Oracle server By: manish mendiratta on Tue, 13 February 2007	3	2360	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	126836	Mon, 12 February 2007 18:42 By: BlackSwan
9i to 10g By: jfrano on Thu, 18 January 2007	4	2657	Mon, 12 February 2007 07:27 By: cbruhn2
how to tune query By: mjschwenger on Wed, 07 February 2007	8	3138	Sun, 11 February 2007 05:03 By: michael_bialik
SQL with high consistent gets By: vipin on Tue, 06 February 2007	10	12364	Fri, 09 February 2007 14:06 By: michael_bialik
Database Triggers performance issues By: amit_nanote on Thu, 08 February 2007	1	2117	Fri, 09 February 2007 00:19 By: rleishman
query fast in one session slow in another By: henriec on Wed, 07 February 2007	1	2321	Wed, 07 February 2007 14:46 By: skooman
data guard query By: rajan.csp on Wed, 07 February 2007	1	1743	Wed, 07 February 2007 08:02 By: ebrian
Index based on subtype By: tlahyani on Wed, 07 February 2007	0	6189	Wed, 07 February 2007 05:36 By: tlahyani
Single Join Query vs Individual Table Queries By: tolas on Fri, 02 February 2007	4	3867	Wed, 07 February 2007 02:39 By: michael_bialik
STATSPACK By: sagar_bhat on Tue, 06 February 2007	2	2567	Tue, 06 February 2007 06:19 By: Mohammad Taj
SQL Statement Tuning By: irfanr on Tue, 06 February 2007	1	2001	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	2737	Tue, 06 February 2007 04:05 By: michael_bialik
Help Required in Tunning By: oracle_guy on Tue, 06 February 2007	1	2011	Tue, 06 February 2007 03:38 By: vamsi kasina
Full table scan By: rawat_me on Thu, 01 February 2007	3	2389	Sat, 03 February 2007 11:28 By: michael_bialik
Insert from 2 million rows By: prashant_pathak on Fri, 02 February 2007	3	2334	Fri, 02 February 2007 12:40 By: prashant_pathak
Basic question in INDEXing By: premchellam on Thu, 18 January 2007	3	1931	Thu, 01 February 2007 03:20 By: premchellam
Group By By: tookep on Mon, 29 January 2007	6	2510	Wed, 31 January 2007 01:31 By: michael_bialik
Cost in the Explain Plan By: a_developer on Thu, 25 January 2007	2	2093	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	2340	Tue, 30 January 2007 11:17 By: BlackSwan
Optimizing Queries Against UNIONed View By: artmt on Tue, 23 January 2007	8	4016	Mon, 29 January 2007 11:02 By: srinivas4u2
Which one best ? By: babuknb on Mon, 29 January 2007	2	1916	Mon, 29 January 2007 05:17 By: babuknb