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

    Replies Views Last message
  Function Based Index is not being used
Oracle 10.2.0.4
By: orapratap on Wed, 22 February 2012
7 1584 Thu, 23 February 2012 03:45
By: Roachcoach
  how to find top query running on a table
Oracle EE 10.2.0.3 Linux 64-bit
By: freak_vss on Sun, 19 February 2012
2 1991 Mon, 20 February 2012 13:16
By: LNossov
  Oracle parameters - processes, session, and transactions
Oracle 11.2.0.1
By: djmartin on Mon, 13 February 2012
7 13241 Sun, 19 February 2012 23:07
By: djmartin
  application is slow? what to check immediately
oracle 11.2.0.1 RAC of two nodes,solaris10
By: janakors on Thu, 16 February 2012
4 974 Sat, 18 February 2012 16:04
By: LNossov
  need help to understand this execution plan
oracle 10.2.0.5
By: n2fontenay on Mon, 13 February 2012
5 1054 Thu, 16 February 2012 10:51
By: S.Rajaram
  Help - dropping partitions(2 Merged)
Oracle, 10.2.0.4
By: sathik on Fri, 10 February 2012
7 1724 Thu, 16 February 2012 10:45
By: S.Rajaram
  Handling NULL values in the Database
Oracle 10.2.0.4
By: orapratap on Mon, 06 February 2012
3 2120 Fri, 10 February 2012 19:56
By: rleishman
  Options for querying on the skewed data
Oracle 10.2.0.4 on RHEL
By: orapratap on Fri, 10 February 2012
3 1315 Fri, 10 February 2012 19:42
By: rleishman
  Query Rewrite
Oracle 10g, windows
By: oraranjangmailcom on Tue, 07 February 2012
13 1376 Wed, 08 February 2012 05:14
By: cookiemonster
  comparing SQL plans between 2 DB's
Oracle 11203 Solaris 2.10
By: BeefStu on Fri, 03 February 2012
4 1736 Mon, 06 February 2012 09:05
By: BeefStu
  What info should be gathered while doing sql tuning?
Oracle 10.2.0.4, Redhat Enterprise Linux 5 64bit
By: snowball on Tue, 10 January 2012
19 1827 Sat, 04 February 2012 02:14
By: snowball
  Materialized view to improve Search queries
Oracle 10g R2 on RHEL
By: orapratap on Tue, 31 January 2012
2 1226 Wed, 01 February 2012 10:43
By: orapratap
  How to find Literal SQL statement
Oracle 10g Hp-UX
By: pokhraj_d on Mon, 30 January 2012
4 2875 Mon, 30 January 2012 05:27
By: LNossov
  Performance tuning in View
Oracle
By: bamugan81 on Mon, 30 January 2012
1 1092 Mon, 30 January 2012 04:07
By: cookiemonster
  scripts on tablespaces,Indexes and DBJobs
linux 4.0 with oracle 10g
By: faiz123 on Thu, 19 January 2012
4 1204 Sun, 29 January 2012 02:53
By: John Watson
  Subquery Transformation
11gR2, win-xp
By: Rahm on Fri, 27 January 2012
14 1274 Fri, 27 January 2012 23:53
By: Michel Cadot
  Is it possible to display alternate execution plans ?
11gR2, win-xp
By: Rahm on Fri, 27 January 2012
1 763 Fri, 27 January 2012 09:31
By: BlackSwan
  Tune Query or Modify Index or Partition
By: p2004 on Fri, 27 January 2012
1 865 Fri, 27 January 2012 02:29
By: Michel Cadot
  PLSQL and related cursors generated in v$sql
10gr2
By: nikko on Thu, 26 January 2012
1 980 Thu, 26 January 2012 03:01
By: Michel Cadot
  Can anyone help to do some tuning on ORACLE 9i?
ORACLE 9i
By: cooldude_no1 on Wed, 25 January 2012
1 846 Wed, 25 January 2012 04:28
By: Michel Cadot
  Primary key - unusable
Oracle - 10g
By: sathik on Fri, 20 January 2012
10 5105 Tue, 24 January 2012 05:34
By: Michel Cadot
  Query execution path
11gR2 Linux
By: gkrishn on Sat, 21 January 2012
8 2352 Sun, 22 January 2012 02:56
By: John Watson
  CBO Query re-write
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit, HP-UX
By: manubatham20 on Sat, 21 January 2012
2 1307 Sun, 22 January 2012 00:40
By: Michel Cadot
  Please help me tune this sql
Oracle 10g
By: manoveg on Tue, 18 January 2011
9 2861 Sat, 21 January 2012 09:18
By: Michel Cadot
  Problem Index with IN Statement (merged)
Oracle 10g Enterprise Edition Release 10.2.0.1.0, Solaris 10
By: MarkusW on Wed, 18 January 2012
12 1170 Fri, 20 January 2012 01:17
By: Michel Cadot
  Undo space
By: jack55 on Sun, 15 January 2012
3 1298 Thu, 19 January 2012 07:01
By: Michel Cadot
  Join with 30 tables
Sun, Oracle 10
By: RMSoares on Mon, 16 January 2012
15 1693 Thu, 19 January 2012 02:57
By: RMSoares
  SQl ID from peoplesoft process
Oracle 10g Hp-UX
By: pokhraj_d on Wed, 18 January 2012
5 1255 Wed, 18 January 2012 03:51
By: Michel Cadot
  finding changed sql plans
By: BeefStu on Tue, 17 January 2012
4 1692 Tue, 17 January 2012 15:09
By: LNossov
  AWR report
windows
By: sandeip on Tue, 17 January 2012
6 1917 Tue, 17 January 2012 07:07
By: Michel Cadot
  Best Practices to optimize a FAST REFRESH Materialized View?
Oracle 11g
By: tsteinmaurer on Mon, 16 January 2012
2 4386 Tue, 17 January 2012 05:53
By: rleishman
  Wait events for a query
Oracle 10.2.0.4
By: himabija on Tue, 17 January 2012
1 520 Tue, 17 January 2012 04:52
By: Michel Cadot
  Oracle10g Standard Edition on Linux machine
SGA Tuning
By: gauravsrivastava on Mon, 16 January 2012
5 1379 Mon, 16 January 2012 02:17
By: himabija
  truncate table
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Fri, 13 January 2012
4 1078 Fri, 13 January 2012 04:50
By: Michel Cadot
  Query running more time
Oracle 11g standard Version
By: sank on Mon, 09 January 2012
4 2217 Tue, 10 January 2012 14:50
By: sank
  HTML AWR Report
Red Hat Linux 5.3 and oracle 10g
By: morad_dba on Tue, 10 January 2012
9 8397 Tue, 10 January 2012 09:13
By: ramoradba
icon1.gif Explain Plan
Oracle 10g Hp-UX
By: pokhraj_d on Thu, 05 January 2012
3 1363 Thu, 05 January 2012 06:05
By: rleishman
  Query taking long time on MVs
Oracle 11g, UNIX
By: ind9 on Thu, 29 December 2011
4 1325 Wed, 04 January 2012 12:00
By: LNossov
  Same query using different execution plans, why??
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: manubatham20 on Mon, 26 December 2011
8 1619 Wed, 04 January 2012 09:15
By: LNossov
  Performance problem with table when using one column as reserved word METHOD
Oracle 10g,Windows XP
By: shajat on Thu, 29 December 2011
2 602 Fri, 30 December 2011 05:58
By: shajat
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: Wed Mar 29 23:50:47 CDT 2017

Total time taken to generate the page: 0.18076 seconds