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
while block is being read..... By: pramodgarre on Wed, 21 February 2007	2	2540	Thu, 22 February 2007 09:43 By: pramodgarre
The 10 Longest Running Query By: rkl1 on Tue, 20 February 2007	3	3298	Thu, 22 February 2007 04:23 By: gintsp
update performance By: rcd70 on Wed, 21 February 2007	3	4320	Thu, 22 February 2007 02:37 By: michael_bialik
performance tuning By: donind on Thu, 22 February 2007	1	3042	Thu, 22 February 2007 02:02 By: michael_bialik
Questions By: california_6_1 on Wed, 21 February 2007	1	2086	Wed, 21 February 2007 23:47 By: nmacdannald
Memory question By: california_6_1 on Wed, 21 February 2007	1	2000	Wed, 21 February 2007 15:37 By: BlackSwan
Data Buffer Cache and Dirty Blocks By: Anand Ramaswamy on Fri, 16 February 2007	1	3199	Wed, 21 February 2007 07:02 By: cbruhn2
ora-1555 By: pramodgarre on Wed, 21 February 2007	1	2542	Wed, 21 February 2007 06:10 By: Mohammad Taj
SQL Tuning - Distinct Vs Group by By: amit_nanote on Wed, 21 February 2007	1	8397	Wed, 21 February 2007 05:07 By: tahpush
NOt EXISTS & NOT IN ??? By: yogeshse on Mon, 19 February 2007	1	2616	Mon, 19 February 2007 06:09 By: michael_bialik
WHERE CLAUSE TUNING By: bm_souj on Sun, 18 February 2007	7	4377	Mon, 19 February 2007 06:07 By: michael_bialik
Tunig of query By: jaydba on Fri, 16 February 2007	1	2083	Sun, 18 February 2007 20:22 By: nmacdannald
transaction By: vipersting on Sat, 17 February 2007	1	2543	Sun, 18 February 2007 20:04 By: nmacdannald
DBA_SEGMENTS: Criteria for a DB/Table export By: kishinevetz on Fri, 09 February 2007	7	5281	Fri, 16 February 2007 06:26 By: JRowbottom
Power Builder Data window linkage performance By: afreen on Thu, 15 February 2007	2	3005	Fri, 16 February 2007 01:26 By: afreen
straight sql vs procedural ASAP By: kishinevetz on Thu, 15 February 2007	6	3053	Thu, 15 February 2007 22:52 By: rleishman
Updating a BIG table By: gulabo on Wed, 07 February 2007	4	3425	Thu, 15 February 2007 10:33 By: gulabo
Data file init write By: Frank on Wed, 14 February 2007	2	10583	Wed, 14 February 2007 04:03 By: Frank
How to approach this By: laiko on Tue, 13 February 2007	2	2939	Tue, 13 February 2007 20:03 By: rleishman
Load on Oracle server By: manish mendiratta on Tue, 13 February 2007	3	2572	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	129334	Mon, 12 February 2007 18:42 By: BlackSwan
9i to 10g By: jfrano on Thu, 18 January 2007	4	3327	Mon, 12 February 2007 07:27 By: cbruhn2
how to tune query By: mjschwenger on Wed, 07 February 2007	8	3581	Sun, 11 February 2007 05:03 By: michael_bialik
SQL with high consistent gets By: vipin on Tue, 06 February 2007	10	12751	Fri, 09 February 2007 14:06 By: michael_bialik
Database Triggers performance issues By: amit_nanote on Thu, 08 February 2007	1	2807	Fri, 09 February 2007 00:19 By: rleishman
query fast in one session slow in another By: henriec on Wed, 07 February 2007	1	2558	Wed, 07 February 2007 14:46 By: skooman
data guard query By: rajan.csp on Wed, 07 February 2007	1	2015	Wed, 07 February 2007 08:02 By: ebrian
Index based on subtype By: tlahyani on Wed, 07 February 2007	0	6290	Wed, 07 February 2007 05:36 By: tlahyani
Single Join Query vs Individual Table Queries By: tolas on Fri, 02 February 2007	4	4836	Wed, 07 February 2007 02:39 By: michael_bialik
STATSPACK By: sagar_bhat on Tue, 06 February 2007	2	2912	Tue, 06 February 2007 06:19 By: Mohammad Taj
SQL Statement Tuning By: irfanr on Tue, 06 February 2007	1	2271	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	3285	Tue, 06 February 2007 04:05 By: michael_bialik
Help Required in Tunning By: oracle_guy on Tue, 06 February 2007	1	2319	Tue, 06 February 2007 03:38 By: vamsi kasina
Full table scan By: rawat_me on Thu, 01 February 2007	3	3219	Sat, 03 February 2007 11:28 By: michael_bialik
Insert from 2 million rows By: prashant_pathak on Fri, 02 February 2007	3	2476	Fri, 02 February 2007 12:40 By: prashant_pathak
Basic question in INDEXing By: premchellam on Thu, 18 January 2007	3	2654	Thu, 01 February 2007 03:20 By: premchellam
Group By By: tookep on Mon, 29 January 2007	6	2921	Wed, 31 January 2007 01:31 By: michael_bialik
Cost in the Explain Plan By: a_developer on Thu, 25 January 2007	2	2755	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	2624	Tue, 30 January 2007 11:17 By: BlackSwan
Optimizing Queries Against UNIONed View By: artmt on Tue, 23 January 2007	8	4539	Mon, 29 January 2007 11:02 By: srinivas4u2