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 2055 Thu, 20 December 2007 20:04
By: rleishman
  Changing Query Approach
By: mrk_anand on Mon, 17 December 2007
11 3379 Thu, 20 December 2007 10:46
By: Kevin Meade
  SGA sizing
9.2.0.5
By: kudur_kv on Thu, 20 December 2007
1 1536 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 1618 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 3715 Wed, 19 December 2007 09:11
By: Michel Cadot
  SQL Query Performance
By: rdoggart on Tue, 18 December 2007
9 2226 Wed, 19 December 2007 02:15
By: rdoggart
  Query taking long time to execute
oracle 9i
By: venkatadeekshi on Thu, 13 December 2007
6 2982 Tue, 18 December 2007 23:32
By: venkatadeekshi
  Fetching Cursor Performance
By: Agus211 on Fri, 14 December 2007
14 3508 Tue, 18 December 2007 15:06
By: Kevin Meade
  ORA-03127 error?
By: trantuananh24hg on Tue, 18 December 2007
3 13653 Tue, 18 December 2007 05:24
By: Michel Cadot
  Procedure Performance
Oracle 10g
By: Mannu on Mon, 17 December 2007
6 2956 Tue, 18 December 2007 00:07
By: Mannu
  Indexing for lookup tables
By: srivaths on Sun, 16 December 2007
6 2878 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 4251 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 2677 Mon, 17 December 2007 06:03
By: hidnana
  To improve execution time of query
By: donind on Sun, 16 December 2007
2 1539 Mon, 17 December 2007 01:08
By: rleishman
  Some questions on SQL tuning
By: hidnana on Tue, 11 December 2007
11 2873 Sat, 15 December 2007 22:39
By: rleishman
  STATSPACK
By: lotusdeva on Wed, 12 December 2007
14 4575 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 2329 Fri, 14 December 2007 22:53
By: Mohammad Taj
  This query make much recursive call
By: trantuananh24hg on Thu, 13 December 2007
3 2256 Thu, 13 December 2007 21:08
By: trantuananh24hg
  Optimize large SQL query with multiple joins
By: ramya.pathak on Wed, 12 December 2007
8 3384 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 2338 Wed, 12 December 2007 23:17
By: Mohammad Taj
  DBLink performance issues
By: raj_mat2007 on Mon, 10 December 2007
6 24598 Wed, 12 December 2007 20:04
By: trantuananh24hg
  Need to improve query performance
By: vijay_82 on Wed, 12 December 2007
1 1560 Wed, 12 December 2007 14:35
By: BlackSwan
  IO Performance Problems
By: Bob.Smith on Sun, 09 December 2007
4 2351 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 5897 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 2283 Mon, 10 December 2007 05:47
By: rdoggart
  Use of RBO in 10g
By: kingo on Mon, 10 December 2007
7 2351 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 2605 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 1869 Sat, 08 December 2007 09:03
By: michael_bialik
  disadvantages of optimization
By: anamika_025 on Thu, 06 December 2007
7 4694 Fri, 07 December 2007 13:36
By: BlackSwan
  the query is too slow
By: daria on Wed, 05 December 2007
19 4184 Fri, 07 December 2007 00:24
By: daria
  Query with aggregate function not using index
By: ndahafa on Thu, 06 December 2007
7 3161 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 1785 Wed, 05 December 2007 20:52
By: rleishman
  Can you explain to me?
By: trantuananh24hg on Wed, 05 December 2007
0 9585 Wed, 05 December 2007 20:30
By: trantuananh24hg
  error in stat pack
By: pratik123 on Wed, 05 December 2007
6 12017 Wed, 05 December 2007 02:18
By: pratik123
  Faceing Database Performance Related Problem
window server 2003
By: jainarayan5484 on Wed, 05 December 2007
2 1598 Wed, 05 December 2007 00:35
By: BlackSwan
  DBMS_STATS Problem
By: babuknb on Tue, 04 December 2007
4 7448 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 2617 Tue, 04 December 2007 03:56
By: spmano1983
  Performance Degrads
By: subbu_tce on Mon, 03 December 2007
13 3339 Tue, 04 December 2007 01:31
By: pablolee
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2443 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 1466 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: Tue Nov 26 19:00:37 CST 2024