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

    Replies Views Last message
  USE_HASH
Oracle 9i
By: jageesh on Mon, 08 December 2008
2 3112 Mon, 08 December 2008 06:01
By: Frank Naude
  how to tune this query?
By: Selva on Wed, 08 December 2004
3 3894 Sun, 07 December 2008 22:45
By: dmerin
  Help with SQL Optimization (merged)
By: Creems on Fri, 05 December 2008
5 3617 Fri, 05 December 2008 19:15
By: rleishman
  Production Performance Issue
Oracle 10.2.0.3 + Sun Solaris 5.9
By: babuknb on Fri, 05 December 2008
5 2312 Fri, 05 December 2008 13:56
By: babuknb
  how to improve
mysql, 5.0, XP
By: daredavil82 on Fri, 05 December 2008
3 1824 Fri, 05 December 2008 02:20
By: Michel Cadot
  Reg Reorg activity
oracle 9206
By: anand47 on Fri, 05 December 2008
3 3359 Fri, 05 December 2008 02:18
By: Michel Cadot
  whats syntax to keep table in memory?
AIX 10G
By: lioracle on Thu, 04 December 2008
7 3357 Thu, 04 December 2008 23:18
By: Michel Cadot
  LOCKWAIT
10g AIX
By: lioracle on Tue, 02 December 2008
10 4038 Thu, 04 December 2008 12:26
By: Michel Cadot
  how to find the query optimized or Not?
9i
By: user71408 on Thu, 04 December 2008
10 3108 Thu, 04 December 2008 06:06
By: user71408
  Createing index
Oracle 10g
By: Olivia on Fri, 28 November 2008
9 3124 Thu, 04 December 2008 05:30
By: rleishman
  how to find list of sql statements ran in the past time.
oracle 10.2.0.3
By: kumar.joy on Mon, 01 December 2008
1 2418 Mon, 01 December 2008 13:16
By: Michel Cadot
  ORACLE V$SQL issue ....
By: user71408 on Mon, 01 December 2008
1 2343 Mon, 01 December 2008 08:15
By: JRowbottom
  Clob column on remote database
Oracle 9i
By: Hidden on Thu, 27 November 2008
2 2721 Fri, 28 November 2008 04:57
By: Hidden
  'is Null' versus '='
10g
By: beetel on Thu, 27 November 2008
3 2538 Thu, 27 November 2008 20:27
By: rleishman
  Creating SQL tuning set and how it will help
Oracle 10g
By: Olivia on Thu, 27 November 2008
2 2697 Thu, 27 November 2008 04:15
By: Olivia
  Contention
oracle 9i on AIX
By: dbcop on Fri, 21 November 2008
9 6232 Wed, 26 November 2008 22:38
By: dbcop
  Index on Partition Table (merged)
By: chintan.patel on Tue, 25 November 2008
6 4890 Wed, 26 November 2008 20:09
By: rleishman
  dbms_stats.gather_table_stats
oracle 10g
By: pdhayan@qwest.com on Wed, 26 November 2008
2 5486 Wed, 26 November 2008 12:50
By: Mahesh Rajendran
  procedure running with no end
By: srini_thiru on Tue, 25 November 2008
3 2489 Wed, 26 November 2008 01:28
By: coleing
  Performance tuing using FIRST_ROWS
Oracle 9.2.0.1.0
By: unmeshmohanan on Mon, 17 November 2008
4 3196 Tue, 25 November 2008 23:19
By: unmeshmohanan
  SQL Tuning Advisor Feature
Oracle 10g
By: Olivia on Tue, 25 November 2008
2 2419 Tue, 25 November 2008 11:38
By: Olivia
  How to avoid union?
Oracle 10g,Windows 2003
By: newToPlsql on Mon, 24 November 2008
2 5183 Tue, 25 November 2008 01:49
By: coleing
  Template to capture Details about successful Oracle Performance Improvement
Oracle 10.2.0.4 on Sun Solaris
By: gkodakalla on Mon, 24 November 2008
1 2532 Mon, 24 November 2008 09:22
By: Mahesh Rajendran
  High I/O disk writes
Oracle 10.2g
By: Georgette on Tue, 18 November 2008
3 2214 Mon, 24 November 2008 09:14
By: JRowbottom
  Index
Oracle 10g
By: ora_2007 on Mon, 24 November 2008
2 2490 Mon, 24 November 2008 06:23
By: ora_2007
  Table size and sql performance
By: djeevan on Sun, 23 November 2008
2 2566 Sun, 23 November 2008 19:34
By: rleishman
  INIT.ORA parameters to SCALE UP INSTANCE
10.2.0.3 ON LINUX
By: andydba on Wed, 19 November 2008
7 4864 Sun, 23 November 2008 17:03
By: andydba
  How to make use of indexes?
Oracle 10g,10.2.0.1.0,Windows 2003
By: newToPlsql on Fri, 21 November 2008
7 2739 Sat, 22 November 2008 01:06
By: rleishman
  performance problems when using ...like string||'%';
oracle 11g
By: jsulc on Thu, 20 November 2008
6 2523 Fri, 21 November 2008 11:09
By: jsulc
  The difference between sql_text in v$sqlarea and v$sqltext
Oracle 9i, 9.2.0.2, Linux
By: efachim on Tue, 18 November 2008
3 5064 Fri, 21 November 2008 10:59
By: efachim
  Is this a 10g bug?
Oracle 10g, 10.2.0.2, Linux
By: efachim on Tue, 18 November 2008
9 4141 Fri, 21 November 2008 10:52
By: efachim
  Understand how optimizer works
Oracle 9i, AIX
By: psoftneto on Mon, 17 November 2008
7 3634 Fri, 21 November 2008 10:04
By: JRowbottom
  Oracle Tuning - Explain plan
Oracle 9i, AIX
By: psoftneto on Thu, 20 November 2008
5 5184 Fri, 21 November 2008 10:01
By: JRowbottom
  Synonyms and dblinks
Oracle 9i
By: Srinandini on Thu, 20 November 2008
4 3524 Fri, 21 November 2008 08:21
By: Srinandini
  ORA-12013: updatable materialized views must be simple enough to do fast refresh
Oracle 10g
By: amorphous4u on Mon, 17 November 2008
2 5483 Thu, 20 November 2008 22:31
By: Kevin Meade
icon5.gif Query optimization
Oracle 10G
By: habibsh785 on Mon, 17 November 2008
2 2358 Thu, 20 November 2008 22:26
By: Kevin Meade
  Generic data models - academic questions
By: nmcsw98 on Tue, 18 November 2008
3 3891 Thu, 20 November 2008 21:56
By: Kevin Meade
  Tuning a small query
Oracle 10g
By: magesh_magi1 on Thu, 20 November 2008
6 2425 Thu, 20 November 2008 05:02
By: magesh_magi1
  Querry performance
By: sreenu80 on Wed, 19 November 2008
5 3218 Wed, 19 November 2008 22:58
By: Michel Cadot
icon8.gif parallel hint
10g
By: maheshmhs on Wed, 19 November 2008
1 2062 Wed, 19 November 2008 03:41
By: tahpush
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 Nov 22 14:04:59 CST 2024