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

    Replies Views Last message
  Performance degrade
Oracle 11gr2 , linux AS5
By: oradba123 on Sat, 23 November 2013
3 436 Tue, 26 November 2013 08:08
By: Kevin Meade
  fast query
By: narang79 on Mon, 25 November 2013
6 498 Tue, 26 November 2013 08:00
By: Kevin Meade
  Please help me my query performance is bad.
Oracle 11g
By: ramya_162 on Wed, 20 November 2013
24 1240 Mon, 25 November 2013 06:18
By: ramya_162
  SQL & PL/SQL
By: varshbugad on Mon, 25 November 2013
1 289 Mon, 25 November 2013 02:04
By: pablolee
  Locking In application code.
By: VIP2013 on Mon, 18 November 2013
6 534 Fri, 22 November 2013 17:04
By: EdStevens
  SELECT works, INSERT+ SELECT hangs in SQLDeveloper Tools
Oracle, 11.2, SQLDeveloper
By: royalyogi on Tue, 19 November 2013
15 857 Thu, 21 November 2013 02:38
By: cookiemonster
  Need advice on index to apply
Oracle 11.2, Window 2008
By: jxh461 on Tue, 19 November 2013
10 591 Wed, 20 November 2013 16:23
By: Kevin Meade
  Oracle DB Performance Tests
Oracle 11g
By: ind9 on Tue, 05 November 2013
6 1194 Wed, 13 November 2013 17:51
By: alan.kendall@nfl.com
  Please help me how to improve the performance of this query further.
Oracle 11g
By: ramya_162 on Thu, 07 November 2013
33 1971 Tue, 12 November 2013 11:15
By: cookiemonster
  forms 6i too slow when database have approximately 1 million records
Oracle 8i
By: qanita786 on Sat, 09 November 2013
4 558 Mon, 11 November 2013 05:58
By: Littlefoot
  Adaptive Cursor Sharing VS SPM
By: VIP2013 on Tue, 05 November 2013
3 509 Sat, 09 November 2013 13:45
By: VIP2013
  Which SQL is faster/better
Oracle
By: mokarem on Mon, 04 November 2013
11 1284 Wed, 06 November 2013 03:32
By: cookiemonster
  Performance issue in one sql
11i
By: nishantranjan87 on Fri, 18 October 2013
4 720 Tue, 05 November 2013 23:35
By: Kevin Meade
  Understanding ASH
Oracle 10g,10.2.0.4.0, windows server 2008
By: zahidbutt on Tue, 05 November 2013
1 360 Tue, 05 November 2013 01:47
By: Lalit Kumar B
  Tiff Images and Oracle
Oracle 10, 11 and 12
By: Diego Pafumi on Thu, 31 October 2013
6 985 Fri, 01 November 2013 11:22
By: gazzag
  DB performance problem or "bad" SQL query
Oracle 10g
By: rc3d on Thu, 24 October 2013
30 1889 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 1615 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 589 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 474 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 792 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 971 Mon, 21 October 2013 03:38
By: michael_bialik
  Digging out the Wait events.
By: VIP2013 on Tue, 15 October 2013
14 1564 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 1691 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 1743 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 774 Tue, 15 October 2013 08:59
By: Lalit Kumar B
  database links question
oracle 11g
By: manoj12 on Mon, 14 October 2013
6 825 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 441 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 1624 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 754 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 765 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 422 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 1146 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 1567 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 1091 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 772 Thu, 03 October 2013 04:19
By: 8939513598$
  Big table joining
Oracle 10g
By: sss111ind on Tue, 01 October 2013
4 525 Tue, 01 October 2013 10:19
By: BlackSwan
  Question for List partition
By: dba10 on Mon, 30 September 2013
2 371 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 688 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 377 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 600 Wed, 25 September 2013 07:45
By: abhenav123
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: Wed Jul 30 17:10:38 CDT 2014

Total time taken to generate the page: 0.14619 seconds