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

    Replies Views Last message
  Why the Index is not used, even if its forced?
By: nabeelkhan on Thu, 23 June 2005
16 3645 Fri, 30 September 2005 09:00
By: ziggy
  Last n records based on date
By: scottwmackey on Wed, 13 April 2005
19 6157 Fri, 30 September 2005 08:15
By: ziggy
  SQL Query with many joins
By: sebastianR on Thu, 29 September 2005
3 2121 Thu, 29 September 2005 12:06
By: smartin
  how to rebuild index
By: c_gajen on Thu, 29 September 2005
1 2165 Thu, 29 September 2005 09:35
By: Mahesh Rajendran
  Statspack
By: pjose on Mon, 26 September 2005
2 2222 Thu, 29 September 2005 05:52
By: girish.rohini
  SQL TRACE
By: nitin_228 on Tue, 27 September 2005
2 4852 Wed, 28 September 2005 14:39
By: nitin_228
  RAC: "global cache cr request" events take 1 second ocasionally
By: ollibrandt on Tue, 27 September 2005
1 8654 Tue, 27 September 2005 11:53
By: Mahesh Rajendran
  Use PCTfree/Initran/Maxtran to prevent contention
By: mjschwenger on Sat, 24 September 2005
3 5838 Tue, 27 September 2005 11:46
By: smartin
  Poor Performance in Accessing Remote Database
By: genialsenthil on Mon, 26 September 2005
3 2188 Mon, 26 September 2005 06:57
By: Mahesh Rajendran
  Procedure tunning
By: sunil_v_mishra on Fri, 23 September 2005
4 2805 Mon, 26 September 2005 01:57
By: sunil_v_mishra
icon5.gif Solaris 9, 10g hard parse/soft parse what does it mean?
By: nmacdannald on Fri, 23 September 2005
1 3789 Sat, 24 September 2005 06:23
By: Art Metzer
  Can bigger blocksize for indexes help increasing performance and lower I/O
By: mjschwenger on Fri, 23 September 2005
3 2280 Fri, 23 September 2005 10:17
By: mjschwenger
  Tuning the sql by using explain plan
By: balasmg on Thu, 22 September 2005
1 2221 Thu, 22 September 2005 11:05
By: Art Metzer
  "slave shutdown wait" - event
By: shlomi_bt on Wed, 21 September 2005
1 2132 Wed, 21 September 2005 13:13
By: smartin
  Error while installing Statspack
By: oracledbanewbie on Fri, 16 September 2005
3 7489 Mon, 19 September 2005 11:58
By: oracledbanewbie
  how to increase search in the database
By: genialsenthil on Mon, 19 September 2005
2 2375 Mon, 19 September 2005 08:09
By: Art Metzer
icon9.gif The time of 1 Query is more than 1 hour, HELP ¡¡¡
By: IngRMP on Mon, 19 September 2005
1 1900 Mon, 19 September 2005 08:05
By: Art Metzer
  Difference in retrieving number of rows between two queries
By: sharan_it on Mon, 05 September 2005
3 2933 Fri, 16 September 2005 04:12
By: sharan_it
  Execution plan misleads me (merged cross-posts)
By: randres on Thu, 15 September 2005
9 2546 Fri, 16 September 2005 02:28
By: randres
  how to find out if a table has dirty blocks in buffers
By: nile on Thu, 08 September 2005
23 9471 Fri, 16 September 2005 01:41
By: nile
  Oracle9i Function Base index?
By: mitra fatolahi on Tue, 13 September 2005
1 2777 Tue, 13 September 2005 16:00
By: smartin
  different performance results in Oracle9i vs. MSSQL Server 2000
By: mitra fatolahi on Mon, 12 September 2005
2 2484 Mon, 12 September 2005 14:12
By: Mahesh Rajendran
icon4.gif Can I change the DB_BLOCK_SIZE in Oracle 9i?
By: merovingio on Fri, 09 September 2005
7 26031 Mon, 12 September 2005 14:07
By: merovingio
  Resolving "latch free" problems
By: cubittm on Thu, 01 September 2005
1 35978 Mon, 12 September 2005 08:29
By: Frank Naude
  Function Index, is there a limit to the complexity ?
By: deadpoet on Fri, 09 September 2005
1 2106 Fri, 09 September 2005 10:27
By: smartin
  error while taking snapshot..!!
By: balavignesh on Wed, 07 September 2005
3 3019 Thu, 08 September 2005 11:57
By: rsone
  How to stop the Cache Effect ?
By: deadpoet on Tue, 09 August 2005
21 4404 Wed, 07 September 2005 14:19
By: nile
  How I can remove the table from cache? Which command I should execute
By: lanag on Fri, 12 August 2005
4 2603 Tue, 06 September 2005 15:49
By: smartin
  index ignored problem
By: mjschwenger on Fri, 02 September 2005
5 2960 Fri, 02 September 2005 14:29
By: mjschwenger
  Using Hint
By: ynaiyer on Fri, 02 September 2005
2 2340 Fri, 02 September 2005 11:27
By: Art Metzer
  Multiple Tablespaces
By: David King on Wed, 31 August 2005
2 2415 Thu, 01 September 2005 09:56
By: smartin
  Union takes more time please help
By: misha603 on Wed, 31 August 2005
3 4279 Thu, 01 September 2005 09:48
By: smartin
  To increase performance Delete statement
By: ashishodia on Wed, 31 August 2005
5 6635 Thu, 01 September 2005 06:23
By: IngRMP
  query tuning with NVL
By: hrishy on Wed, 24 August 2005
1 4986 Thu, 01 September 2005 03:59
By: Frank Naude
icon5.gif performance tuning
By: dinakar5008 on Sun, 28 August 2005
4 3037 Wed, 31 August 2005 16:15
By: ChrisJr
  How to use index in date column
By: d.dineshkumar on Thu, 18 August 2005
5 6472 Wed, 31 August 2005 09:16
By: d.dineshkumar
  Update issue with high volume table
By: Nits on Mon, 29 August 2005
2 2394 Tue, 30 August 2005 09:23
By: Nits
  highly skewed data distribution
By: sebastianR on Thu, 25 August 2005
5 3176 Mon, 29 August 2005 08:21
By: sebastianR
  clustering vs. reorganization
By: sebastianR on Mon, 29 August 2005
0 2926 Mon, 29 August 2005 05:15
By: sebastianR
  slow DB server
By: manu_jariwala on Wed, 17 August 2005
5 9397 Fri, 26 August 2005 08:18
By: manu_jariwala
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 Jul 08 01:15:26 CDT 2025