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

    Replies Views Last message
  suggestions required to change the query to improve its performance
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production,windows XP
By: venkatadeekshi on Thu, 20 December 2007
2 2064 Thu, 20 December 2007 20:04
By: rleishman
  Changing Query Approach
By: mrk_anand on Mon, 17 December 2007
11 3400 Thu, 20 December 2007 10:46
By: Kevin Meade
  SGA sizing
9.2.0.5
By: kudur_kv on Thu, 20 December 2007
1 1546 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 1633 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 3736 Wed, 19 December 2007 09:11
By: Michel Cadot
  SQL Query Performance
By: rdoggart on Tue, 18 December 2007
9 2246 Wed, 19 December 2007 02:15
By: rdoggart
  Query taking long time to execute
oracle 9i
By: venkatadeekshi on Thu, 13 December 2007
6 3001 Tue, 18 December 2007 23:32
By: venkatadeekshi
  Fetching Cursor Performance
By: Agus211 on Fri, 14 December 2007
14 3563 Tue, 18 December 2007 15:06
By: Kevin Meade
  ORA-03127 error?
By: trantuananh24hg on Tue, 18 December 2007
3 13714 Tue, 18 December 2007 05:24
By: Michel Cadot
  Procedure Performance
Oracle 10g
By: Mannu on Mon, 17 December 2007
6 2979 Tue, 18 December 2007 00:07
By: Mannu
  Indexing for lookup tables
By: srivaths on Sun, 16 December 2007
6 2897 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 4263 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 2695 Mon, 17 December 2007 06:03
By: hidnana
  To improve execution time of query
By: donind on Sun, 16 December 2007
2 1552 Mon, 17 December 2007 01:08
By: rleishman
  Some questions on SQL tuning
By: hidnana on Tue, 11 December 2007
11 2894 Sat, 15 December 2007 22:39
By: rleishman
  STATSPACK
By: lotusdeva on Wed, 12 December 2007
14 4608 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 2344 Fri, 14 December 2007 22:53
By: Mohammad Taj
  This query make much recursive call
By: trantuananh24hg on Thu, 13 December 2007
3 2261 Thu, 13 December 2007 21:08
By: trantuananh24hg
  Optimize large SQL query with multiple joins
By: ramya.pathak on Wed, 12 December 2007
8 3401 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 2359 Wed, 12 December 2007 23:17
By: Mohammad Taj
  DBLink performance issues
By: raj_mat2007 on Mon, 10 December 2007
6 24645 Wed, 12 December 2007 20:04
By: trantuananh24hg
  Need to improve query performance
By: vijay_82 on Wed, 12 December 2007
1 1575 Wed, 12 December 2007 14:35
By: BlackSwan
  IO Performance Problems
By: Bob.Smith on Sun, 09 December 2007
4 2365 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 5915 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 2309 Mon, 10 December 2007 05:47
By: rdoggart
  Use of RBO in 10g
By: kingo on Mon, 10 December 2007
7 2370 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 2626 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 1888 Sat, 08 December 2007 09:03
By: michael_bialik
  disadvantages of optimization
By: anamika_025 on Thu, 06 December 2007
7 4720 Fri, 07 December 2007 13:36
By: BlackSwan
  the query is too slow
By: daria on Wed, 05 December 2007
19 4216 Fri, 07 December 2007 00:24
By: daria
  Query with aggregate function not using index
By: ndahafa on Thu, 06 December 2007
7 3175 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 1797 Wed, 05 December 2007 20:52
By: rleishman
  Can you explain to me?
By: trantuananh24hg on Wed, 05 December 2007
0 9601 Wed, 05 December 2007 20:30
By: trantuananh24hg
  error in stat pack
By: pratik123 on Wed, 05 December 2007
6 12054 Wed, 05 December 2007 02:18
By: pratik123
  Faceing Database Performance Related Problem
window server 2003
By: jainarayan5484 on Wed, 05 December 2007
2 1614 Wed, 05 December 2007 00:35
By: BlackSwan
  DBMS_STATS Problem
By: babuknb on Tue, 04 December 2007
4 7467 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 2645 Tue, 04 December 2007 03:56
By: spmano1983
  Performance Degrads
By: subbu_tce on Mon, 03 December 2007
13 3356 Tue, 04 December 2007 01:31
By: pablolee
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2453 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 1482 Sun, 02 December 2007 19:59
By: rleishman
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 08 22:37:58 CST 2025