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

    Replies Views Last message
  Covering Index - Execution plan
By: Patrick Tahiri on Tue, 09 March 2004
2 921 Tue, 09 March 2004 22:01
By: Patrick Tahiri
  9i Performance on NT4
By: deni on Thu, 04 March 2004
3 1674 Sat, 06 March 2004 03:18
By: Thiru
  create index on date fields
By: santosh on Tue, 02 March 2004
3 1220 Thu, 04 March 2004 02:02
By: santosh
  SYSTEM STATISTICS in Distributed Enviornment
By: Prasad on Mon, 23 February 2004
5 2748 Wed, 03 March 2004 08:29
By: Thiru
  redo logs size ?
By: yves-andre balek on Mon, 01 March 2004
1 1445 Tue, 02 March 2004 04:06
By: Thiru
  Sort_Area_Size
By: shesha on Mon, 01 March 2004
1 1119 Tue, 02 March 2004 03:23
By: Frank Naude
  How to trace Application Activity?
By: kothari Alpesh on Mon, 01 March 2004
1 1230 Tue, 02 March 2004 03:12
By: Frank Naude
  Why Don Burleson's "get_busy.ksh" does'nt work?
By: Tian Maohuai on Thu, 26 February 2004
3 1110 Mon, 01 March 2004 02:52
By: Thiru
  Query Results not coming second time
By: kamal matta on Mon, 23 February 2004
6 1500 Mon, 01 March 2004 02:31
By: kamal matta
  how do i read new messages in cursor
By: Vinod on Sun, 29 February 2004
0 2115 Sun, 29 February 2004 23:22
By: Vinod
  Limiting the number of hits to 1 with rownum.
By: Patrick Tahiri on Thu, 26 February 2004
4 1361 Sun, 29 February 2004 22:13
By: Patrick Tahiri
  Stored Procedure - Bind Variables - Performance
By: Patrick Tahiri on Thu, 26 February 2004
3 1052 Sun, 29 February 2004 22:12
By: Patrick Tahiri
  Oracle 9i optimizer
By: NDU on Mon, 23 February 2004
3 1210 Sun, 29 February 2004 03:53
By: Thiru
  automate spurge.sql job
By: Tjan on Fri, 27 February 2004
1 1502 Sat, 28 February 2004 23:24
By: Frank Naude
  optimizing query - taking way too long to run
By: Rabeeha Khan on Thu, 19 February 2004
1 827 Thu, 26 February 2004 03:18
By: Frank Naude
  buffer cache hit ratio reduces to -3
By: kamal matta on Mon, 23 February 2004
3 1099 Tue, 24 February 2004 22:57
By: kamal matta
  SQL*Net Message from client
By: Joe Fabiano on Sat, 21 February 2004
2 2328 Mon, 23 February 2004 08:50
By: Thiru
  Very slow wildcard query
By: Rohan on Thu, 19 February 2004
4 2446 Mon, 23 February 2004 04:58
By: Thiru
  cost based optimizer
By: ora on Fri, 20 February 2004
2 2213 Fri, 20 February 2004 22:21
By: Manish Thawani
  Explain Plan - Which is the best?
By: Patrick Tahiri on Thu, 19 February 2004
6 1663 Fri, 20 February 2004 09:24
By: Thiru
  SYSTEM STATISTICS
By: Prasad on Wed, 18 February 2004
3 4824 Fri, 20 February 2004 06:42
By: Thiru
  Locking Table
By: Qavi on Wed, 18 February 2004
1 914 Thu, 19 February 2004 07:29
By: Michel Bartov
  Index Performance - autotrace on explain
By: Patrick Tahiri on Wed, 18 February 2004
3 1150 Thu, 19 February 2004 03:29
By: Thiru
  ora-0313 and XML
By: agnes on Wed, 18 February 2004
0 3301 Wed, 18 February 2004 19:34
By: agnes
  How to create "stats$tab_stats" ?
By: Tian Maohuai on Tue, 17 February 2004
2 1655 Wed, 18 February 2004 15:46
By: Tian Maohuai
  Expensive Hardware, not much faster!
By: justin on Mon, 16 February 2004
2 962 Wed, 18 February 2004 04:17
By: justin
  Oracle 9i tuning self test wanted
By: lavanya on Tue, 17 February 2004
1 897 Wed, 18 February 2004 03:54
By: Thiru
  Oracle 7 does not use index properly
By: flo on Sun, 15 February 2004
2 1157 Tue, 17 February 2004 08:34
By: Thiru
  Oracle 9i Performance Doubts
By: Prasad on Tue, 17 February 2004
1 1101 Tue, 17 February 2004 05:59
By: Thiru
  Performance Problem / Query Problem
By: kothari Alpesh on Sun, 15 February 2004
0 2014 Sun, 15 February 2004 18:43
By: kothari Alpesh
  number of stmts executed against an oracle instance
By: Mo on Thu, 12 February 2004
1 1264 Sat, 14 February 2004 03:52
By: Thiru
  10 % Hit Ratio
By: Qavi on Mon, 09 February 2004
3 861 Thu, 12 February 2004 09:59
By: Thiru
  Sample database for tuning tests
By: Christian on Mon, 09 February 2004
1 3306 Wed, 11 February 2004 10:03
By: ilver
  local vs dictionary tablespaces
By: Sam on Mon, 09 February 2004
2 1015 Wed, 11 February 2004 06:46
By: Thiru
  size of the tables
By: Sam on Sun, 08 February 2004
1 1307 Mon, 09 February 2004 06:56
By: Thiru
  1oo Hit Ratio
By: Qavi on Mon, 09 February 2004
1 876 Mon, 09 February 2004 06:51
By: Thiru
  Re:Table of 1.4 gb size returns 0rows
By: paramaguru_k on Sat, 07 February 2004
1 1132 Sun, 08 February 2004 03:23
By: Thiru
  Criteria for Initial Extents and Next Extents of Blank Table and Having Rows in above 8 Lakhs
By: Arvind Bhandari on Thu, 05 February 2004
1 912 Fri, 06 February 2004 04:15
By: Thiru
  Query Optimization
By: PagInit on Wed, 28 January 2004
2 905 Thu, 05 February 2004 09:29
By: Michel Bartov
  Analyze table and Index usage by CBO
By: Venkatramanan on Tue, 03 February 2004
1 1419 Tue, 03 February 2004 15:28
By: Thiru
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: Sun Mar 26 08:14:14 CDT 2023