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
performance tuning By: donind on Thu, 22 February 2007	1	2235	Thu, 22 February 2007 02:02 By: michael_bialik
Questions By: california_6_1 on Wed, 21 February 2007	1	1571	Wed, 21 February 2007 23:47 By: nmacdannald
Memory question By: california_6_1 on Wed, 21 February 2007	1	1531	Wed, 21 February 2007 15:37 By: BlackSwan
Data Buffer Cache and Dirty Blocks By: Anand Ramaswamy on Fri, 16 February 2007	1	2570	Wed, 21 February 2007 07:02 By: cbruhn2
ora-1555 By: pramodgarre on Wed, 21 February 2007	1	2034	Wed, 21 February 2007 06:10 By: Mohammad Taj
SQL Tuning - Distinct Vs Group by By: amit_nanote on Wed, 21 February 2007	1	7655	Wed, 21 February 2007 05:07 By: tahpush
NOt EXISTS & NOT IN ??? By: yogeshse on Mon, 19 February 2007	1	1902	Mon, 19 February 2007 06:09 By: michael_bialik
WHERE CLAUSE TUNING By: bm_souj on Sun, 18 February 2007	7	2589	Mon, 19 February 2007 06:07 By: michael_bialik
Tunig of query By: jaydba on Fri, 16 February 2007	1	1682	Sun, 18 February 2007 20:22 By: nmacdannald
transaction By: vipersting on Sat, 17 February 2007	1	1695	Sun, 18 February 2007 20:04 By: nmacdannald
DBA_SEGMENTS: Criteria for a DB/Table export By: kishinevetz on Fri, 09 February 2007	7	4129	Fri, 16 February 2007 06:26 By: JRowbottom
Power Builder Data window linkage performance By: afreen on Thu, 15 February 2007	2	2505	Fri, 16 February 2007 01:26 By: afreen
straight sql vs procedural ASAP By: kishinevetz on Thu, 15 February 2007	6	2429	Thu, 15 February 2007 22:52 By: rleishman
Updating a BIG table By: gulabo on Wed, 07 February 2007	4	2041	Thu, 15 February 2007 10:33 By: gulabo
Data file init write By: Frank on Wed, 14 February 2007	2	9812	Wed, 14 February 2007 04:03 By: Frank
How to approach this By: laiko on Tue, 13 February 2007	2	2002	Tue, 13 February 2007 20:03 By: rleishman
Load on Oracle server By: manish mendiratta on Tue, 13 February 2007	3	2107	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	126278	Mon, 12 February 2007 18:42 By: BlackSwan
9i to 10g By: jfrano on Thu, 18 January 2007	4	2410	Mon, 12 February 2007 07:27 By: cbruhn2
how to tune query By: mjschwenger on Wed, 07 February 2007	8	2848	Sun, 11 February 2007 05:03 By: michael_bialik
SQL with high consistent gets By: vipin on Tue, 06 February 2007	10	11901	Fri, 09 February 2007 14:06 By: michael_bialik
Database Triggers performance issues By: amit_nanote on Thu, 08 February 2007	1	1889	Fri, 09 February 2007 00:19 By: rleishman
query fast in one session slow in another By: henriec on Wed, 07 February 2007	1	2089	Wed, 07 February 2007 14:46 By: skooman
data guard query By: rajan.csp on Wed, 07 February 2007	1	1524	Wed, 07 February 2007 08:02 By: ebrian
Index based on subtype By: tlahyani on Wed, 07 February 2007	0	5981	Wed, 07 February 2007 05:36 By: tlahyani
Single Join Query vs Individual Table Queries By: tolas on Fri, 02 February 2007	4	3598	Wed, 07 February 2007 02:39 By: michael_bialik
STATSPACK By: sagar_bhat on Tue, 06 February 2007	2	2333	Tue, 06 February 2007 06:19 By: Mohammad Taj
SQL Statement Tuning By: irfanr on Tue, 06 February 2007	1	1760	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	2488	Tue, 06 February 2007 04:05 By: michael_bialik
Help Required in Tunning By: oracle_guy on Tue, 06 February 2007	1	1759	Tue, 06 February 2007 03:38 By: vamsi kasina
Full table scan By: rawat_me on Thu, 01 February 2007	3	2127	Sat, 03 February 2007 11:28 By: michael_bialik
Insert from 2 million rows By: prashant_pathak on Fri, 02 February 2007	3	2085	Fri, 02 February 2007 12:40 By: prashant_pathak
Basic question in INDEXing By: premchellam on Thu, 18 January 2007	3	1683	Thu, 01 February 2007 03:20 By: premchellam
Group By By: tookep on Mon, 29 January 2007	6	2220	Wed, 31 January 2007 01:31 By: michael_bialik
Cost in the Explain Plan By: a_developer on Thu, 25 January 2007	2	1839	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	2090	Tue, 30 January 2007 11:17 By: BlackSwan
Optimizing Queries Against UNIONed View By: artmt on Tue, 23 January 2007	8	3205	Mon, 29 January 2007 11:02 By: srinivas4u2
Which one best ? By: babuknb on Mon, 29 January 2007	2	1618	Mon, 29 January 2007 05:17 By: babuknb
DB Performace with different size drives. By: cajohn on Wed, 24 January 2007	2	1698	Sat, 27 January 2007 11:40 By: cbruhn2
Testing performance tweaks By: sournote1 on Wed, 24 January 2007	7	2252	Sat, 27 January 2007 04:01 By: rleishman