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

    Replies Views Last message
  CBO estimates Bitmap Index retrieval at 100 times Btree cost.
By: John Hammond on Sun, 20 February 2005
1 3333 Mon, 21 February 2005 02:39
By: John Hammond
  same statement reparsing again.Pl help
By: BhavinShah on Fri, 18 February 2005
1 1462 Fri, 18 February 2005 06:34
By: Art Metzer
  get proc and package names
By: Vinu on Thu, 17 February 2005
2 1759 Thu, 17 February 2005 22:16
By: Vinu
  Urgent:How to find long running query in Oracle
By: Mounesh S.P. on Mon, 14 February 2005
1 6539 Wed, 16 February 2005 05:33
By: Frank Naude
  Performance Tuning.very critical
By: Vivek Vijai on Fri, 04 February 2005
5 10398 Tue, 15 February 2005 11:43
By: Mahesh Rajendran
  trace unused tables
By: Panki on Tue, 15 February 2005
2 1863 Tue, 15 February 2005 10:57
By: Mahesh Rajendran
  Connect By Cause Full tablescan:pl help
By: BhavinShah on Tue, 04 January 2005
2 1718 Tue, 15 February 2005 01:49
By: BhavinShah
  Warning from "SYSTEM.DBMS_APPLICATION_INFO" package
By: Diogenes on Thu, 07 October 2004
3 3380 Mon, 14 February 2005 14:11
By: Tomaz Barrantes Jr.
  What is size of the INSTANCE
By: Vivek Vijai on Wed, 09 February 2005
1 1546 Mon, 14 February 2005 02:31
By: Frank Naude
  open_cursors value is exceeded
By: sri on Tue, 07 September 2004
5 6807 Sat, 12 February 2005 02:09
By: Pravin Singh
  CBO vs RBO Explain plan
By: Kilburn High Rd on Fri, 11 February 2005
0 3570 Fri, 11 February 2005 00:39
By: Kilburn High Rd
  Writing a Performance Stress Test
By: Jonas Rosenthal on Mon, 17 January 2005
3 934 Tue, 08 February 2005 10:57
By: lily
  Response time
By: Nainar on Tue, 08 February 2005
1 1443 Tue, 08 February 2005 03:39
By: Mahesh Rajendran
  SGA Tuning
By: Ammes on Sat, 05 February 2005
1 1709 Mon, 07 February 2005 01:08
By: vinay
  Index not properly used when LIKE operator used
By: Sreedhar Reddy on Sun, 06 February 2005
3 1872 Sun, 06 February 2005 23:30
By: Shikha
  Output display
By: Ant on Fri, 04 February 2005
5 1578 Sun, 06 February 2005 21:05
By: Sreedhar Reddy
  COMPUTE and ESTIMATE
By: lily on Tue, 25 January 2005
2 1119 Fri, 04 February 2005 10:27
By: lily
  performance tunning
By: santosh on Wed, 02 February 2005
3 3316 Fri, 04 February 2005 01:48
By: Mahesh Rajendran
  Joining tables - Compare multiple columns of a table with a Single column of oth
By: priya on Tue, 01 February 2005
2 1909 Thu, 03 February 2005 19:55
By: priya
  Oracle join problem (full table scan)
By: John Smith on Tue, 01 February 2005
3 2689 Wed, 02 February 2005 05:55
By: John Smith
  Detrimental effect of many extents
By: helen on Tue, 01 February 2005
4 2116 Wed, 02 February 2005 05:15
By: Madonna ofthe Wasps
  please help me interpret this tkprof
By: Andrea Correale on Mon, 31 January 2005
4 1560 Tue, 01 February 2005 09:35
By: Andrea Correale
  oracle10g
By: Vishal on Tue, 01 February 2005
1 1694 Tue, 01 February 2005 03:56
By: Frank Naude
  Temporary tablespace growing very fast
By: Vivek Vijai on Fri, 28 January 2005
4 2220 Mon, 31 January 2005 22:50
By: Vivek Vijai
  Buffer Cache and Shared Pool
By: Sarah on Mon, 31 January 2005
2 1646 Mon, 31 January 2005 11:47
By: Sarah
  Error 942 happened during loading of queue
By: Vivek Vijai on Sat, 29 January 2005
1 2998 Mon, 31 January 2005 06:15
By: Mahesh Rajendran
  Hidden Parameters .
By: Narayan Venkat on Thu, 27 January 2005
1 1018 Thu, 27 January 2005 21:23
By: Frank
  DML suddenly taking a long time
By: Shikha on Tue, 25 January 2005
5 1268 Wed, 26 January 2005 22:11
By: Frank
  Latch waits are 39% of non-idle wait time
By: lily on Tue, 25 January 2005
1 1635 Wed, 26 January 2005 09:43
By: KAIn
  Perfomance difference
By: anuradha.vl on Sat, 08 January 2005
2 1072 Mon, 24 January 2005 22:54
By: Ashok kumar
  Indexes
By: Natasha on Mon, 24 January 2005
2 1096 Mon, 24 January 2005 07:12
By: Scott Swank
  join conditions for smaller /larger tables
By: Neeraj Ranjan Rath on Mon, 24 January 2005
1 1183 Mon, 24 January 2005 02:25
By: Tony Andrews
  What if index using index is not sufficient
By: Vinu on Thu, 20 January 2005
4 1048 Fri, 21 January 2005 03:58
By: Mahesh Rajendran
  SLOW TABLE DROPS
By: Harry ronis on Thu, 20 January 2005
1 927 Thu, 20 January 2005 23:29
By: Frank Naude
  9i . suddenly started running slow
By: Vivek Vijai on Thu, 20 January 2005
2 1074 Thu, 20 January 2005 21:21
By: Frank
  some questions on tuning.
By: Naveen on Thu, 20 January 2005
0 1796 Thu, 20 January 2005 10:15
By: Naveen
  improving performace of oracle 9i application server release 1.0
By: mehul on Thu, 20 January 2005
0 1465 Thu, 20 January 2005 02:31
By: mehul
  Index not being used for query
By: Vinu on Sun, 16 January 2005
9 1059 Tue, 18 January 2005 00:44
By: Tony Andrews
  row cache lock: Cache id 8 - dc tables on QUERIES.
By: Jonas Rosenthal on Mon, 17 January 2005
0 1965 Mon, 17 January 2005 22:39
By: Jonas Rosenthal
  Required Index .(Urgent help)
By: Brayan on Fri, 14 January 2005
1 868 Mon, 17 January 2005 03:52
By: Tony Andrews
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: Wed Dec 01 18:52:37 CST 2021