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	2322	Sat, 27 January 2007 11:40 By: cbruhn2
Testing performance tweaks By: sournote1 on Wed, 24 January 2007	7	3081	Sat, 27 January 2007 04:01 By: rleishman
Adding ORDER BY increases parse time dramatically By: milovdl on Wed, 24 January 2007	8	2977	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	2435	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	2397	Thu, 25 January 2007 00:21 By: Littlefoot
Append hint, Truncate, Global Temp Table By: a_developer on Tue, 23 January 2007	2	4705	Wed, 24 January 2007 05:56 By: Mahesh Rajendran
Partitioning with ONline Redefinition By: faiz_hyd on Tue, 23 January 2007	2	3519	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	2736	Tue, 23 January 2007 09:46 By: Mahesh Rajendran
Tuning in 10g By: babuknb on Tue, 23 January 2007	1	1863	Tue, 23 January 2007 03:57 By: Littlefoot
Materialized view refresh methods By: Ksaravan on Wed, 17 January 2007	3	2891	Mon, 22 January 2007 18:05 By: rleishman
Veiw synonym performs differently in diferent users By: omkar@tcs on Fri, 19 January 2007	5	3940	Mon, 22 January 2007 12:45 By: omkar@tcs
SQL performance tuning By: rawat_me on Thu, 18 January 2007	13	4307	Sun, 21 January 2007 21:27 By: rleishman
How to see the constraints in the table ? By: victoryhendry on Sun, 14 January 2007	3	5038	Sun, 21 January 2007 13:02 By: cbruhn2
Selecting from a big table. By: a_developer on Thu, 18 January 2007	7	2944	Sat, 20 January 2007 01:46 By: a_developer
Optimalization problem with static subquery By: piotr.kozak on Fri, 19 January 2007	1	2391	Fri, 19 January 2007 10:57 By: skooman
Regarding sort operation By: reena_ch30 on Thu, 18 January 2007	2	2289	Fri, 19 January 2007 08:51 By: cbruhn2
The Temporary Tablespace?? By: trantuananh24hg on Fri, 19 January 2007	2	2906	Fri, 19 January 2007 01:32 By: trantuananh24hg
Performance tuning By: suresh3k on Thu, 18 January 2007	1	2509	Thu, 18 January 2007 08:31 By: tahpush
index & tables should be separated? By: karismapanda on Thu, 18 January 2007	2	2508	Thu, 18 January 2007 04:47 By: karismapanda
Help with general preformance increase... By: andybyrne55 on Tue, 16 January 2007	2	2059	Tue, 16 January 2007 19:35 By: rleishman
Performance Issue!!! By: prashant_pathak on Tue, 16 January 2007	4	2826	Tue, 16 January 2007 13:37 By: prashant_pathak
Partitioning By: kedar_ambardekar on Mon, 15 January 2007	1	1971	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	2950	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	2373	Fri, 12 January 2007 10:12 By: michael_bialik
Insert all vs Forall By: a_developer on Thu, 11 January 2007	3	7334	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	3371	Fri, 12 January 2007 03:45 By: tahpush
Log Switches By: M.Shakeel Azeem on Thu, 11 January 2007	2	2519	Thu, 11 January 2007 06:05 By: michael_bialik
Query running slow in Forms By: neo_oracle on Mon, 08 January 2007	3	2915	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	2592	Tue, 09 January 2007 07:22 By: michael_bialik
Help Tune My query By: JRowbottom on Fri, 05 January 2007	5	2868	Tue, 09 January 2007 06:47 By: JRowbottom
Query performance By: vaddiparthi on Tue, 09 January 2007	1	2389	Tue, 09 January 2007 06:17 By: Mahesh Rajendran
Cognos tuning By: alanm on Mon, 08 January 2007	4	7407	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	3202	Mon, 08 January 2007 19:46 By: rleishman
Hints index combine By: uicmxz on Mon, 08 January 2007	1	3317	Mon, 08 January 2007 17:37 By: Mahesh Rajendran
Parallel queries. By: shahnazurs on Wed, 03 January 2007	4	3030	Mon, 08 January 2007 15:19 By: artmt
MERGE but no PK on the table By: lotusdeva on Mon, 08 January 2007	0	6061	Mon, 08 January 2007 11:10 By: lotusdeva
Merge over dblink - too slow.. By: lotusdeva on Fri, 05 January 2007	2	6968	Mon, 08 January 2007 11:08 By: lotusdeva
Performance Forms 6i - Where clause in block By: ora_dev on Mon, 08 January 2007	8	3146	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	2857	Sat, 06 January 2007 05:50 By: michael_bialik
Database Down By: Alps on Wed, 06 December 2006	5	2977	Fri, 05 January 2007 08:56 By: Alps