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 7908 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 2520 Wed, 15 November 2006 07:52
By: JRowbottom
  Analyze tables
By: seema.taunk on Mon, 13 November 2006
7 6562 Tue, 14 November 2006 22:52
By: seema.taunk
  Regarding Autotrace execution Plan
By: reena_ch30 on Mon, 13 November 2006
3 2417 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 6282 Mon, 13 November 2006 22:40
By: Mohammad Taj
  Query Optimization problem...
By: deepayan on Tue, 07 November 2006
2 3718 Mon, 13 November 2006 19:50
By: rleishman
icon14.gif Analyze SYS_IL0000 LOB Indexes
By: venkatp6 on Mon, 13 November 2006
1 6611 Mon, 13 November 2006 12:18
By: Mahesh Rajendran
  Index not used in outer join query
By: lars3006 on Wed, 08 November 2006
10 19158 Fri, 10 November 2006 18:51
By: rleishman
  Parrallel Query Problem
By: rkl1 on Fri, 10 November 2006
0 3750 Fri, 10 November 2006 15:10
By: rkl1
  PB statistic CBO
By: Haler on Fri, 10 November 2006
4 1993 Fri, 10 November 2006 12:54
By: Haler
  Perfomace issues on complex query
By: jaydba on Wed, 01 November 2006
9 2331 Thu, 09 November 2006 11:06
By: jaydba
  Creating PK in Each table
By: selvakumar_82 on Mon, 06 November 2006
7 2406 Thu, 09 November 2006 02:38
By: JRowbottom
  help need in optimizing a query....
By: chandanbhamra on Tue, 07 November 2006
0 4125 Tue, 07 November 2006 05:10
By: chandanbhamra
  Performance thumb-rules
By: panda on Wed, 01 November 2006
5 4591 Tue, 07 November 2006 02:44
By: kimant
  Library Cache OVERHEAD
By: orafaqdba on Mon, 06 November 2006
0 3750 Mon, 06 November 2006 12:53
By: orafaqdba
  insert statement runs very slow
By: beastjj on Mon, 06 November 2006
1 2158 Mon, 06 November 2006 02:28
By: beastjj
  v$librarycache
By: Anand Ramaswamy on Fri, 03 November 2006
3 1639 Sun, 05 November 2006 13:35
By: kimant
  Tuning SQL statement in PL/SQL
By: Akshar on Mon, 30 October 2006
12 2851 Sat, 04 November 2006 15:20
By: Akshar
  Will Deleting rows from Table improve Performance?
By: kumarsz on Sat, 04 November 2006
2 1961 Sat, 04 November 2006 14:12
By: kimant
  insert statement runs slow
By: Akshar on Fri, 27 October 2006
7 9137 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 2117 Sat, 04 November 2006 03:08
By: jiltin
  how to change this query, runs forever
By: leahchow on Thu, 02 November 2006
1 1941 Fri, 03 November 2006 00:25
By: rleishman
  Partition Criteria
By: piyushbhatt on Thu, 19 October 2006
2 1844 Thu, 02 November 2006 08:24
By: michael_bialik
  Tuning the query - Outer join
By: bagulia_pilla on Tue, 31 October 2006
4 2200 Thu, 02 November 2006 02:12
By: S.Rajaram
  Performance tuning a table
By: ezhilv on Mon, 30 October 2006
3 1800 Wed, 01 November 2006 07:00
By: michael_bialik
  Advice on Hints
By: ravgopal on Thu, 26 October 2006
7 3759 Mon, 30 October 2006 16:57
By: rleishman
  STATS and Last Analyzed Column
By: faiz_hyd on Mon, 30 October 2006
0 9068 Mon, 30 October 2006 11:01
By: faiz_hyd
  datafile random read average time
By: seema.taunk on Fri, 27 October 2006
2 6983 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 3110 Mon, 30 October 2006 03:16
By: a_developer
  Find the Explain Plan from Trace File
By: bellpk on Tue, 24 October 2006
2 3869 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 1954 Sat, 28 October 2006 00:05
By: Mohammad Taj
  problem when dropping table
By: aline on Mon, 23 October 2006
6 3908 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 8264 Fri, 27 October 2006 09:54
By: caraless
  Check v$sqlarea for shared cursors
By: reena_ch30 on Thu, 26 October 2006
5 1818 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 1671 Fri, 27 October 2006 00:33
By: reena_ch30
  Update vs CTAS
By: a_developer on Thu, 26 October 2006
2 1962 Thu, 26 October 2006 10:02
By: Kevin Meade
  Regarding v$librarycache
By: reena_ch30 on Thu, 19 October 2006
5 2015 Thu, 26 October 2006 05:34
By: reena_ch30
  Help Deciding on Local or Global Index
By: mdoakes42 on Wed, 25 October 2006
1 2294 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 11787 Wed, 25 October 2006 02:41
By: beastjj
  Search option
By: selvakumar_82 on Fri, 20 October 2006
3 1855 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: Mon May 27 03:50:08 CDT 2024