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

    Replies Views Last message
  SGA sizing
9.2.0.5
By: kudur_kv on Thu, 20 December 2007
1 1254 Thu, 20 December 2007 10:23
By: Michel Cadot
icon5.gif shared pool size tunning
Oracle9i,Windows2000
By: chara on Thu, 20 December 2007
1 1395 Thu, 20 December 2007 02:30
By: varu123
  Query taking too much time than usual to execute
By: irremediable on Thu, 13 December 2007
9 3175 Wed, 19 December 2007 09:11
By: Michel Cadot
  SQL Query Performance
By: rdoggart on Tue, 18 December 2007
9 1873 Wed, 19 December 2007 02:15
By: rdoggart
  Query taking long time to execute
oracle 9i
By: venkatadeekshi on Thu, 13 December 2007
6 2624 Tue, 18 December 2007 23:32
By: venkatadeekshi
  Fetching Cursor Performance
By: Agus211 on Fri, 14 December 2007
14 2916 Tue, 18 December 2007 15:06
By: Kevin Meade
  ORA-03127 error?
By: trantuananh24hg on Tue, 18 December 2007
3 12973 Tue, 18 December 2007 05:24
By: Michel Cadot
  Procedure Performance
Oracle 10g
By: Mannu on Mon, 17 December 2007
6 1778 Tue, 18 December 2007 00:07
By: Mannu
  Indexing for lookup tables
By: srivaths on Sun, 16 December 2007
6 2414 Mon, 17 December 2007 20:29
By: rleishman
  Optimum value for INITIAL_EXTENT
oracle 9.2.0.8
By: arunprasad_bh on Mon, 17 December 2007
2 3875 Mon, 17 December 2007 14:21
By: andrew again
  While SQL tuning : Is NULL, In vs Exists
By: hidnana on Fri, 14 December 2007
4 2358 Mon, 17 December 2007 06:03
By: hidnana
  To improve execution time of query
By: donind on Sun, 16 December 2007
2 1262 Mon, 17 December 2007 01:08
By: rleishman
  Some questions on SQL tuning
By: hidnana on Tue, 11 December 2007
11 2388 Sat, 15 December 2007 22:39
By: rleishman
  STATSPACK
By: lotusdeva on Wed, 12 December 2007
14 4092 Sat, 15 December 2007 09:49
By: BlackSwan
  Oracle Memory Leakage
9.2.0.5.0, Sun OS 5.9
By: kudur_kv on Thu, 13 December 2007
4 1713 Fri, 14 December 2007 22:53
By: Mohammad Taj
  This query make much recursive call
By: trantuananh24hg on Thu, 13 December 2007
3 1961 Thu, 13 December 2007 21:08
By: trantuananh24hg
  Optimize large SQL query with multiple joins
By: ramya.pathak on Wed, 12 December 2007
8 2897 Thu, 13 December 2007 01:12
By: trantuananh24hg
  takes more time to open lov
forms 6i , oracle -9i
By: ishika_20 on Wed, 12 December 2007
4 2076 Wed, 12 December 2007 23:17
By: Mohammad Taj
  DBLink performance issues
By: raj_mat2007 on Mon, 10 December 2007
6 24090 Wed, 12 December 2007 20:04
By: trantuananh24hg
  Need to improve query performance
By: vijay_82 on Wed, 12 December 2007
1 1240 Wed, 12 December 2007 14:35
By: BlackSwan
  IO Performance Problems
By: Bob.Smith on Sun, 09 December 2007
4 1916 Tue, 11 December 2007 11:20
By: BlackSwan
  How to disable archivelog generation for a patricular session ?
oracle 9.2.0.2.0, sunsolaris 5.9
By: kesavansundaram on Tue, 11 December 2007
5 5396 Tue, 11 December 2007 07:07
By: Mohammad Taj
  Poorly performing SQL query
Oracle 9.2.0.6 on Solaris
By: rdoggart on Fri, 07 December 2007
7 1920 Mon, 10 December 2007 05:47
By: rdoggart
  Use of RBO in 10g
By: kingo on Mon, 10 December 2007
7 1855 Mon, 10 December 2007 03:11
By: Michel Cadot
  Need to tune SQL involving Join
Oracle 10g
By: hidnana on Wed, 05 December 2007
8 2305 Mon, 10 December 2007 01:40
By: rleishman
  A question about SQL * net message in a batch program
9.2.0.8 on Solaris
By: orausern on Mon, 03 December 2007
5 1590 Sat, 08 December 2007 09:03
By: michael_bialik
  disadvantages of optimization
By: anamika_025 on Thu, 06 December 2007
7 4252 Fri, 07 December 2007 13:36
By: BlackSwan
  the query is too slow
By: daria on Wed, 05 December 2007
19 3580 Fri, 07 December 2007 00:24
By: daria
  Query with aggregate function not using index
By: ndahafa on Thu, 06 December 2007
7 2822 Thu, 06 December 2007 19:45
By: rleishman
icon8.gif Outer Join is very very slow
Oracle, 10g, 10.2.0.2.0
By: klkoona on Wed, 05 December 2007
2 1292 Wed, 05 December 2007 20:52
By: rleishman
  Can you explain to me?
By: trantuananh24hg on Wed, 05 December 2007
0 9274 Wed, 05 December 2007 20:30
By: trantuananh24hg
  error in stat pack
By: pratik123 on Wed, 05 December 2007
6 11162 Wed, 05 December 2007 02:18
By: pratik123
  Faceing Database Performance Related Problem
window server 2003
By: jainarayan5484 on Wed, 05 December 2007
2 1294 Wed, 05 December 2007 00:35
By: BlackSwan
  DBMS_STATS Problem
By: babuknb on Tue, 04 December 2007
4 7129 Tue, 04 December 2007 07:58
By: babuknb
  Shows difference in EXPLAIN PLAN result for same query.
By: pravin3032 on Sun, 02 December 2007
9 2220 Tue, 04 December 2007 03:56
By: spmano1983
  Performance Degrads
By: subbu_tce on Mon, 03 December 2007
13 2897 Tue, 04 December 2007 01:31
By: pablolee
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2176 Sun, 02 December 2007 20:12
By: rleishman
  Weird client performance problem
10gR2 Standard Edition RAC; 10gR2 Instant Client
By: dhock194 on Sun, 02 December 2007
1 1256 Sun, 02 December 2007 19:59
By: rleishman
  Question about joins
By: SRIVASUWIN on Thu, 29 November 2007
3 1679 Sat, 01 December 2007 20:09
By: rleishman
icon4.gif Poor Insert Performance after table truncation was interupted
By: williamhwh on Fri, 30 November 2007
3 1623 Sat, 01 December 2007 13:30
By: michael_bialik
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: Fri May 17 17:02:23 CDT 2024