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

    Replies Views Last message
  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 1199 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 937 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 1088 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 745 Mon, 26 March 2012 04:58
By: Michel Cadot
  Query Tuning
Oracle 9i
By: ajaykumarkona on Fri, 23 March 2012
4 736 Sat, 24 March 2012 05:05
By: cookiemonster
  very slow on insert
oracle 9i
By: dahalbibek on Fri, 23 March 2012
1 1224 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 1267 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 578 Thu, 22 March 2012 07:34
By: S.Rajaram
  Ugly View Not Cooperating
By: scottwmackey on Tue, 20 March 2012
5 640 Thu, 22 March 2012 07:30
By: S.Rajaram
  TABLESPACE EXTENT
11g
By: sathish16787 on Mon, 19 March 2012
13 962 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 680 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 980 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 1224 Mon, 19 March 2012 03:12
By: msol25
  Reading AWR
By: ninan on Tue, 13 March 2012
20 4049 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 706 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 1455 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 1163 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 1649 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 980 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 801 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 1015 Fri, 09 March 2012 04:57
By: gogol_1987
  Disk reads
By: gkrishn on Fri, 02 March 2012
10 763 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 1106 Thu, 08 March 2012 12:37
By: janakors
  Slow Query
Oracle 10 g
By: RAM_PIPL on Wed, 29 February 2012
3 799 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 1065 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 1209 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 999 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 1444 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 9509 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 761 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 750 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 1080 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 1431 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 938 Fri, 10 February 2012 19:42
By: rleishman
  Query Rewrite
Oracle 10g, windows
By: oraranjangmailcom on Tue, 07 February 2012
13 801 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 1222 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 1290 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 952 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 1957 Mon, 30 January 2012 05:27
By: LNossov
  Performance tuning in View
Oracle
By: bamugan81 on Mon, 30 January 2012
1 849 Mon, 30 January 2012 04:07
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: Fri Nov 28 00:01:35 CST 2014

Total time taken to generate the page: 0.14029 seconds