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

    Replies Views Last message
  Reg. out put of DBMS_XPLAN.DISPLAY
By: d.dineshkumar on Fri, 03 June 2005
6 2582 Sun, 05 June 2005 07:23
By: nabeelkhan
  Select on same table gives poor performace.
By: abc123 on Sat, 04 June 2005
1 2382 Sun, 05 June 2005 02:24
By: nabeelkhan
  Index Partition rebuild Query
By: bhagwan on Fri, 03 June 2005
1 27457 Fri, 03 June 2005 08:16
By: carsten.jorgensen
  The same sql runs very slowly in jboss-cmp,very quickly in native jdbc.
By: peixubin on Wed, 01 June 2005
1 1354 Thu, 02 June 2005 21:01
By: peixubin
  Oracle Server Information
By: well_rbs on Tue, 31 May 2005
1 1275 Tue, 31 May 2005 09:07
By: smartin
  What are the steps to tune a query
By: d.dineshkumar on Mon, 30 May 2005
3 4974 Mon, 30 May 2005 09:08
By: d.dineshkumar
  Datawarehouse query
By: well_rbs on Thu, 26 May 2005
3 1072 Thu, 26 May 2005 20:41
By: well_rbs
  All "Rows" equal 0 in TKPROF. Is this a setting?
By: scottwmackey on Wed, 25 May 2005
6 2171 Thu, 26 May 2005 14:27
By: scottwmackey
  Batch Tuning
By: kanth33 on Mon, 23 May 2005
3 2113 Mon, 23 May 2005 15:49
By: Mahesh Rajendran
  Performance problem!!
By: kinjal on Mon, 23 May 2005
2 1380 Mon, 23 May 2005 09:44
By: Mahesh Rajendran
  activating Online Index Build
By: mbexel on Wed, 18 May 2005
3 4720 Fri, 20 May 2005 08:58
By: smartin
  Statspack for 9i on 8.1.6
By: _simma_dba on Fri, 13 May 2005
1 1465 Fri, 20 May 2005 06:07
By: Frank Naude
icon5.gif Ploblem connect oracle by Vb application
By: chara on Tue, 17 May 2005
3 3629 Wed, 18 May 2005 10:44
By: girish.rohini
  Prameters For Improving DB Perfomance
By: ksst on Fri, 13 May 2005
3 1232 Fri, 13 May 2005 22:33
By: smartin
  statspack top 5 wait event
By: confident on Thu, 12 May 2005
2 1946 Fri, 13 May 2005 07:24
By: Frank
  Comparision of Two Execution Plan
By: sujit_ocp on Tue, 10 May 2005
4 1372 Wed, 11 May 2005 09:07
By: smartin
  ARCHIVELOG GETTING FILLED
By: nitin_228 on Mon, 09 May 2005
1 1156 Tue, 10 May 2005 02:16
By: mihelic
  Cursor Performance Issue
By: sujit_ocp on Tue, 10 May 2005
1 4178 Tue, 10 May 2005 02:07
By: Barbara Boehmer
  Oracle Schema slowing performance
By: ravin on Wed, 04 May 2005
9 4150 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 1599 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 1733 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 1320 Thu, 05 May 2005 11:47
By: girish.rohini
  dbms_stats
By: balavignesh on Mon, 02 May 2005
2 8811 Tue, 03 May 2005 08:40
By: balavignesh
  Explain Plan Doubt
By: sujit_ocp on Mon, 02 May 2005
5 1470 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 1499 Sun, 01 May 2005 21:08
By: chunyuh
  Deleting from Huge table
By: abc123 on Thu, 28 April 2005
4 1774 Fri, 29 April 2005 11:48
By: pscjhe
  V$SYSSTAT
By: milind_sri on Fri, 29 April 2005
1 2110 Fri, 29 April 2005 08:44
By: Frank Naude
  Rollback segment error in production HELP
By: Anup Pokhrel on Tue, 26 April 2005
1 3057 Thu, 28 April 2005 06:26
By: girish.rohini
icon4.gif Script needed ---- URGENT Please HELP
By: goodfrnd on Wed, 27 April 2005
0 1745 Wed, 27 April 2005 14:08
By: goodfrnd
  How much SGA..?
By: sunil_v_mishra on Wed, 27 April 2005
3 1396 Wed, 27 April 2005 06:09
By: girish.rohini
icon9.gif Help!!!!!!! Tuning using SQL_TRACE
By: ankurgodambe on Thu, 21 April 2005
13 3657 Tue, 26 April 2005 11:06
By: ankurgodambe
  help on network application information
By: Nasser22 on Mon, 25 April 2005
1 1001 Mon, 25 April 2005 08:55
By: Mahesh Rajendran
  Avoiding Cursors.
By: krajdba on Fri, 22 April 2005
2 1165 Fri, 22 April 2005 09:21
By: smartin
  tuning question
By: Bruce Carson on Tue, 19 April 2005
6 1532 Thu, 21 April 2005 06:29
By: Bruce Carson
icon5.gif Analyze table&Index
By: chara on Wed, 20 April 2005
3 1658 Wed, 20 April 2005 08:53
By: smartin
  Count oracle user process
By: ntnboi on Fri, 15 April 2005
3 3420 Wed, 20 April 2005 06:33
By: ntnboi
  this query is taking 58 seconds to execute
By: rajuakula on Tue, 19 April 2005
1 1382 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 5446 Tue, 19 April 2005 10:21
By: smartin
  large sort
By: _simma_dba on Fri, 15 April 2005
4 1731 Tue, 19 April 2005 03:21
By: _simma_dba
  URGENT:-Tuning a query
By: milind_sri on Fri, 15 April 2005
1 1421 Sun, 17 April 2005 07:31
By: Maaher
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 Aug 16 12:13:27 CDT 2022