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

    Replies Views Last message
  Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Oracle 11.2.0.2.0
By: vishnu_ora on Tue, 20 March 2012
2 2710 Tue, 20 March 2012 08:56
By: Michel Cadot
  How to find Local and global indexes on Particular Table
Oracle 10g Release 2
By: msol25 on Mon, 19 March 2012
2 2871 Mon, 19 March 2012 03:12
By: msol25
  Reading AWR
By: ninan on Tue, 13 March 2012
20 11938 Thu, 15 March 2012 07:33
By: Michel Cadot
  Wait/Sleep command in SQL
Oracle 11G
By: santoshwithu@gmail.com on Thu, 15 March 2012
1 2073 Thu, 15 March 2012 03:56
By: Littlefoot
  join condition in index
ora 11.2.0.2
By: orarule on Wed, 14 March 2012
19 7154 Thu, 15 March 2012 03:38
By: rleishman
  Need to know Sql ID and text
HP-UX,Oracle 10g
By: pokhraj_d on Wed, 22 February 2012
4 4055 Wed, 14 March 2012 06:18
By: orarule
  Oracle sequence performance
Oracle 10.2.0.4.0, sun solaris
By: a_oracle on Tue, 28 February 2012
20 6078 Wed, 14 March 2012 06:03
By: cookiemonster
  Sql statement taking very time
Oracle E-Business Suite R12
By: Osafa on Fri, 09 March 2012
16 5367 Mon, 12 March 2012 05:47
By: Osafa
  Disk i/o
Oracle 11.2.0.2, AIX
By: lg123 on Sun, 11 March 2012
1 2087 Sun, 11 March 2012 12:08
By: Michel Cadot
  how oracle organises records in partitions
11gr2
By: gogol_1987 on Fri, 09 March 2012
5 2797 Fri, 09 March 2012 04:57
By: gogol_1987
  Disk reads
By: gkrishn on Fri, 02 March 2012
10 5010 Fri, 09 March 2012 02:39
By: gkrishn
  undo tbalespace full, which is rectified but now having big WAIT
ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes
By: janakors on Wed, 07 March 2012
8 2999 Thu, 08 March 2012 12:37
By: janakors
  Slow Query
Oracle 10 g
By: RAM_PIPL on Wed, 29 February 2012
3 2319 Thu, 01 March 2012 02:09
By: Roachcoach
  Explain plan got changed suddenly
Oracle , 10.2.0.4
By: sathik on Thu, 23 February 2012
3 4361 Fri, 24 February 2012 17:00
By: LNossov
icon5.gif Issue with bulk collect over a db link
oracle,10.2.0.3,HP-UX
By: vishith13 on Thu, 23 February 2012
4 3700 Fri, 24 February 2012 06:03
By: vishith
  Function Based Index is not being used
Oracle 10.2.0.4
By: orapratap on Wed, 22 February 2012
7 3241 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 3827 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 19363 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 2737 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 2813 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 4056 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 4069 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 3616 Fri, 10 February 2012 19:42
By: rleishman
  Query Rewrite
Oracle 10g, windows
By: oraranjangmailcom on Tue, 07 February 2012
13 3863 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 3834 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 4873 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 3038 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 4757 Mon, 30 January 2012 05:27
By: LNossov
  Performance tuning in View
Oracle
By: bamugan81 on Mon, 30 January 2012
1 2160 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 2637 Sun, 29 January 2012 02:53
By: John Watson
  Subquery Transformation
11gR2, win-xp
By: Rahm on Fri, 27 January 2012
14 3635 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 1923 Fri, 27 January 2012 09:31
By: BlackSwan
  Tune Query or Modify Index or Partition
By: p2004 on Fri, 27 January 2012
1 2085 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 2020 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 1849 Wed, 25 January 2012 04:28
By: Michel Cadot
  Primary key - unusable
Oracle - 10g
By: sathik on Fri, 20 January 2012
10 7962 Tue, 24 January 2012 05:34
By: Michel Cadot
  Query execution path
11gR2 Linux
By: gkrishn on Sat, 21 January 2012
8 5993 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 2601 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 5130 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 2721 Fri, 20 January 2012 01:17
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: Thu Mar 28 18:56:03 CDT 2024