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

    Replies Views Last message
  Help with SQL Optimization (merged)
By: Creems on Fri, 05 December 2008
5 3158 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 1921 Fri, 05 December 2008 13:56
By: babuknb
  how to improve
mysql, 5.0, XP
By: daredavil82 on Fri, 05 December 2008
3 1505 Fri, 05 December 2008 02:20
By: Michel Cadot
  Reg Reorg activity
oracle 9206
By: anand47 on Fri, 05 December 2008
3 2453 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 2953 Thu, 04 December 2008 23:18
By: Michel Cadot
  LOCKWAIT
10g AIX
By: lioracle on Tue, 02 December 2008
10 3613 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 2715 Thu, 04 December 2008 06:06
By: user71408
  Createing index
Oracle 10g
By: Olivia on Fri, 28 November 2008
9 2694 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 1908 Mon, 01 December 2008 13:16
By: Michel Cadot
  ORACLE V$SQL issue ....
By: user71408 on Mon, 01 December 2008
1 1830 Mon, 01 December 2008 08:15
By: JRowbottom
  Clob column on remote database
Oracle 9i
By: Hidden on Thu, 27 November 2008
2 2470 Fri, 28 November 2008 04:57
By: Hidden
  'is Null' versus '='
10g
By: beetel on Thu, 27 November 2008
3 1989 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 2159 Thu, 27 November 2008 04:15
By: Olivia
  Contention
oracle 9i on AIX
By: dbcop on Fri, 21 November 2008
9 4615 Wed, 26 November 2008 22:38
By: dbcop
  Index on Partition Table (merged)
By: chintan.patel on Tue, 25 November 2008
6 3949 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 4911 Wed, 26 November 2008 12:50
By: Mahesh Rajendran
  procedure running with no end
By: srini_thiru on Tue, 25 November 2008
3 1548 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 2976 Tue, 25 November 2008 23:19
By: unmeshmohanan
  SQL Tuning Advisor Feature
Oracle 10g
By: Olivia on Tue, 25 November 2008
2 1707 Tue, 25 November 2008 11:38
By: Olivia
  How to avoid union?
Oracle 10g,Windows 2003
By: newToPlsql on Mon, 24 November 2008
2 4864 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 2105 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 1567 Mon, 24 November 2008 09:14
By: JRowbottom
  Index
Oracle 10g
By: ora_2007 on Mon, 24 November 2008
2 1693 Mon, 24 November 2008 06:23
By: ora_2007
  Table size and sql performance
By: djeevan on Sun, 23 November 2008
2 1999 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 3621 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 2448 Sat, 22 November 2008 01:06
By: rleishman
  performance problems when using ...like string||'%';
oracle 11g
By: jsulc on Thu, 20 November 2008
6 2253 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 4707 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 3807 Fri, 21 November 2008 10:52
By: efachim
  Understand how optimizer works
Oracle 9i, AIX
By: psoftneto on Mon, 17 November 2008
7 2463 Fri, 21 November 2008 10:04
By: JRowbottom
  Oracle Tuning - Explain plan
Oracle 9i, AIX
By: psoftneto on Thu, 20 November 2008
5 3917 Fri, 21 November 2008 10:01
By: JRowbottom
  Synonyms and dblinks
Oracle 9i
By: Srinandini on Thu, 20 November 2008
4 2335 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 5145 Thu, 20 November 2008 22:31
By: Kevin Meade
icon5.gif Query optimization
Oracle 10G
By: habibsh785 on Mon, 17 November 2008
2 1998 Thu, 20 November 2008 22:26
By: Kevin Meade
  Generic data models - academic questions
By: nmcsw98 on Tue, 18 November 2008
3 3110 Thu, 20 November 2008 21:56
By: Kevin Meade
  Tuning a small query
Oracle 10g
By: magesh_magi1 on Thu, 20 November 2008
6 2001 Thu, 20 November 2008 05:02
By: magesh_magi1
  Querry performance
By: sreenu80 on Wed, 19 November 2008
5 2173 Wed, 19 November 2008 22:58
By: Michel Cadot
icon8.gif parallel hint
10g
By: maheshmhs on Wed, 19 November 2008
1 1549 Wed, 19 November 2008 03:41
By: tahpush
  Materialized View Refresh Performance
Oracle 10g
By: amorphous4u on Mon, 17 November 2008
2 3384 Tue, 18 November 2008 13:30
By: coleing
  jobsq slave
10g ,linux
By: vinniora on Mon, 17 November 2008
1 1410 Tue, 18 November 2008 01:07
By: Michel Cadot
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 02 10:04:43 CDT 2024