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

    Replies Views Last message
  Oracle 11g alternates between two execution plans
11g Linux
By: viktordt on Tue, 03 April 2012
4 1641 Thu, 05 April 2012 06:25
By: LNossov
  ora - 04031
Oracle, 10.2.0.4
By: savugar on Mon, 27 February 2012
6 2960 Thu, 05 April 2012 05:59
By: LNossov
  session doing FTS not appearing in longops
Oracle 10.2.0.4
By: orapratap on Wed, 04 April 2012
6 1384 Thu, 05 April 2012 05:43
By: orapratap
  speeding up scanning of internal temporary table (of materialize hint)
Oracle 10.2.0.4
By: orapratap on Tue, 03 April 2012
7 2197 Wed, 04 April 2012 03:17
By: Roachcoach
  Parallel operations not executing with expected degree
Oracle 10.2.0.4
By: orapratap on Mon, 02 April 2012
2 1227 Mon, 02 April 2012 06:01
By: LNossov
  Distributed query running slow
Oracle9i Enterprise Edition Release 9.2.0.6.0 / Linux 2.4.21-50.ELsmp #1
By: SSharma on Tue, 27 March 2012
8 1682 Sat, 31 March 2012 03:57
By: cookiemonster
  How to decide Partiitioning columns?
Oracle 10.2.0.4
By: orapratap on Wed, 28 March 2012
21 1356 Fri, 30 March 2012 00:58
By: John Watson
  Optimiser Cost Caclulation for nested loop join
linux, oracle 10g
By: rekha.singhal@tcs.com on Tue, 27 March 2012
7 1366 Tue, 27 March 2012 06:53
By: Michel Cadot
  Understanding Execution Plan of a query
Oracle 10.2.0.4
By: orapratap on Sun, 25 March 2012
7 1004 Mon, 26 March 2012 04:58
By: Michel Cadot
  Query Tuning
Oracle 9i
By: ajaykumarkona on Fri, 23 March 2012
4 1081 Sat, 24 March 2012 05:05
By: cookiemonster
  very slow on insert
oracle 9i
By: dahalbibek on Fri, 23 March 2012
1 1521 Fri, 23 March 2012 13:49
By: Michel Cadot
  On which columns to apply index
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 05 March 2012
15 1931 Fri, 23 March 2012 05:48
By: S.Rajaram
  Order of steps in execution path and order of predicates in the Plan
Oracle 10.2.0.4
By: orapratap on Tue, 20 March 2012
3 875 Thu, 22 March 2012 07:34
By: S.Rajaram
  Ugly View Not Cooperating
By: scottwmackey on Tue, 20 March 2012
5 973 Thu, 22 March 2012 07:30
By: S.Rajaram
  TABLESPACE EXTENT
11g
By: sathish16787 on Mon, 19 March 2012
13 1198 Wed, 21 March 2012 00:22
By: Michel Cadot
  New User Help Me Out (merged 2)
Oracle 11gR2, Linux
By: shehzaadkareem on Tue, 20 March 2012
6 901 Tue, 20 March 2012 15:45
By: shehzaadkareem
  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 1295 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 1572 Mon, 19 March 2012 03:12
By: msol25
  Reading AWR
By: ninan on Tue, 13 March 2012
20 5794 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 858 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 2054 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 1428 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 2171 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 1316 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 1006 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 1274 Fri, 09 March 2012 04:57
By: gogol_1987
  Disk reads
By: gkrishn on Fri, 02 March 2012
10 1095 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 1429 Thu, 08 March 2012 12:37
By: janakors
  Slow Query
Oracle 10 g
By: RAM_PIPL on Wed, 29 February 2012
3 1028 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 1548 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 1803 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 1439 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 1864 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 12411 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 920 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 980 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 1587 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 1977 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 1235 Fri, 10 February 2012 19:42
By: rleishman
  Query Rewrite
Oracle 10g, windows
By: oraranjangmailcom on Tue, 07 February 2012
13 1205 Wed, 08 February 2012 05:14
By: cookiemonster
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: Sat Jul 30 20:45:54 CDT 2016

Total time taken to generate the page: 0.10073 seconds