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
DB Performace with different size drives. By: cajohn on Wed, 24 January 2007	2	2351	Sat, 27 January 2007 11:40 By: cbruhn2
Testing performance tweaks By: sournote1 on Wed, 24 January 2007	7	3112	Sat, 27 January 2007 04:01 By: rleishman
Adding ORDER BY increases parse time dramatically By: milovdl on Wed, 24 January 2007	8	3041	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	2460	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	2415	Thu, 25 January 2007 00:21 By: Littlefoot
Append hint, Truncate, Global Temp Table By: a_developer on Tue, 23 January 2007	2	4746	Wed, 24 January 2007 05:56 By: Mahesh Rajendran
Partitioning with ONline Redefinition By: faiz_hyd on Tue, 23 January 2007	2	3543	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	2776	Tue, 23 January 2007 09:46 By: Mahesh Rajendran
Tuning in 10g By: babuknb on Tue, 23 January 2007	1	1923	Tue, 23 January 2007 03:57 By: Littlefoot
Materialized view refresh methods By: Ksaravan on Wed, 17 January 2007	3	2934	Mon, 22 January 2007 18:05 By: rleishman
Veiw synonym performs differently in diferent users By: omkar@tcs on Fri, 19 January 2007	5	3992	Mon, 22 January 2007 12:45 By: omkar@tcs
SQL performance tuning By: rawat_me on Thu, 18 January 2007	13	4466	Sun, 21 January 2007 21:27 By: rleishman
How to see the constraints in the table ? By: victoryhendry on Sun, 14 January 2007	3	5080	Sun, 21 January 2007 13:02 By: cbruhn2
Selecting from a big table. By: a_developer on Thu, 18 January 2007	7	3010	Sat, 20 January 2007 01:46 By: a_developer
Optimalization problem with static subquery By: piotr.kozak on Fri, 19 January 2007	1	2417	Fri, 19 January 2007 10:57 By: skooman
Regarding sort operation By: reena_ch30 on Thu, 18 January 2007	2	2330	Fri, 19 January 2007 08:51 By: cbruhn2
The Temporary Tablespace?? By: trantuananh24hg on Fri, 19 January 2007	2	2954	Fri, 19 January 2007 01:32 By: trantuananh24hg
Performance tuning By: suresh3k on Thu, 18 January 2007	1	2535	Thu, 18 January 2007 08:31 By: tahpush
index & tables should be separated? By: karismapanda on Thu, 18 January 2007	2	2536	Thu, 18 January 2007 04:47 By: karismapanda
Help with general preformance increase... By: andybyrne55 on Tue, 16 January 2007	2	2086	Tue, 16 January 2007 19:35 By: rleishman
Performance Issue!!! By: prashant_pathak on Tue, 16 January 2007	4	2851	Tue, 16 January 2007 13:37 By: prashant_pathak
Partitioning By: kedar_ambardekar on Mon, 15 January 2007	1	1997	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	2972	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	2403	Fri, 12 January 2007 10:12 By: michael_bialik
Insert all vs Forall By: a_developer on Thu, 11 January 2007	3	7443	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	3404	Fri, 12 January 2007 03:45 By: tahpush
Log Switches By: M.Shakeel Azeem on Thu, 11 January 2007	2	2556	Thu, 11 January 2007 06:05 By: michael_bialik
Query running slow in Forms By: neo_oracle on Mon, 08 January 2007	3	2941	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	2685	Tue, 09 January 2007 07:22 By: michael_bialik
Help Tune My query By: JRowbottom on Fri, 05 January 2007	5	2922	Tue, 09 January 2007 06:47 By: JRowbottom
Query performance By: vaddiparthi on Tue, 09 January 2007	1	2407	Tue, 09 January 2007 06:17 By: Mahesh Rajendran
Cognos tuning By: alanm on Mon, 08 January 2007	4	7453	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	3252	Mon, 08 January 2007 19:46 By: rleishman
Hints index combine By: uicmxz on Mon, 08 January 2007	1	3357	Mon, 08 January 2007 17:37 By: Mahesh Rajendran
Parallel queries. By: shahnazurs on Wed, 03 January 2007	4	3064	Mon, 08 January 2007 15:19 By: artmt
MERGE but no PK on the table By: lotusdeva on Mon, 08 January 2007	0	6111	Mon, 08 January 2007 11:10 By: lotusdeva
Merge over dblink - too slow.. By: lotusdeva on Fri, 05 January 2007	2	7010	Mon, 08 January 2007 11:08 By: lotusdeva
Performance Forms 6i - Where clause in block By: ora_dev on Mon, 08 January 2007	8	3178	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	2881	Sat, 06 January 2007 05:50 By: michael_bialik
Database Down By: Alps on Wed, 06 December 2006	5	3040	Fri, 05 January 2007 08:56 By: Alps