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

    Replies Views Last message
  DB performance problem or "bad" SQL query
Oracle 10g
By: rc3d on Thu, 24 October 2013
30 2542 Wed, 30 October 2013 12:25
By: Michel Cadot
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Tue, 11 December 2012
27 1912 Wed, 30 October 2013 08:49
By: pablolee
  XML/XPath rewrites and plan baselines
11.2.0.4 RHEL
By: Roachcoach on Tue, 29 October 2013
6 820 Wed, 30 October 2013 04:12
By: Roachcoach
  standard SQL query to benchmark Oracle DB response time (performance)
Oracle 10g
By: rc3d on Sat, 26 October 2013
1 646 Sat, 26 October 2013 06:17
By: Michel Cadot
  How To Increase Data Reterival / Insertion Speed
Oacle 8i and Forms 6i
By: qanita786 on Thu, 24 October 2013
2 964 Thu, 24 October 2013 04:47
By: Michel Cadot
  db file parallel read
11.2.0.3.0
By: rishwinger on Fri, 11 October 2013
4 2265 Mon, 21 October 2013 03:38
By: michael_bialik
  Digging out the Wait events.
By: VIP2013 on Tue, 15 October 2013
14 2726 Mon, 21 October 2013 03:14
By: VIP2013
  Need your help in tuning the query
11.5.10.2
By: nishantranjan87 on Wed, 16 October 2013
28 2149 Fri, 18 October 2013 05:21
By: Lalit Kumar B
  Help with 12c vs 10.2g
12c
By: hesaigo999ca on Tue, 15 October 2013
19 2337 Thu, 17 October 2013 10:39
By: cookiemonster
  Insert data fast on table
Oracle 11.2 RAC
By: nehaverma on Tue, 15 October 2013
14 1045 Tue, 15 October 2013 08:59
By: Lalit Kumar B
  database links question
oracle 11g
By: manoj12 on Mon, 14 October 2013
6 1015 Mon, 14 October 2013 11:42
By: BlackSwan
  Force the optimizer to consider all join permutations
11.2.0.4 RHEL
By: Roachcoach on Mon, 14 October 2013
5 653 Mon, 14 October 2013 09:45
By: Roachcoach
  Please help me to tune this procedure
Oracle 11g
By: ajaykumarkona on Fri, 11 October 2013
25 2001 Mon, 14 October 2013 06:48
By: pablolee
  performance - index creation on text column
Oracle 10g,Solaris
By: prejib on Thu, 10 October 2013
9 986 Fri, 11 October 2013 00:46
By: prejib
  about increasing performance speed of slow running package
Oracle 11.2.0.2.0, Oracle Enterprise Linux -5
By: 8939513598$ on Fri, 04 October 2013
7 932 Mon, 07 October 2013 02:19
By: 8939513598$
  MEMORY_TARGET error
Oracle 11.2.0.1.0, Oracle Enterprise Linux -5
By: 8939513598$ on Fri, 04 October 2013
2 620 Fri, 04 October 2013 11:02
By: Michel Cadot
  How to configure SGA_MAX_SIZE parameter
Oracle Enterprise 11.2.0.3, RH Enterprise Linux 5
By: rcct on Tue, 24 September 2013
7 1555 Fri, 04 October 2013 11:01
By: Michel Cadot
  Please advise on configuring memory
Oracle 11.1, Windows Server 2008 R2
By: jxh461 on Wed, 18 September 2013
23 1911 Fri, 04 October 2013 02:24
By: Michel Cadot
  Need help to tune this query
Oracle 11g
By: ramya_162 on Wed, 28 August 2013
10 1304 Fri, 04 October 2013 01:50
By: 8939513598$
  Buffer Busy Wait DBMS_ALERT_INFO
Oracle DB 11.2.0.3, Standard 64-bit, Windows 2008 R2
By: Flyby on Wed, 02 October 2013
7 1163 Thu, 03 October 2013 04:19
By: 8939513598$
  Big table joining
