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
Which one best ? By: babuknb on Mon, 29 January 2007	2	2604	Mon, 29 January 2007 05:17 By: babuknb
DB Performace with different size drives. By: cajohn on Wed, 24 January 2007	2	2444	Sat, 27 January 2007 11:40 By: cbruhn2
Testing performance tweaks By: sournote1 on Wed, 24 January 2007	7	3250	Sat, 27 January 2007 04:01 By: rleishman
Adding ORDER BY increases parse time dramatically By: milovdl on Wed, 24 January 2007	8	3165	Thu, 25 January 2007 14:24 By: rleishman
Industry standard best practice for Primary keys..should they be meaningful or meaningless? By: orausern on Tue, 23 January 2007	2	2553	Thu, 25 January 2007 09:55 By: orausern
users not logged on last 30 days By: M.Shakeel Azeem on Wed, 24 January 2007	1	2499	Thu, 25 January 2007 00:21 By: Littlefoot
Append hint, Truncate, Global Temp Table By: a_developer on Tue, 23 January 2007	2	4853	Wed, 24 January 2007 05:56 By: Mahesh Rajendran
Partitioning with ONline Redefinition By: faiz_hyd on Tue, 23 January 2007	2	3631	Tue, 23 January 2007 16:45 By: faiz_hyd
Does view change table_plan for select stmts. on base table By: liegler.joerg on Tue, 23 January 2007	2	2875	Tue, 23 January 2007 09:46 By: Mahesh Rajendran
Tuning in 10g By: babuknb on Tue, 23 January 2007	1	1993	Tue, 23 January 2007 03:57 By: Littlefoot
Materialized view refresh methods By: Ksaravan on Wed, 17 January 2007	3	3037	Mon, 22 January 2007 18:05 By: rleishman
Veiw synonym performs differently in diferent users By: omkar@tcs on Fri, 19 January 2007	5	4175	Mon, 22 January 2007 12:45 By: omkar@tcs
SQL performance tuning By: rawat_me on Thu, 18 January 2007	13	4697	Sun, 21 January 2007 21:27 By: rleishman
How to see the constraints in the table ? By: victoryhendry on Sun, 14 January 2007	3	5200	Sun, 21 January 2007 13:02 By: cbruhn2
Selecting from a big table. By: a_developer on Thu, 18 January 2007	7	3153	Sat, 20 January 2007 01:46 By: a_developer
Optimalization problem with static subquery By: piotr.kozak on Fri, 19 January 2007	1	2504	Fri, 19 January 2007 10:57 By: skooman
Regarding sort operation By: reena_ch30 on Thu, 18 January 2007	2	2407	Fri, 19 January 2007 08:51 By: cbruhn2
The Temporary Tablespace?? By: trantuananh24hg on Fri, 19 January 2007	2	3050	Fri, 19 January 2007 01:32 By: trantuananh24hg
Performance tuning By: suresh3k on Thu, 18 January 2007	1	2599	Thu, 18 January 2007 08:31 By: tahpush
index & tables should be separated? By: karismapanda on Thu, 18 January 2007	2	2615	Thu, 18 January 2007 04:47 By: karismapanda
Help with general preformance increase... By: andybyrne55 on Tue, 16 January 2007	2	2166	Tue, 16 January 2007 19:35 By: rleishman
Performance Issue!!! By: prashant_pathak on Tue, 16 January 2007	4	2927	Tue, 16 January 2007 13:37 By: prashant_pathak
Partitioning By: kedar_ambardekar on Mon, 15 January 2007	1	2070	Mon, 15 January 2007 19:54 By: rleishman
Tuning an oracle view to increase the speed of the view By: suranjita_hajra_7 on Fri, 12 January 2007	2	3036	Sat, 13 January 2007 09:22 By: BlackSwan
Different OPtimizer behaviour on Ora9iR2 ( patch 7 )-Shared server By: snow-runner on Thu, 11 January 2007	1	2485	Fri, 12 January 2007 10:12 By: michael_bialik
Insert all vs Forall By: a_developer on Thu, 11 January 2007	3	7562	Fri, 12 January 2007 06:29 By: a_developer
Query performing good in 9i but very very slow in 10g By: srinivas4u2 on Fri, 15 December 2006	7	3544	Fri, 12 January 2007 03:45 By: tahpush
Log Switches By: M.Shakeel Azeem on Thu, 11 January 2007	2	2661	Thu, 11 January 2007 06:05 By: michael_bialik
Query running slow in Forms By: neo_oracle on Mon, 08 January 2007	3	3034	Tue, 09 January 2007 20:44 By: rleishman
with out enforcing index i want use how to do this By: saiyshnav on Wed, 03 January 2007	8	2833	Tue, 09 January 2007 07:22 By: michael_bialik
Help Tune My query By: JRowbottom on Fri, 05 January 2007	5	3037	Tue, 09 January 2007 06:47 By: JRowbottom
Query performance By: vaddiparthi on Tue, 09 January 2007	1	2498	Tue, 09 January 2007 06:17 By: Mahesh Rajendran
Cognos tuning By: alanm on Mon, 08 January 2007	4	7549	Tue, 09 January 2007 03:40 By: alanm
At specific table size i'm seeing a 10x increase in query time By: tolas on Fri, 05 January 2007	6	3383	Mon, 08 January 2007 19:46 By: rleishman
Hints index combine By: uicmxz on Mon, 08 January 2007	1	3459	Mon, 08 January 2007 17:37 By: Mahesh Rajendran
Parallel queries. By: shahnazurs on Wed, 03 January 2007	4	3174	Mon, 08 January 2007 15:19 By: artmt
MERGE but no PK on the table By: lotusdeva on Mon, 08 January 2007	0	6163	Mon, 08 January 2007 11:10 By: lotusdeva
Merge over dblink - too slow.. By: lotusdeva on Fri, 05 January 2007	2	7094	Mon, 08 January 2007 11:08 By: lotusdeva
Performance Forms 6i - Where clause in block By: ora_dev on Mon, 08 January 2007	8	3333	Mon, 08 January 2007 08:05 By: ora_dev
Question about parsing and Bind variables By: kevin_oracle_2003 on Fri, 05 January 2007	2	2979	Sat, 06 January 2007 05:50 By: michael_bialik