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 7843 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 2472 Wed, 15 November 2006 07:52
By: JRowbottom
  Analyze tables
By: seema.taunk on Mon, 13 November 2006
7 6518 Tue, 14 November 2006 22:52
By: seema.taunk
  Regarding Autotrace execution Plan
By: reena_ch30 on Mon, 13 November 2006
3 2372 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 6223 Mon, 13 November 2006 22:40
By: Mohammad Taj
  Query Optimization problem...
By: deepayan on Tue, 07 November 2006
2 3666 Mon, 13 November 2006 19:50
By: rleishman
icon14.gif Analyze SYS_IL0000 LOB Indexes
By: venkatp6 on Mon, 13 November 2006
1 6551 Mon, 13 November 2006 12:18
By: Mahesh Rajendran
  Index not used in outer join query
By: lars3006 on Wed, 08 November 2006
10 19067 Fri, 10 November 2006 18:51
By: rleishman
  Parrallel Query Problem
By: rkl1 on Fri, 10 November 2006
0 3698 Fri, 10 November 2006 15:10
By: rkl1
  PB statistic CBO
By: Haler on Fri, 10 November 2006
4 1945 Fri, 10 November 2006 12:54
By: Haler
  Perfomace issues on complex query
By: jaydba on Wed, 01 November 2006
9 2282 Thu, 09 November 2006 11:06
By: jaydba
  Creating PK in Each table
By: selvakumar_82 on Mon, 06 November 2006
7 2362 Thu, 09 November 2006 02:38
By: JRowbottom
  help need in optimizing a query....
By: chandanbhamra on Tue, 07 November 2006
0 4082 Tue, 07 November 2006 05:10
By: chandanbhamra
  Performance thumb-rules
By: panda on Wed, 01 November 2006
5 4538 Tue, 07 November 2006 02:44
By: kimant
  Library Cache OVERHEAD
By: orafaqdba on Mon, 06 November 2006
0 3703 Mon, 06 November 2006 12:53
By: orafaqdba
  insert statement runs very slow
By: beastjj on Mon, 06 November 2006
1 2115 Mon, 06 November 2006 02:28
By: beastjj
  v$librarycache
By: Anand Ramaswamy on Fri, 03 November 2006
3 1598 Sun, 05 November 2006 13:35
By: kimant
  Tuning SQL statement in PL/SQL
By: Akshar on Mon, 30 October 2006
12 2800 Sat, 04 November 2006 15:20
By: Akshar
  Will Deleting rows from Table improve Performance?
By: kumarsz on Sat, 04 November 2006
2 1912 Sat, 04 November 2006 14:12
By: kimant
  insert statement runs slow
By: Akshar on Fri, 27 October 2006
7 9078 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 2073 Sat, 04 November 2006 03:08
By: jiltin
  how to change this query, runs forever
By: leahchow on Thu, 02 November 2006
1 1896 Fri, 03 November 2006 00:25
By: rleishman
  Partition Criteria
By: piyushbhatt on Thu, 19 October 2006
2 1799 Thu, 02 November 2006 08:24
By: michael_bialik
  Tuning the query - Outer join
By: bagulia_pilla on Tue, 31 October 2006
4 2150 Thu, 02 November 2006 02:12
By: S.Rajaram
  Performance tuning a table
By: ezhilv on Mon, 30 October 2006
3 1756 Wed, 01 November 2006 07:00
By: michael_bialik
  Advice on Hints
By: ravgopal on Thu, 26 October 2006
7 3706 Mon, 30 October 2006 16:57
By: rleishman
  STATS and Last Analyzed Column
By: faiz_hyd on Mon, 30 October 2006
0 9022 Mon, 30 October 2006 11:01
By: faiz_hyd
  datafile random read average time
By: seema.taunk on Fri, 27 October 2006
2 6920 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 3066 Mon, 30 October 2006 03:16
By: a_developer
  Find the Explain Plan from Trace File
By: bellpk on Tue, 24 October 2006
2 3823 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 1914 Sat, 28 October 2006 00:05
By: Mohammad Taj
  problem when dropping table
By: aline on Mon, 23 October 2006
6 3860 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 8212 Fri, 27 October 2006 09:54
By: caraless
  Check v$sqlarea for shared cursors
By: reena_ch30 on Thu, 26 October 2006
5 1770 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 1622 Fri, 27 October 2006 00:33
By: reena_ch30
  Update vs CTAS
By: a_developer on Thu, 26 October 2006
2 1916 Thu, 26 October 2006 10:02
By: Kevin Meade
  Regarding v$librarycache
By: reena_ch30 on Thu, 19 October 2006
5 1971 Thu, 26 October 2006 05:34
By: reena_ch30
  Help Deciding on Local or Global Index
By: mdoakes42 on Wed, 25 October 2006
1 2245 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 11661 Wed, 25 October 2006 02:41
By: beastjj
  Search option
By: selvakumar_82 on Fri, 20 October 2006
3 1808 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 16 02:51:30 CDT 2024