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
Adding ORDER BY increases parse time dramatically By: milovdl on Wed, 24 January 2007	8	2474	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	1971	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	1803	Thu, 25 January 2007 00:21 By: Littlefoot
Append hint, Truncate, Global Temp Table By: a_developer on Tue, 23 January 2007	2	3998	Wed, 24 January 2007 05:56 By: Mahesh Rajendran
Partitioning with ONline Redefinition By: faiz_hyd on Tue, 23 January 2007	2	3233	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	2161	Tue, 23 January 2007 09:46 By: Mahesh Rajendran
Tuning in 10g By: babuknb on Tue, 23 January 2007	1	1516	Tue, 23 January 2007 03:57 By: Littlefoot
Materialized view refresh methods By: Ksaravan on Wed, 17 January 2007	3	2423	Mon, 22 January 2007 18:05 By: rleishman
Veiw synonym performs differently in diferent users By: omkar@tcs on Fri, 19 January 2007	5	3081	Mon, 22 January 2007 12:45 By: omkar@tcs
SQL performance tuning By: rawat_me on Thu, 18 January 2007	13	3648	Sun, 21 January 2007 21:27 By: rleishman
How to see the constraints in the table ? By: victoryhendry on Sun, 14 January 2007	3	4673	Sun, 21 January 2007 13:02 By: cbruhn2
Selecting from a big table. By: a_developer on Thu, 18 January 2007	7	2375	Sat, 20 January 2007 01:46 By: a_developer
Optimalization problem with static subquery By: piotr.kozak on Fri, 19 January 2007	1	1852	Fri, 19 January 2007 10:57 By: skooman
Regarding sort operation By: reena_ch30 on Thu, 18 January 2007	2	1835	Fri, 19 January 2007 08:51 By: cbruhn2
The Temporary Tablespace?? By: trantuananh24hg on Fri, 19 January 2007	2	1990	Fri, 19 January 2007 01:32 By: trantuananh24hg
Performance tuning By: suresh3k on Thu, 18 January 2007	1	1795	Thu, 18 January 2007 08:31 By: tahpush
index & tables should be separated? By: karismapanda on Thu, 18 January 2007	2	1863	Thu, 18 January 2007 04:47 By: karismapanda
Help with general preformance increase... By: andybyrne55 on Tue, 16 January 2007	2	1590	Tue, 16 January 2007 19:35 By: rleishman
Performance Issue!!! By: prashant_pathak on Tue, 16 January 2007	4	2462	Tue, 16 January 2007 13:37 By: prashant_pathak
Partitioning By: kedar_ambardekar on Mon, 15 January 2007	1	1749	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	2486	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	1810	Fri, 12 January 2007 10:12 By: michael_bialik
Insert all vs Forall By: a_developer on Thu, 11 January 2007	3	6919	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	2391	Fri, 12 January 2007 03:45 By: tahpush
Log Switches By: M.Shakeel Azeem on Thu, 11 January 2007	2	1998	Thu, 11 January 2007 06:05 By: michael_bialik
Query running slow in Forms By: neo_oracle on Mon, 08 January 2007	3	2087	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	2162	Tue, 09 January 2007 07:22 By: michael_bialik
Help Tune My query By: JRowbottom on Fri, 05 January 2007	5	2578	Tue, 09 January 2007 06:47 By: JRowbottom
Query performance By: vaddiparthi on Tue, 09 January 2007	1	1809	Tue, 09 January 2007 06:17 By: Mahesh Rajendran
Cognos tuning By: alanm on Mon, 08 January 2007	4	6092	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	2481	Mon, 08 January 2007 19:46 By: rleishman
Hints index combine By: uicmxz on Mon, 08 January 2007	1	2595	Mon, 08 January 2007 17:37 By: Mahesh Rajendran
Parallel queries. By: shahnazurs on Wed, 03 January 2007	4	2142	Mon, 08 January 2007 15:19 By: artmt
MERGE but no PK on the table By: lotusdeva on Mon, 08 January 2007	0	5441	Mon, 08 January 2007 11:10 By: lotusdeva
Merge over dblink - too slow.. By: lotusdeva on Fri, 05 January 2007	2	6696	Mon, 08 January 2007 11:08 By: lotusdeva
Performance Forms 6i - Where clause in block By: ora_dev on Mon, 08 January 2007	8	2709	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	2052	Sat, 06 January 2007 05:50 By: michael_bialik
Database Down By: Alps on Wed, 06 December 2006	5	2258	Fri, 05 January 2007 08:56 By: Alps
How to avoid redo log entries for a table By: amit.pandey on Wed, 03 January 2007	5	4203	Fri, 05 January 2007 04:41 By: Mahesh Rajendran
tuning By: SRIVASUWIN on Tue, 02 January 2007	2	1582	Tue, 02 January 2007 12:54 By: SRIVASUWIN