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 2068 Thu, 20 December 2007 20:04
By: rleishman
  Changing Query Approach
By: mrk_anand on Mon, 17 December 2007
11 3422 Thu, 20 December 2007 10:46
By: Kevin Meade
  SGA sizing
9.2.0.5
By: kudur_kv on Thu, 20 December 2007
1 1553 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 1639 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 3809 Wed, 19 December 2007 09:11
By: Michel Cadot
  SQL Query Performance
By: rdoggart on Tue, 18 December 2007
9 2260 Wed, 19 December 2007 02:15
By: rdoggart
  Query taking long time to execute
oracle 9i
By: venkatadeekshi on Thu, 13 December 2007
6 3014 Tue, 18 December 2007 23:32
By: venkatadeekshi
  Fetching Cursor Performance
By: Agus211 on Fri, 14 December 2007
14 3684 Tue, 18 December 2007 15:06
By: Kevin Meade
  ORA-03127 error?
By: trantuananh24hg on Tue, 18 December 2007
3 13755 Tue, 18 December 2007 05:24
By: Michel Cadot
  Procedure Performance
Oracle 10g
By: Mannu on Mon, 17 December 2007
6 3024 Tue, 18 December 2007 00:07
By: Mannu
  Indexing for lookup tables
By: srivaths on Sun, 16 December 2007
6 2924 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 4269 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 2710 Mon, 17 December 2007 06:03
By: hidnana
  To improve execution time of query
By: donind on Sun, 16 December 2007
2 1573 Mon, 17 December 2007 01:08
By: rleishman
  Some questions on SQL tuning
By: hidnana on Tue, 11 December 2007
11 2927 Sat, 15 December 2007 22:39
By: rleishman
  STATSPACK
By: lotusdeva on Wed, 12 December 2007
14 4631 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 2357 Fri, 14 December 2007 22:53
By: Mohammad Taj
  This query make much recursive call
By: trantuananh24hg on Thu, 13 December 2007
3 2268 Thu, 13 December 2007 21:08
By: trantuananh24hg
  Optimize large SQL query with multiple joins
By: ramya.pathak on Wed, 12 December 2007
8 3426 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 2376 Wed, 12 December 2007 23:17
By: Mohammad Taj
  DBLink performance issues
By: raj_mat2007 on Mon, 10 December 2007
6 24711 Wed, 12 December 2007 20:04
By: trantuananh24hg
  Need to improve query performance
By: vijay_82 on Wed, 12 December 2007
1 1592 Wed, 12 December 2007 14:35
By: BlackSwan
  IO Performance Problems
By: Bob.Smith on Sun, 09 December 2007
4 2397 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 5930 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 2342 Mon, 10 December 2007 05:47
By: rdoggart
  Use of RBO in 10g
By: kingo on Mon, 10 December 2007
7 2374 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 2630 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 1913 Sat, 08 December 2007 09:03
By: michael_bialik
  disadvantages of optimization
By: anamika_025 on Thu, 06 December 2007
7 4740 Fri, 07 December 2007 13:36
By: BlackSwan
  the query is too slow
By: daria on Wed, 05 December 2007
19 4228 Fri, 07 December 2007 00:24
By: daria
  Query with aggregate function not using index
By: ndahafa on Thu, 06 December 2007
7 3187 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 1806 Wed, 05 December 2007 20:52
By: rleishman
  Can you explain to me?
By: trantuananh24hg on Wed, 05 December 2007
0 9627 Wed, 05 December 2007 20:30
By: trantuananh24hg
  error in stat pack
By: pratik123 on Wed, 05 December 2007
6 12087 Wed, 05 December 2007 02:18
By: pratik123
  Faceing Database Performance Related Problem
window server 2003
By: jainarayan5484 on Wed, 05 December 2007
2 1619 Wed, 05 December 2007 00:35
By: BlackSwan
  DBMS_STATS Problem
By: babuknb on Tue, 04 December 2007
4 7489 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 2708 Tue, 04 December 2007 03:56
By: spmano1983
  Performance Degrads
By: subbu_tce on Mon, 03 December 2007
13 3366 Tue, 04 December 2007 01:31
By: pablolee
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2459 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 1489 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: Sat Feb 08 16:46:02 CST 2025