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

    Replies Views Last message
  Cursor Performance Issue
By: sujit_ocp on Tue, 10 May 2005
1 3925 Tue, 10 May 2005 02:07
By: Barbara Boehmer
  Oracle Schema slowing performance
By: ravin on Wed, 04 May 2005
9 3860 Mon, 09 May 2005 12:23
By: Frank
  Query takes long time -need help to improve Performance
By: pzlj6x on Fri, 06 May 2005
4 1389 Sat, 07 May 2005 08:18
By: pzlj6x
icon9.gif Why does checkpoint only happen at log switch? :(
By: Jadie on Thu, 05 May 2005
2 1486 Fri, 06 May 2005 13:48
By: Jadie
  max size of sga in oracle 81 windows 2000 server
By: reyazan on Thu, 05 May 2005
1 1124 Thu, 05 May 2005 11:47
By: girish.rohini
  dbms_stats
By: balavignesh on Mon, 02 May 2005
2 8421 Tue, 03 May 2005 08:40
By: balavignesh
  Explain Plan Doubt
By: sujit_ocp on Mon, 02 May 2005
5 1268 Mon, 02 May 2005 10:11
By: sujit_ocp
  what should be approximate Size of SGA ?
By: sunil_v_mishra on Sun, 24 April 2005
1 1310 Sun, 01 May 2005 21:08
By: chunyuh
  Deleting from Huge table
By: abc123 on Thu, 28 April 2005
4 1547 Fri, 29 April 2005 11:48
By: pscjhe
  V$SYSSTAT
By: milind_sri on Fri, 29 April 2005
1 1894 Fri, 29 April 2005 08:44
By: Frank Naude
  Rollback segment error in production HELP
By: Anup Pokhrel on Tue, 26 April 2005
1 2820 Thu, 28 April 2005 06:26
By: girish.rohini
icon4.gif Script needed ---- URGENT Please HELP
By: goodfrnd on Wed, 27 April 2005
0 1573 Wed, 27 April 2005 14:08
By: goodfrnd
  How much SGA..?
By: sunil_v_mishra on Wed, 27 April 2005
3 1121 Wed, 27 April 2005 06:09
By: girish.rohini
icon9.gif Help!!!!!!! Tuning using SQL_TRACE
By: ankurgodambe on Thu, 21 April 2005
13 3410 Tue, 26 April 2005 11:06
By: ankurgodambe
  help on network application information
By: Nasser22 on Mon, 25 April 2005
1 756 Mon, 25 April 2005 08:55
By: Mahesh Rajendran
  Avoiding Cursors.
By: krajdba on Fri, 22 April 2005
2 916 Fri, 22 April 2005 09:21
By: smartin
  tuning question
By: Bruce Carson on Tue, 19 April 2005
6 1347 Thu, 21 April 2005 06:29
By: Bruce Carson
icon5.gif Analyze table&Index
By: chara on Wed, 20 April 2005
3 1464 Wed, 20 April 2005 08:53
By: smartin
  Count oracle user process
By: ntnboi on Fri, 15 April 2005
3 3180 Wed, 20 April 2005 06:33
By: ntnboi
  this query is taking 58 seconds to execute
By: rajuakula on Tue, 19 April 2005
1 1148 Tue, 19 April 2005 23:38
By: chunyuh
icon11.gif lock_sga parameter cause out of memory error
By: Bhavindshah34 on Tue, 08 March 2005
2 5192 Tue, 19 April 2005 10:21
By: smartin
  large sort
By: _simma_dba on Fri, 15 April 2005
4 1497 Tue, 19 April 2005 03:21
By: _simma_dba
  URGENT:-Tuning a query
By: milind_sri on Fri, 15 April 2005
1 1200 Sun, 17 April 2005 07:31
By: Maaher
  how to check whether index is rebuilt or not?
By: confident on Fri, 08 April 2005
7 5671 Wed, 13 April 2005 09:06
By: pscjhe
  Check list to Tune an Application ( SQL & PL/SQL)
By: Gurusubramanyam on Wed, 13 April 2005
1 813 Wed, 13 April 2005 08:32
By: Mahesh Rajendran
  STATSPACK
By: balavignesh on Tue, 12 April 2005
1 1176 Tue, 12 April 2005 14:27
By: smartin
  Statspack Report
By: milind_sri on Wed, 06 April 2005
2 1243 Tue, 12 April 2005 12:32
By: pscjhe
  Bulk Exception giving incomplete Information.
By: abc123 on Fri, 08 April 2005
2 2338 Tue, 12 April 2005 08:44
By: smartin
  disk partition strategy for best performance...
By: 760613 on Thu, 07 April 2005
2 872 Mon, 11 April 2005 07:13
By: smartin
  how to see the analyze table
By: ravivkumar on Sun, 10 April 2005
1 887 Sun, 10 April 2005 09:27
By: Mahesh Rajendran
  Oracle 9i Explian Plan output- TOAD
By: kumarsz on Thu, 07 April 2005
1 1932 Thu, 07 April 2005 09:28
By: Mahesh Rajendran
  To tune query
By: anmol1947 on Thu, 07 April 2005
0 1715 Thu, 07 April 2005 08:21
By: anmol1947
  no_index optimizer hint
By: anmol1947 on Thu, 07 April 2005
1 5454 Thu, 07 April 2005 06:36
By: Maaher
  Selecting data out of a partition
By: informatica_developer_mn on Fri, 01 April 2005
1 7227 Fri, 01 April 2005 15:54
By: smartin
  what to tune first
By: sunil_v_mishra on Sat, 19 March 2005
8 2923 Wed, 30 March 2005 20:19
By: andrew again
  Tuning a query
By: milind_sri on Mon, 28 March 2005
1 2090 Mon, 28 March 2005 10:39
By: smartin
  Server response degrades
By: milind_sri on Thu, 24 March 2005
1 866 Thu, 24 March 2005 14:21
By: smartin
  big oracle problem please help
By: dong94 on Tue, 22 March 2005
2 1384 Wed, 23 March 2005 20:46
By: dong94
  PL/SQL code is conusimg alot of shared memory
By: v_gate on Fri, 18 March 2005
1 820 Fri, 18 March 2005 11:26
By: Mahesh Rajendran
icon9.gif Tunning - urgent
By: kavi on Tue, 08 March 2005
4 1229 Fri, 18 March 2005 09:23
By: smartin
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 Jan 27 10:15:49 CST 2021