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

    Replies Views Last message
icon3.gif Replace Outer Join with Unions
By: superbob on Tue, 22 February 2005
1 1796 Tue, 22 February 2005 08:00
By: Master.Richard
  Using Consumer groups
By: Uwe on Tue, 22 February 2005
0 1646 Tue, 22 February 2005 04:35
By: Uwe
  Re: materialized view
By: Sreedhar Reddy on Tue, 22 February 2005
0 1577 Tue, 22 February 2005 03:24
By: Sreedhar Reddy
  Does DML on Global temp table generates REDO
By: Vivek Vijai on Tue, 15 February 2005
4 2504 Mon, 21 February 2005 03:39
By: Vivek Vijai
  CBO estimates Bitmap Index retrieval at 100 times Btree cost.
By: John Hammond on Sun, 20 February 2005
1 3399 Mon, 21 February 2005 02:39
By: John Hammond
  same statement reparsing again.Pl help
By: BhavinShah on Fri, 18 February 2005
1 1547 Fri, 18 February 2005 06:34
By: Art Metzer
  get proc and package names
By: Vinu on Thu, 17 February 2005
2 1788 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 6584 Wed, 16 February 2005 05:33
By: Frank Naude
  Performance Tuning.very critical
By: Vivek Vijai on Fri, 04 February 2005
5 10445 Tue, 15 February 2005 11:43
By: Mahesh Rajendran
  trace unused tables
By: Panki on Tue, 15 February 2005
2 1899 Tue, 15 February 2005 10:57
By: Mahesh Rajendran
  Connect By Cause Full tablescan:pl help
By: BhavinShah on Tue, 04 January 2005
2 1784 Tue, 15 February 2005 01:49
By: BhavinShah
  Warning from "SYSTEM.DBMS_APPLICATION_INFO" package
By: Diogenes on Thu, 07 October 2004
3 3426 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 1579 Mon, 14 February 2005 02:31
By: Frank Naude
  open_cursors value is exceeded
By: sri on Tue, 07 September 2004
5 6854 Sat, 12 February 2005 02:09
By: Pravin Singh
  CBO vs RBO Explain plan
By: Kilburn High Rd on Fri, 11 February 2005
0 3603 Fri, 11 February 2005 00:39
By: Kilburn High Rd
  Writing a Performance Stress Test
By: Jonas Rosenthal on Mon, 17 January 2005
3 970 Tue, 08 February 2005 10:57
By: lily
  Response time
By: Nainar on Tue, 08 February 2005
1 1496 Tue, 08 February 2005 03:39
By: Mahesh Rajendran
  SGA Tuning
By: Ammes on Sat, 05 February 2005
1 1755 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 1936 Sun, 06 February 2005 23:30
By: Shikha
  Output display
By: Ant on Fri, 04 February 2005
5 1612 Sun, 06 February 2005 21:05
By: Sreedhar Reddy
  COMPUTE and ESTIMATE
By: lily on Tue, 25 January 2005
2 1175 Fri, 04 February 2005 10:27
By: lily
  performance tunning
By: santosh on Wed, 02 February 2005
3 3426 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 1967 Thu, 03 February 2005 19:55
By: priya
  Oracle join problem (full table scan)
By: John Smith on Tue, 01 February 2005
3 2733 Wed, 02 February 2005 05:55
By: John Smith
  Detrimental effect of many extents
By: helen on Tue, 01 February 2005
4 2149 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 1615 Tue, 01 February 2005 09:35
By: Andrea Correale
  oracle10g
By: Vishal on Tue, 01 February 2005
1 1768 Tue, 01 February 2005 03:56
By: Frank Naude
  Temporary tablespace growing very fast
By: Vivek Vijai on Fri, 28 January 2005
4 2305 Mon, 31 January 2005 22:50
By: Vivek Vijai
  Buffer Cache and Shared Pool
By: Sarah on Mon, 31 January 2005
2 1678 Mon, 31 January 2005 11:47
By: Sarah
  Error 942 happened during loading of queue
By: Vivek Vijai on Sat, 29 January 2005
1 3087 Mon, 31 January 2005 06:15
By: Mahesh Rajendran
  Hidden Parameters .
By: Narayan Venkat on Thu, 27 January 2005
1 1082 Thu, 27 January 2005 21:23
By: Frank
  DML suddenly taking a long time
By: Shikha on Tue, 25 January 2005
5 1340 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 1665 Wed, 26 January 2005 09:43
By: KAIn
  Perfomance difference
By: anuradha.vl on Sat, 08 January 2005
2 1101 Mon, 24 January 2005 22:54
By: Ashok kumar
  Indexes
By: Natasha on Mon, 24 January 2005
2 1171 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 1237 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 1150 Fri, 21 January 2005 03:58
By: Mahesh Rajendran
  SLOW TABLE DROPS
By: Harry ronis on Thu, 20 January 2005
1 964 Thu, 20 January 2005 23:29
By: Frank Naude
  9i . suddenly started running slow
By: Vivek Vijai on Thu, 20 January 2005
2 1127 Thu, 20 January 2005 21:21
By: Frank
  some questions on tuning.
By: Naveen on Thu, 20 January 2005
0 1840 Thu, 20 January 2005 10:15
By: Naveen
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 May 24 16:58:52 CDT 2022