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

    Replies Views Last message
  Full table scan with varying consistent gets
By: skelly on Sat, 05 March 2005
1 2176 Sat, 05 March 2005 22:08
By: Frank Naude
  SQL AREA HIT Ratio
By: timgb on Wed, 23 February 2005
8 11930 Fri, 04 March 2005 11:24
By: Frank
  ORA-04030
By: nemo on Tue, 01 March 2005
2 11284 Fri, 04 March 2005 10:52
By: nemo
  Parallel Hint Question
By: bhagwan on Mon, 21 February 2005
2 2699 Thu, 03 March 2005 04:03
By: anmol1947
  Indexes not working after analyzing tables
By: sridcpp on Tue, 01 March 2005
9 2659 Wed, 02 March 2005 21:48
By: pgongloo
  Performance difference BOLB vs. LONG RAW
By: AllanJones on Wed, 02 March 2005
0 3323 Wed, 02 March 2005 08:55
By: AllanJones
icon7.gif on consumption of resources
By: Tads on Wed, 02 March 2005
1 1929 Wed, 02 March 2005 07:49
By: Tads
  Why Performance and Tuning is important
By: Mustafa on Mon, 21 February 2005
4 2748 Wed, 02 March 2005 01:52
By: Frank
  Does Increasing Field Length Decrease Perf?
By: Steve F on Mon, 31 January 2005
3 2638 Tue, 01 March 2005 15:38
By: andrew again
  Help: chained rows
By: Jadie on Fri, 25 February 2005
4 5445 Mon, 28 February 2005 11:13
By: Frank
  RAW datatype with NUMBER
By: Mack Sundar on Tue, 22 February 2005
5 6922 Thu, 24 February 2005 00:16
By: Mahesh Rajendran
  materialized view
By: Rao Ghanta on Mon, 21 February 2005
1 2149 Wed, 23 February 2005 13:06
By: Mack Sundar
  Invalid Object in sys schema
By: Sarah on Fri, 04 February 2005
1 6781 Wed, 23 February 2005 12:35
By: Mack Sundar
  Diff Execution Plan for Same Query?Pl:help
By: BhavinShah on Thu, 17 February 2005
1 2205 Wed, 23 February 2005 12:14
By: Mack Sundar
  Pass parameter to DML or new procedure?
By: Xenofon Grigoriadis on Tue, 15 February 2005
5 3643 Tue, 22 February 2005 15:51
By: Todd Barry
icon3.gif Replace Outer Join with Unions
By: superbob on Tue, 22 February 2005
1 2660 Tue, 22 February 2005 08:00
By: Master.Richard
  Using Consumer groups
By: Uwe on Tue, 22 February 2005
0 2600 Tue, 22 February 2005 04:35
By: Uwe
  Re: materialized view
By: Sreedhar Reddy on Tue, 22 February 2005
0 2447 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 3395 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 4401 Mon, 21 February 2005 02:39
By: John Hammond
  same statement reparsing again.Pl help
By: BhavinShah on Fri, 18 February 2005
1 2468 Fri, 18 February 2005 06:34
By: Art Metzer
  get proc and package names
By: Vinu on Thu, 17 February 2005
2 2641 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 7393 Wed, 16 February 2005 05:33
By: Frank Naude
  Performance Tuning.very critical
By: Vivek Vijai on Fri, 04 February 2005
5 11332 Tue, 15 February 2005 11:43
By: Mahesh Rajendran
  trace unused tables
By: Panki on Tue, 15 February 2005
2 2734 Tue, 15 February 2005 10:57
By: Mahesh Rajendran
  Connect By Cause Full tablescan:pl help
By: BhavinShah on Tue, 04 January 2005
2 2661 Tue, 15 February 2005 01:49
By: BhavinShah
  Warning from "SYSTEM.DBMS_APPLICATION_INFO" package
By: Diogenes on Thu, 07 October 2004
3 4413 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 2407 Mon, 14 February 2005 02:31
By: Frank Naude
  open_cursors value is exceeded
By: sri on Tue, 07 September 2004
5 7792 Sat, 12 February 2005 02:09
By: Pravin Singh
  CBO vs RBO Explain plan
By: Kilburn High Rd on Fri, 11 February 2005
0 4401 Fri, 11 February 2005 00:39
By: Kilburn High Rd
  Writing a Performance Stress Test
By: Jonas Rosenthal on Mon, 17 January 2005
3 1794 Tue, 08 February 2005 10:57
By: lily
  Response time
By: Nainar on Tue, 08 February 2005
1 2302 Tue, 08 February 2005 03:39
By: Mahesh Rajendran
  SGA Tuning
By: Ammes on Sat, 05 February 2005
1 2594 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 2813 Sun, 06 February 2005 23:30
By: Shikha
  Output display
By: Ant on Fri, 04 February 2005
5 2464 Sun, 06 February 2005 21:05
By: Sreedhar Reddy
  COMPUTE and ESTIMATE
By: lily on Tue, 25 January 2005
2 2031 Fri, 04 February 2005 10:27
By: lily
  performance tunning
By: santosh on Wed, 02 February 2005
3 4304 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 2813 Thu, 03 February 2005 19:55
By: priya
  Oracle join problem (full table scan)
By: John Smith on Tue, 01 February 2005
3 3564 Wed, 02 February 2005 05:55
By: John Smith
  Detrimental effect of many extents
By: helen on Tue, 01 February 2005
4 2951 Wed, 02 February 2005 05:15
By: Madonna ofthe Wasps
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: Sat Jun 15 18:50:05 CDT 2024