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

    Replies Views Last message
  Pls help in reducing the buffer gets for the query below
By: aarti.mishra on Fri, 08 September 2006
7 7878 Wed, 15 November 2006 10:11
By: skn
  I need a listing of Oracle indexes and how often they are used, how?
By: aidi-h on Fri, 10 November 2006
7 2491 Wed, 15 November 2006 07:52
By: JRowbottom
  Analyze tables
By: seema.taunk on Mon, 13 November 2006
7 6537 Tue, 14 November 2006 22:52
By: seema.taunk
  Regarding Autotrace execution Plan
By: reena_ch30 on Mon, 13 November 2006
3 2390 Tue, 14 November 2006 00:49
By: Mohammad Taj
  Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT
By: reena_ch30 on Sun, 12 November 2006
3 6254 Mon, 13 November 2006 22:40
By: Mohammad Taj
  Query Optimization problem...
By: deepayan on Tue, 07 November 2006
2 3690 Mon, 13 November 2006 19:50
By: rleishman
icon14.gif Analyze SYS_IL0000 LOB Indexes
By: venkatp6 on Mon, 13 November 2006
1 6570 Mon, 13 November 2006 12:18
By: Mahesh Rajendran
  Index not used in outer join query
By: lars3006 on Wed, 08 November 2006
10 19102 Fri, 10 November 2006 18:51
By: rleishman
  Parrallel Query Problem
By: rkl1 on Fri, 10 November 2006
0 3716 Fri, 10 November 2006 15:10
By: rkl1
  PB statistic CBO
By: Haler on Fri, 10 November 2006
4 1966 Fri, 10 November 2006 12:54
By: Haler
  Perfomace issues on complex query
By: jaydba on Wed, 01 November 2006
9 2301 Thu, 09 November 2006 11:06
By: jaydba
  Creating PK in Each table
By: selvakumar_82 on Mon, 06 November 2006
7 2381 Thu, 09 November 2006 02:38
By: JRowbottom
  help need in optimizing a query....
By: chandanbhamra on Tue, 07 November 2006
0 4097 Tue, 07 November 2006 05:10
By: chandanbhamra
  Performance thumb-rules
By: panda on Wed, 01 November 2006
5 4561 Tue, 07 November 2006 02:44
By: kimant
  Library Cache OVERHEAD
By: orafaqdba on Mon, 06 November 2006
0 3723 Mon, 06 November 2006 12:53
By: orafaqdba
  insert statement runs very slow
By: beastjj on Mon, 06 November 2006
1 2131 Mon, 06 November 2006 02:28
By: beastjj
  v$librarycache
By: Anand Ramaswamy on Fri, 03 November 2006
3 1613 Sun, 05 November 2006 13:35
By: kimant
  Tuning SQL statement in PL/SQL
By: Akshar on Mon, 30 October 2006
12 2822 Sat, 04 November 2006 15:20
By: Akshar
  Will Deleting rows from Table improve Performance?
By: kumarsz on Sat, 04 November 2006
2 1929 Sat, 04 November 2006 14:12
By: kimant
  insert statement runs slow
By: Akshar on Fri, 27 October 2006
7 9101 Sat, 04 November 2006 03:23
By: Admin@Lightsql.Com
  Inserts, update are taking long to execute. How to tune it?
By: jiltin on Wed, 27 September 2006
3 2090 Sat, 04 November 2006 03:08
By: jiltin
  how to change this query, runs forever
By: leahchow on Thu, 02 November 2006
1 1913 Fri, 03 November 2006 00:25
By: rleishman
  Partition Criteria
By: piyushbhatt on Thu, 19 October 2006
2 1813 Thu, 02 November 2006 08:24
By: michael_bialik
  Tuning the query - Outer join
By: bagulia_pilla on Tue, 31 October 2006
4 2172 Thu, 02 November 2006 02:12
By: S.Rajaram
  Performance tuning a table
By: ezhilv on Mon, 30 October 2006
3 1774 Wed, 01 November 2006 07:00
By: michael_bialik
  Advice on Hints
By: ravgopal on Thu, 26 October 2006
7 3728 Mon, 30 October 2006 16:57
By: rleishman
  STATS and Last Analyzed Column
By: faiz_hyd on Mon, 30 October 2006
0 9040 Mon, 30 October 2006 11:01
By: faiz_hyd
  datafile random read average time
By: seema.taunk on Fri, 27 October 2006
2 6942 Mon, 30 October 2006 03:53
By: seema.taunk
  Copying statistics of one table to another
By: a_developer on Mon, 30 October 2006
2 3082 Mon, 30 October 2006 03:16
By: a_developer
  Find the Explain Plan from Trace File
By: bellpk on Tue, 24 October 2006
2 3840 Sun, 29 October 2006 23:27
By: bellpk
  move all objects from tbs to new tbs /rebuild all indexes to new tbs
By: caraless on Fri, 27 October 2006
1 1930 Sat, 28 October 2006 00:05
By: Mohammad Taj
  problem when dropping table
By: aline on Mon, 23 October 2006
6 3882 Fri, 27 October 2006 19:02
By: rleishman
  Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables)
By: caraless on Thu, 26 October 2006
10 8239 Fri, 27 October 2006 09:54
By: caraless
  Check v$sqlarea for shared cursors
By: reena_ch30 on Thu, 26 October 2006
5 1789 Fri, 27 October 2006 00:58
By: reena_ch30
  setting trace file name created using sql trace
By: reena_ch30 on Thu, 26 October 2006
2 1640 Fri, 27 October 2006 00:33
By: reena_ch30
  Update vs CTAS
By: a_developer on Thu, 26 October 2006
2 1934 Thu, 26 October 2006 10:02
By: Kevin Meade
  Regarding v$librarycache
By: reena_ch30 on Thu, 19 October 2006
5 1988 Thu, 26 October 2006 05:34
By: reena_ch30
  Help Deciding on Local or Global Index
By: mdoakes42 on Wed, 25 October 2006
1 2265 Wed, 25 October 2006 21:36
By: rleishman
  Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME
By: beastjj on Wed, 25 October 2006
0 11695 Wed, 25 October 2006 02:41
By: beastjj
  Search option
By: selvakumar_82 on Fri, 20 October 2006
3 1830 Wed, 25 October 2006 00:29
By: rleishman
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: Tue Apr 30 10:05:00 CDT 2024