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

    Replies Views Last message
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 530 Tue, 13 May 2014 21:40
By: BlackSwan
  Please help me execution plan is looking bad
Oracle 11g
By: ramya_162 on Mon, 12 May 2014
23 1371 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 1293 Sat, 10 May 2014 10:21
By: Kevin Meade
  High CPU Consuming Query
Oracle,11.2.0.3, AIX
By: nmoham on Wed, 07 May 2014
12 762 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 448 Wed, 07 May 2014 10:38
By: BlackSwan
  Full table scan - Queries
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Mon, 05 May 2014
6 706 Tue, 06 May 2014 04:03
By: Lalit Kumar B
  After updating memory_target, performance is degraded
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Mon, 28 April 2014
7 680 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  performance Tuning
Oracle 10g
By: ramchandru1989 on Tue, 22 April 2014
5 625 Tue, 29 April 2014 19:20
By: Kevin Meade
  ODI Performance issue with flat file
ODI 11g
By: giridhar123 on Fri, 25 April 2014
1 466 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 498 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 626 Thu, 24 April 2014 02:40
By: cookiemonster
  Scripts to find Indexes which are candidate for Rebuild
Oracle 11.2.0.3, Linux x86 64-bit
By: hitesh.bhatt on Tue, 22 April 2014
9 915 Wed, 23 April 2014 08:17
By: BlackSwan
  Please help me for getting best execution plan as my create view script is taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 25 March 2014
5 561 Tue, 22 April 2014 09:52
By: BlackSwan
  Archive log issues
By: patdev on Thu, 17 April 2014
1 339 Thu, 17 April 2014 12:48
By: BlackSwan
  Would making indexes "invisible" be the right approach for this?
11.2.0.3 / CentOS Linux
By: ThomasG on Wed, 26 March 2014
4 719 Thu, 17 April 2014 04:30
By: Lalit Kumar B
  query optimization phase
Oracle DB 11.2.0
By: Johnny_aig on Tue, 15 April 2014
8 793 Wed, 16 April 2014 08:49
By: Lalit Kumar B
  Can I instruct Oracle 11g to deliberately delay query completion?
Oracle 11g
By: jvanh on Fri, 11 April 2014
3 461 Tue, 15 April 2014 04:55
By: jvanh
icon3.gif Its confusing me lot....
11g, AIX
By: harpreetsinghkup on Fri, 11 April 2014
5 561 Mon, 14 April 2014 02:29
By: Roachcoach
  enq: TM - contention
11.2.0.3
By: rishwinger on Wed, 09 April 2014
15 2801 Wed, 09 April 2014 05:53
By: Michel Cadot
  DATA BASE IS WORKING VERY SLOW
ORACLE 9I
By: arvindnegi2007 on Wed, 09 April 2014
1 427 Wed, 09 April 2014 02:29
By: Michel Cadot
  COUNT STOPKEY issue -- performance issue
oracle 11gr2/unix
By: balaji123 on Mon, 07 April 2014
2 692 Tue, 08 April 2014 19:51
By: rleishman
  5M record insert takes two hours
11gR2
By: That Don Guy on Wed, 02 April 2014
4 884 Mon, 07 April 2014 10:54
By: d_seng
  Materialized View not being used on production (works elsewhere)
Oracle 11.2.0.2 Enterprise 64 bit
By: d_seng on Wed, 26 February 2014
9 1275 Mon, 07 April 2014 10:32
By: d_seng
  SQL performance
Oracle 11i
By: huda_10@yahoo.co.in on Sun, 30 March 2014
13 1954 Thu, 03 April 2014 05:32
By: michael_bialik
  elapsed_time_delta in dba_hist_sqlstat
By: VIP2013 on Wed, 26 March 2014
1 741 Thu, 27 March 2014 10:07
By: VIP2013
  Best Design for batch processing using BLOB Types
By: luxofmcc on Tue, 25 March 2014
1 394 Tue, 25 March 2014 14:43
By: BlackSwan
  sql result cache for improving the performance (merged 4)
11g
By: kiranrathodkr916 on Sat, 22 March 2014
21 1871 Tue, 25 March 2014 05:15
By: ashwanth77
  Use of Hints in Oracle 11g to get desired Execution Plan
Oracle 11g 2.0, Linux
By: rekha.singhal@tcs.com on Thu, 20 March 2014
9 1045 Mon, 24 March 2014 00:29
By: Kevin Meade
  statement with big cost
Oracle Database 11.2.0.2.0
By: Roger22 on Fri, 21 March 2014
9 674 Fri, 21 March 2014 09:18
By: cookiemonster
  session uga memory
By: ashu205 on Tue, 18 March 2014
1 499 Wed, 19 March 2014 18:42
By: BlackSwan
  What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def
general
By: Kevin Meade on Tue, 18 March 2014
4 851 Tue, 18 March 2014 06:09
By: Kevin Meade
  SQL Execution Runtime Measure
Oracle 11g Rel 2
By: ind9 on Fri, 14 March 2014
3 856 Sat, 15 March 2014 05:45
By: John Watson
  What is the most expensive dml transaction, insert, update, delete?
Oracle
By: steves on Sun, 24 March 2013
12 1911 Fri, 14 March 2014 17:49
By: youngryand
  Sql Tuning Advisor - Privileges (sqltrpt.sql)
Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit
By: hitesh.bhatt on Thu, 13 March 2014
2 1339 Thu, 13 March 2014 22:49
By: hitesh.bhatt
  Incorrect cardinalty estimate when using a local non-prefixed unique index
DB 12.1.0.1
By: John Watson on Fri, 07 March 2014
7 879 Thu, 13 March 2014 20:04
By: rleishman
  SQL Repair
Oracle 11g , Unix
By: younusc on Mon, 10 March 2014
3 734 Thu, 13 March 2014 00:02
By: Markwillium
  database performance tuning
By: likhonisrat on Tue, 11 March 2014
1 458 Tue, 11 March 2014 06:42
By: John Watson
  Query is taking long time
11i
By: Vivek_Garg on Sun, 09 March 2014
16 1191 Mon, 10 March 2014 04:49
By: John Watson
  How to find throughput by query, session and database wise?
Oracle 11.2.0.3, Redhat Linux 5.
By: suresh.wst on Sun, 02 March 2014
9 1428 Fri, 07 March 2014 01:41
By: suresh.wst
icon5.gif Difference in elapsed time of the query where everything in the trace seems to be identical
Oracle 11g, Windows 7
By: Vivek_Garg on Thu, 06 March 2014
1 334 Thu, 06 March 2014 07:09
By: John Watson
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 Nov 27 03:56:52 CST 2014

Total time taken to generate the page: 0.07201 seconds