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 1289 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 1437 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 3224 Wed, 19 December 2007 09:11
By: Michel Cadot
  SQL Query Performance
By: rdoggart on Tue, 18 December 2007
9 1910 Wed, 19 December 2007 02:15
By: rdoggart
  Query taking long time to execute
oracle 9i
By: venkatadeekshi on Thu, 13 December 2007
6 2664 Tue, 18 December 2007 23:32
By: venkatadeekshi
  Fetching Cursor Performance
By: Agus211 on Fri, 14 December 2007
14 2975 Tue, 18 December 2007 15:06
By: Kevin Meade
  ORA-03127 error?
By: trantuananh24hg on Tue, 18 December 2007
3 13025 Tue, 18 December 2007 05:24
By: Michel Cadot
  Procedure Performance
Oracle 10g
By: Mannu on Mon, 17 December 2007
6 1815 Tue, 18 December 2007 00:07
By: Mannu
  Indexing for lookup tables
By: srivaths on Sun, 16 December 2007
6 2468 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 3920 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 2399 Mon, 17 December 2007 06:03
By: hidnana
  To improve execution time of query
By: donind on Sun, 16 December 2007
2 1293 Mon, 17 December 2007 01:08
By: rleishman
  Some questions on SQL tuning
By: hidnana on Tue, 11 December 2007
11 2436 Sat, 15 December 2007 22:39
By: rleishman
  STATSPACK
By: lotusdeva on Wed, 12 December 2007
14 4140 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 1747 Fri, 14 December 2007 22:53
By: Mohammad Taj
  This query make much recursive call
By: trantuananh24hg on Thu, 13 December 2007
3 2008 Thu, 13 December 2007 21:08
By: trantuananh24hg
  Optimize large SQL query with multiple joins
By: ramya.pathak on Wed, 12 December 2007
8 2948 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 2127 Wed, 12 December 2007 23:17
By: Mohammad Taj
  DBLink performance issues
By: raj_mat2007 on Mon, 10 December 2007
6 24210 Wed, 12 December 2007 20:04
By: trantuananh24hg
  Need to improve query performance
By: vijay_82 on Wed, 12 December 2007
1 1276 Wed, 12 December 2007 14:35
By: BlackSwan
  IO Performance Problems
By: Bob.Smith on Sun, 09 December 2007
4 1959 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 5461 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 1970 Mon, 10 December 2007 05:47
By: rdoggart
  Use of RBO in 10g
By: kingo on Mon, 10 December 2007
7 1902 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 2342 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 1632 Sat, 08 December 2007 09:03
By: michael_bialik
  disadvantages of optimization
By: anamika_025 on Thu, 06 December 2007
7 4286 Fri, 07 December 2007 13:36
By: BlackSwan
  the query is too slow
By: daria on Wed, 05 December 2007
19 3621 Fri, 07 December 2007 00:24
By: daria
  Query with aggregate function not using index
By: ndahafa on Thu, 06 December 2007
7 2860 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 1337 Wed, 05 December 2007 20:52
By: rleishman
  Can you explain to me?
By: trantuananh24hg on Wed, 05 December 2007
0 9330 Wed, 05 December 2007 20:30
By: trantuananh24hg
  error in stat pack
By: pratik123 on Wed, 05 December 2007
6 11220 Wed, 05 December 2007 02:18
By: pratik123
  Faceing Database Performance Related Problem
window server 2003
By: jainarayan5484 on Wed, 05 December 2007
2 1335 Wed, 05 December 2007 00:35
By: BlackSwan
  DBMS_STATS Problem
By: babuknb on Tue, 04 December 2007
4 7175 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 2264 Tue, 04 December 2007 03:56
By: spmano1983
  Performance Degrads
By: subbu_tce on Mon, 03 December 2007
13 2947 Tue, 04 December 2007 01:31
By: pablolee
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2222 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 1290 Sun, 02 December 2007 19:59
By: rleishman
  Question about joins
By: SRIVASUWIN on Thu, 29 November 2007
3 1717 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 1666 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: Sun Jun 30 21:30:40 CDT 2024