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

    Replies Views Last message
  sizing SGA...???
By: balavignesh on Fri, 16 September 2005
15 12452 Fri, 30 September 2005 13:09
By: Hindustanweb
  Why the Index is not used, even if its forced?
By: nabeelkhan on Thu, 23 June 2005
16 4258 Fri, 30 September 2005 09:00
By: ziggy
  Last n records based on date
By: scottwmackey on Wed, 13 April 2005
19 6964 Fri, 30 September 2005 08:15
By: ziggy
  SQL Query with many joins
By: sebastianR on Thu, 29 September 2005
3 2335 Thu, 29 September 2005 12:06
By: smartin
  how to rebuild index
By: c_gajen on Thu, 29 September 2005
1 2334 Thu, 29 September 2005 09:35
By: Mahesh Rajendran
  Statspack
By: pjose on Mon, 26 September 2005
2 2419 Thu, 29 September 2005 05:52
By: girish.rohini
  SQL TRACE
By: nitin_228 on Tue, 27 September 2005
2 5052 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 8815 Tue, 27 September 2005 11:53
By: Mahesh Rajendran
  Use PCTfree/Initran/Maxtran to prevent contention
By: mjschwenger on Sat, 24 September 2005
3 6159 Tue, 27 September 2005 11:46
By: smartin
  Poor Performance in Accessing Remote Database
By: genialsenthil on Mon, 26 September 2005
3 2395 Mon, 26 September 2005 06:57
By: Mahesh Rajendran
  Procedure tunning
By: sunil_v_mishra on Fri, 23 September 2005
4 3091 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 3970 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 2512 Fri, 23 September 2005 10:17
By: mjschwenger
  Tuning the sql by using explain plan
By: balasmg on Thu, 22 September 2005
1 2396 Thu, 22 September 2005 11:05
By: Art Metzer
  "slave shutdown wait" - event
By: shlomi_bt on Wed, 21 September 2005
1 2291 Wed, 21 September 2005 13:13
By: smartin
  Error while installing Statspack
By: oracledbanewbie on Fri, 16 September 2005
3 7714 Mon, 19 September 2005 11:58
By: oracledbanewbie
  how to increase search in the database
By: genialsenthil on Mon, 19 September 2005
2 2552 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 2071 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 3145 Fri, 16 September 2005 04:12
By: sharan_it
  Execution plan misleads me (merged cross-posts)
By: randres on Thu, 15 September 2005
9 2918 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 10423 Fri, 16 September 2005 01:41
By: nile
  Oracle9i Function Base index?
By: mitra fatolahi on Tue, 13 September 2005
1 2964 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 2668 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 26471 Mon, 12 September 2005 14:07
By: merovingio
  Resolving "latch free" problems
By: cubittm on Thu, 01 September 2005
1 36231 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 2276 Fri, 09 September 2005 10:27
By: smartin
  error while taking snapshot..!!
By: balavignesh on Wed, 07 September 2005
3 3245 Thu, 08 September 2005 11:57
By: rsone
  How to stop the Cache Effect ?
By: deadpoet on Tue, 09 August 2005
21 5218 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 2851 Tue, 06 September 2005 15:49
By: smartin
  index ignored problem
By: mjschwenger on Fri, 02 September 2005
5 3243 Fri, 02 September 2005 14:29
By: mjschwenger
  Using Hint
By: ynaiyer on Fri, 02 September 2005
2 2528 Fri, 02 September 2005 11:27
By: Art Metzer
  Multiple Tablespaces
By: David King on Wed, 31 August 2005
2 2625 Thu, 01 September 2005 09:56
By: smartin
  Union takes more time please help
By: misha603 on Wed, 31 August 2005
3 4496 Thu, 01 September 2005 09:48
By: smartin
  To increase performance Delete statement
By: ashishodia on Wed, 31 August 2005
5 6954 Thu, 01 September 2005 06:23
By: IngRMP
  query tuning with NVL
By: hrishy on Wed, 24 August 2005
1 5140 Thu, 01 September 2005 03:59
By: Frank Naude
icon5.gif performance tuning
By: dinakar5008 on Sun, 28 August 2005
4 3282 Wed, 31 August 2005 16:15
By: ChrisJr
  How to use index in date column
By: d.dineshkumar on Thu, 18 August 2005
5 6748 Wed, 31 August 2005 09:16
By: d.dineshkumar
  Update issue with high volume table
By: Nits on Mon, 29 August 2005
2 2590 Tue, 30 August 2005 09:23
By: Nits
  highly skewed data distribution
By: sebastianR on Thu, 25 August 2005
5 3474 Mon, 29 August 2005 08:21
By: sebastianR
  clustering vs. reorganization
By: sebastianR on Mon, 29 August 2005
0 3079 Mon, 29 August 2005 05:15
By: sebastianR
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 Oct 22 10:38:39 CDT 2025