Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  when to use_merge or use_hash for large data sets
By: renjunatarajan on Wed, 14 March 2007
2 10762 Thu, 15 March 2007 04:57
By: renjunatarajan
icon5.gif all about db_block_size
By: aftadel on Sun, 11 March 2007
3 2044 Wed, 14 March 2007 11:36
By: nmacdannald
  Oracle instances and performance
By: subratd on Wed, 14 March 2007
4 1829 Wed, 14 March 2007 08:35
By: JRowbottom
  Multiple sessions in a single instance and performance
By: subratd on Wed, 14 March 2007
4 1885 Wed, 14 March 2007 08:31
By: JRowbottom
  How to tuning our oracle product server?
By: Tom_webex on Tue, 06 March 2007
5 10202 Tue, 13 March 2007 16:15
By: michael_bialik
  Poor Performance query
By: chara on Thu, 08 March 2007
3 1797 Thu, 08 March 2007 22:25
By: rleishman
  Execution Plan in Trace File
By: scottwmackey on Wed, 07 March 2007
5 2169 Thu, 08 March 2007 22:07
By: rleishman
icon5.gif Reverse Key Index
By: sanjay_kant on Thu, 08 March 2007
2 1442 Thu, 08 March 2007 14:14
By: sanjay_kant
  Does Concatenation in SQL query effect performance
By: kirso491 on Wed, 07 March 2007
4 1949 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 2548 Wed, 07 March 2007 13:23
By: BlackSwan
  performance of a query
By: p.bhaskar on Wed, 07 March 2007
1 1704 Wed, 07 March 2007 09:41
By: BlackSwan
  Doubt on "SQL Ordered by Parse Calls"
By: gkodakalla on Tue, 06 March 2007
4 9046 Wed, 07 March 2007 00:48
By: michael_bialik
  Tunned querry
By: donind on Tue, 06 March 2007
1 1632 Wed, 07 March 2007 00:41
By: michael_bialik
  query hangs
By: oracle_coorgi on Tue, 06 March 2007
5 2242 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 1743 Tue, 06 March 2007 07:59
By: skooman
  saving time in query execution
By: p.bhaskar on Tue, 06 March 2007
2 1707 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 3027 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 2150 Mon, 05 March 2007 05:37
By: Mahesh Rajendran
  Tuning of a sql querry
By: donind on Thu, 01 March 2007
5 2645 Fri, 02 March 2007 06:10
By: JRowbottom
  parallel DML
By: rcd70 on Thu, 01 March 2007
1 3431 Thu, 01 March 2007 18:59
By: ebrian
  Row Chaining Issue
By: thiyagaraj on Wed, 28 February 2007
5 3628 Thu, 01 March 2007 08:34
By: gintsp
  setting db_file_multiblock_read_count
By: Brayan on Thu, 01 March 2007
4 3746 Thu, 01 March 2007 07:48
By: smartin
  Dynamic Table List Selection for STATS
By: faiz_hyd on Tue, 27 February 2007
4 2223 Thu, 01 March 2007 07:40
By: smartin
  Alter Session (workareas and area_sizes)
By: smartin on Tue, 27 February 2007
6 7088 Thu, 01 March 2007 07:37
By: smartin
  Explain plan
By: donind on Thu, 01 March 2007
1 1999 Thu, 01 March 2007 02:59
By: Mohammad Taj
  Performance with materialized view
By: reemagupta18 on Wed, 08 March 2006
1 3268 Thu, 01 March 2007 00:05
By: vivekg19
  Ref :"Understanding Indexes" from Home Page Link
By: josh_snehal on Sat, 24 February 2007
6 4097 Wed, 28 February 2007 13:07
By: smartin
  How to Purge tables ??
By: deepakc on Wed, 28 February 2007
3 1702 Wed, 28 February 2007 12:38
By: smartin
  Reduce the number of Datafiles
By: frozenam_24 on Tue, 27 February 2007
7 2166 Wed, 28 February 2007 00:44
By: frozenam_24
  how to measure the Performance improvement
By: buck444 on Tue, 27 February 2007
4 1800 Tue, 27 February 2007 07:34
By: Mohammad Taj
  Slow Performance of query
By: deepayan on Fri, 02 February 2007
2 4056 Mon, 26 February 2007 10:01
By: skooman
  performance enhancement
By: dr46014 on Sat, 24 February 2007
3 1992 Sun, 25 February 2007 02:52
By: rleishman
  DBMS_STATS.GATHER_SCHEMA_STATS - Suggestion
By: Brayan on Sat, 24 February 2007
2 2892 Sat, 24 February 2007 09:18
By: Mahesh Rajendran
  Optimize mode first_rows returns full table
By: coleex on Fri, 23 February 2007
2 1349 Fri, 23 February 2007 15:38
By: coleex
  Queries not running - pls help
By: sajut on Tue, 30 January 2007
9 2900 Fri, 23 February 2007 12:29
By: michael_bialik
  db statistics after db abnormal shutdown
By: vinu_raj on Thu, 22 February 2007
2 1604 Thu, 22 February 2007 15:12
By: vinu_raj
  doubt on paritions
By: gkodakalla on Thu, 22 February 2007
5 1865 Thu, 22 February 2007 10:29
By: Mahesh Rajendran
  while block is being read.....
By: pramodgarre on Wed, 21 February 2007
2 1828 Thu, 22 February 2007 09:43
By: pramodgarre
  The 10 Longest Running Query
By: rkl1 on Tue, 20 February 2007
3 2151 Thu, 22 February 2007 04:23
By: gintsp
  update performance
By: rcd70 on Wed, 21 February 2007
3 3681 Thu, 22 February 2007 02:37
By: michael_bialik
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Mon May 20 12:47:49 CDT 2024