Oracle 10g
By: sss111ind on Tue, 01 October 2013
4 696 Tue, 01 October 2013 10:19
By: BlackSwan
  Question for List partition
By: dba10 on Mon, 30 September 2013
2 476 Mon, 30 September 2013 17:36
By: Lalit Kumar B
  ISSUE IN THE PERFORMANCE
ORACLE 10G
By: db_learner on Fri, 27 September 2013
5 896 Sun, 29 September 2013 09:14
By: BlackSwan
  pagging
oracle 11.2.0.3 sun solaris 10.5
By: guddu_12 on Thu, 26 September 2013
3 548 Thu, 26 September 2013 16:28
By: rleishman
  Split Data separated by comma ; then create a collection with data mapped from other columns
By: abhenav123 on Wed, 25 September 2013
4 812 Wed, 25 September 2013 07:45
By: abhenav123
  Select query taking time even after using PARALLEL hint
Oracle 11.2.0.3,Linux x86-64
By: arunshrish on Wed, 25 September 2013
2 609 Wed, 25 September 2013 04:24
By: arunshrish
  Please help me to tune this query
By: ramya_162 on Tue, 24 September 2013
2 847 Tue, 24 September 2013 13:29
By: John Watson
  Howto avoid virtual circuit wait as application developer?
11gR2 (11.2.0.3)
By: bet32978 on Wed, 07 August 2013
4 6709 Thu, 19 September 2013 08:28
By: bet32978
  snapshot skipped in between the scheduled time (AWR)
11g, 11.2.0.1, window server 2008
By: ishika_20 on Wed, 11 September 2013
7 2849 Sat, 14 September 2013 10:48
By: trantuananh24hg
  Need your help in tuning the query
11i
By: nishant87 on Thu, 12 September 2013
22 1849 Fri, 13 September 2013 00:00
By: Kevin Meade
  Call from specified Machine not assigned to Database resource consumer.
Release 11.2.0.3.0 - 64bit
By: VIP2013 on Fri, 06 September 2013
9 1541 Sun, 08 September 2013 00:45
By: VIP2013
  Database crash Due To CPU Starvation
11.2.0.3 Version Oracle.
By: VIP2013 on Sun, 01 September 2013
9 1320 Wed, 04 September 2013 14:04
By: VIP2013
  Parallel hints with cursor queries
Oracle 11.2.0.2.0, Windows XP
By: a_oracle on Wed, 28 August 2013
13 2116 Sun, 01 September 2013 13:56
By: Lalit Kumar B
  Performance issue with a query using DB links
am on Oracle 11.2.0.3 on Solaris 10 on one database and oracle 10.2.0.4 on Solaris 10 on another database
By: orausern on Wed, 28 August 2013
18 1565 Fri, 30 August 2013 13:06
By: orausern
  Please help on this
Oracle 11g
By: ajaykumarkona on Tue, 06 August 2013
4 954 Fri, 30 August 2013 02:54
By: pablolee
  Impact of RAM to oracle
11gR2 on HP-UX IA64
By: yipchunyu on Tue, 27 August 2013
11 1198 Thu, 29 August 2013 10:06
By: yipchunyu
  NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention")
database enterprize edition 11.2.0.3 solaris 10
By: mshrkshl on Thu, 29 August 2013
2 1321 Thu, 29 August 2013 04:38
By: mshrkshl
  Please guide to improve the performance of query
Oracle 11g
By: ajaykumarkona on Mon, 26 August 2013
8 1230 Tue, 27 August 2013 03:56
By: pablolee
  Moving Tables to Encrypted Tablespace.
11.2.0.3.0 version of oracle.
By: VIP2013 on Sun, 25 August 2013
2 770 Tue, 27 August 2013 03:20
By: VIP2013
  dynamic sql choosing wrong index
oracle 11g / aix
By: 4wheels on Fri, 16 August 2013
3 901 Thu, 22 August 2013 08:31
By: Kevin Meade
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 May 22 11:46:12 CDT 2015

Total time taken to generate the page: 0.13260 seconds