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
Temp segment issue By: kudur_kv on Thu, 17 August 2006	4	3593	Tue, 22 August 2006 11:21 By: kudur_kv
STATSPACK question on 10g and 8i By: toshidas2000 on Thu, 20 July 2006	2	2595	Tue, 22 August 2006 03:36 By: alexdabr
Does execution plan depend on Client / Client-platform ? By: power_logic@yahoo.com on Mon, 21 August 2006	2	2607	Mon, 21 August 2006 03:39 By: power_logic@yahoo.com
DB size after Re-org By: cherryven on Sat, 19 August 2006	3	2676	Mon, 21 August 2006 02:33 By: rleishman
Creating Partitioned table faster than Non-partitioned By: a_developer on Fri, 18 August 2006	1	2489	Sat, 19 August 2006 00:44 By: rleishman
From staging tables to datamart table -- how? By: a_developer on Thu, 17 August 2006	2	3629	Fri, 18 August 2006 03:50 By: a_developer
Two questions about interviews By: kal_youssef on Sat, 12 August 2006	3	2535	Thu, 17 August 2006 11:02 By: SQLAREA
Estimating cache size By: Nau on Mon, 14 August 2006	3	6488	Thu, 17 August 2006 10:15 By: nmacdannald
Inserting huge amount of data into Oracle database By: joelny on Wed, 06 April 2005	12	13864	Thu, 17 August 2006 08:14 By: vrsanaidu
Staging table from partitioned table By: a_developer on Wed, 16 August 2006	5	4812	Thu, 17 August 2006 07:17 By: a_developer
Dictionary Managed to Locally Managed Tablespace By: cherryven on Tue, 15 August 2006	14	4183	Wed, 16 August 2006 06:32 By: JSI2001
Analyze before insert - does it help By: alliejane on Tue, 15 August 2006	1	2225	Tue, 15 August 2006 06:06 By: Mahesh Rajendran
Need help on explain plan By: gkodakalla on Thu, 10 August 2006	3	3040	Tue, 15 August 2006 03:40 By: orafaqer
Enable Row Movement in Partitioning and Overhead By: faiz_hyd on Fri, 11 August 2006	1	8520	Mon, 14 August 2006 21:52 By: rleishman
How to tune a select query which gives a result of 120 million rows? By: serkandemir on Thu, 10 August 2006	7	4997	Mon, 14 August 2006 15:49 By: Peter D.
Compund index vs simple index By: Nau on Mon, 14 August 2006	1	2091	Mon, 14 August 2006 11:10 By: SQLAREA
Increasing the SGA size By: pankajwc on Thu, 10 August 2006	6	4699	Sun, 13 August 2006 13:20 By: BlackSwan
Query tuning By: gajini on Fri, 04 August 2006	6	2743	Fri, 11 August 2006 08:59 By: michael_bialik
How to find a SQL query which is taking entire resources of an oracle database By: machis on Sat, 05 August 2006	3	3215	Fri, 11 August 2006 03:45 By: gbarbisan
Releasing SYSTEM TABLE SPACE to USERDATA,INDEX By: manicm on Mon, 07 August 2006	5	3288	Wed, 09 August 2006 21:57 By: lzfhope
DELETE hugh data from very big table By: poratips on Tue, 08 August 2006	3	7150	Wed, 09 August 2006 07:31 By: poratips
Replication Issues with external tables By: junaidsystems on Mon, 07 August 2006	1	2394	Tue, 08 August 2006 22:18 By: ebrian
Indexing question By: Fred Easey on Mon, 31 July 2006	8	3205	Mon, 07 August 2006 10:17 By: srinivas4u2
parallel execution By: AlinaC on Wed, 26 July 2006	1	2254	Sat, 05 August 2006 21:06 By: nmacdannald
Looking for optimizations for Oracle DB By: dryloop on Fri, 04 August 2006	2	2396	Fri, 04 August 2006 09:17 By: dryloop
Comparing Hints By: hari_bk on Thu, 03 August 2006	1	2383	Fri, 04 August 2006 00:58 By: Frank Naude
how to reduce using virtual memeory By: lzfhope on Mon, 31 July 2006	3	3057	Thu, 03 August 2006 21:22 By: lzfhope
High parse count over db_link from 9i to 9i? By: kareem2020 on Sun, 30 July 2006	3	2693	Thu, 03 August 2006 13:34 By: srinivas4u2
Problem with output file using TKPROF - Oracle 9i Release 2 By: kumarsz on Tue, 01 August 2006	6	6515	Thu, 03 August 2006 13:30 By: Littlefoot
Find Session with high cpu usage By: kareem2020 on Thu, 03 August 2006	1	2708	Thu, 03 August 2006 02:35 By: rleishman
Collecting Stats taking long to execute in PL/SQL code By: a_developer on Fri, 28 July 2006	5	4969	Tue, 01 August 2006 16:16 By: wagnerch
Is there enough SGA By: Brayan on Mon, 31 July 2006	1	2525	Mon, 31 July 2006 04:19 By: michael_bialik
Dilemma on Loading and querying. By: rkl1 on Fri, 28 July 2006	1	2350	Fri, 28 July 2006 21:38 By: rleishman
hints required By: b_pooja21 on Thu, 27 July 2006	9	4401	Fri, 28 July 2006 11:35 By: michael_bialik
DBA_FREE_SPACE view in 10g taking more time By: vvoracle on Fri, 28 July 2006	1	3917	Fri, 28 July 2006 06:27 By: Mahesh Rajendran
Getting queries By: cunningham_harry@hotmail. on Fri, 28 July 2006	1	2050	Fri, 28 July 2006 04:43 By: JRowbottom
Help need .. Urgent By: juliee_jitu on Fri, 28 July 2006	3	1916	Fri, 28 July 2006 04:28 By: JSI2001
How to get the CBO to recognize a FBI By: brekhof on Thu, 27 July 2006	3	2740	Fri, 28 July 2006 02:59 By: JRowbottom
Optimizing Hierachical query By: Aju on Mon, 19 June 2006	3	2563	Thu, 27 July 2006 07:07 By: michael_bialik
Pl/sql procedure experience a high parse count using oracle 9i db-link. By: Josepha on Thu, 27 July 2006	1	2419	Thu, 27 July 2006 06:54 By: michael_bialik