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
Oracle 8.1.7 statistics problem By: zoltanp on Fri, 16 March 2007	3	2660	Fri, 16 March 2007 14:29 By: Mahesh Rajendran
Delete statement and performance By: subratd on Thu, 15 March 2007	5	3057	Fri, 16 March 2007 01:21 By: rleishman
Benchmarking UPDATE Statements By: SnippetyJoe on Thu, 15 March 2007	3	3189	Thu, 15 March 2007 20:38 By: rleishman
when to use_merge or use_hash for large data sets By: renjunatarajan on Wed, 14 March 2007	2	11803	Thu, 15 March 2007 04:57 By: renjunatarajan
all about db_block_size By: aftadel on Sun, 11 March 2007	3	2730	Wed, 14 March 2007 11:36 By: nmacdannald
Oracle instances and performance By: subratd on Wed, 14 March 2007	4	2666	Wed, 14 March 2007 08:35 By: JRowbottom
Multiple sessions in a single instance and performance By: subratd on Wed, 14 March 2007	4	2637	Wed, 14 March 2007 08:31 By: JRowbottom
How to tuning our oracle product server? By: Tom_webex on Tue, 06 March 2007	5	11138	Tue, 13 March 2007 16:15 By: michael_bialik
Poor Performance query By: chara on Thu, 08 March 2007	3	2798	Thu, 08 March 2007 22:25 By: rleishman
Execution Plan in Trace File By: scottwmackey on Wed, 07 March 2007	5	2866	Thu, 08 March 2007 22:07 By: rleishman
Reverse Key Index By: sanjay_kant on Thu, 08 March 2007	2	2215	Thu, 08 March 2007 14:14 By: sanjay_kant
Does Concatenation in SQL query effect performance By: kirso491 on Wed, 07 March 2007	4	2421	Wed, 07 March 2007 14:59 By: kirso491
is there any limit for number of connections on a listner port By: najehas on Wed, 07 March 2007	9	3703	Wed, 07 March 2007 13:23 By: BlackSwan
performance of a query By: p.bhaskar on Wed, 07 March 2007	1	2258	Wed, 07 March 2007 09:41 By: BlackSwan
Doubt on "SQL Ordered by Parse Calls" By: gkodakalla on Tue, 06 March 2007	4	10100	Wed, 07 March 2007 00:48 By: michael_bialik
Tunned querry By: donind on Tue, 06 March 2007	1	2088	Wed, 07 March 2007 00:41 By: michael_bialik
query hangs By: oracle_coorgi on Tue, 06 March 2007	5	2889	Wed, 07 March 2007 00:06 By: flyboy
need suggestion on query which performs search on name By: gkodakalla on Tue, 06 March 2007	1	2413	Tue, 06 March 2007 07:59 By: skooman
saving time in query execution By: p.bhaskar on Tue, 06 March 2007	2	2450	Tue, 06 March 2007 06:27 By: JRowbottom
Nested loops, Hash join and Sort Merge joins – difference? By: oraclearora on Mon, 05 March 2007	1	3611	Mon, 05 March 2007 05:39 By: Mahesh Rajendran
when use_hash related hint is used? By: p.bhaskar on Mon, 05 March 2007	1	2861	Mon, 05 March 2007 05:37 By: Mahesh Rajendran
Tuning of a sql querry By: donind on Thu, 01 March 2007	5	3782	Fri, 02 March 2007 06:10 By: JRowbottom
parallel DML By: rcd70 on Thu, 01 March 2007	1	3887	Thu, 01 March 2007 18:59 By: ebrian
Row Chaining Issue By: thiyagaraj on Wed, 28 February 2007	5	4789	Thu, 01 March 2007 08:34 By: gintsp
setting db_file_multiblock_read_count By: Brayan on Thu, 01 March 2007	4	4546	Thu, 01 March 2007 07:48 By: smartin
Dynamic Table List Selection for STATS By: faiz_hyd on Tue, 27 February 2007	4	2615	Thu, 01 March 2007 07:40 By: smartin
Alter Session (workareas and area_sizes) By: smartin on Tue, 27 February 2007	6	7633	Thu, 01 March 2007 07:37 By: smartin
Explain plan By: donind on Thu, 01 March 2007	1	2475	Thu, 01 March 2007 02:59 By: Mohammad Taj
Performance with materialized view By: reemagupta18 on Wed, 08 March 2006	1	3952	Thu, 01 March 2007 00:05 By: vivekg19
Ref :"Understanding Indexes" from Home Page Link By: josh_snehal on Sat, 24 February 2007	6	4675	Wed, 28 February 2007 13:07 By: smartin
How to Purge tables ?? By: deepakc on Wed, 28 February 2007	3	2796	Wed, 28 February 2007 12:38 By: smartin
Reduce the number of Datafiles By: frozenam_24 on Tue, 27 February 2007	7	3159	Wed, 28 February 2007 00:44 By: frozenam_24
how to measure the Performance improvement By: buck444 on Tue, 27 February 2007	4	2340	Tue, 27 February 2007 07:34 By: Mohammad Taj
Slow Performance of query By: deepayan on Fri, 02 February 2007	2	4451	Mon, 26 February 2007 10:01 By: skooman
performance enhancement By: dr46014 on Sat, 24 February 2007	3	3073	Sun, 25 February 2007 02:52 By: rleishman
DBMS_STATS.GATHER_SCHEMA_STATS - Suggestion By: Brayan on Sat, 24 February 2007	2	3566	Sat, 24 February 2007 09:18 By: Mahesh Rajendran
Optimize mode first_rows returns full table By: coleex on Fri, 23 February 2007	2	1753	Fri, 23 February 2007 15:38 By: coleex
Queries not running - pls help By: sajut on Tue, 30 January 2007	9	4157	Fri, 23 February 2007 12:29 By: michael_bialik
db statistics after db abnormal shutdown By: vinu_raj on Thu, 22 February 2007	2	2283	Thu, 22 February 2007 15:12 By: vinu_raj
doubt on paritions By: gkodakalla on Thu, 22 February 2007	5	2862	Thu, 22 February 2007 10:29 By: Mahesh Rajendran