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

    Replies Views Last message
icon5.gif clarification of query EXPLAIN plan
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 24 March 2011
5 858 Sun, 27 March 2011 20:15
By: Tlg13team
  why db need kill session instantly
Oracle 10G2, RedHat Linux Enterprice6
By: runinwind on Tue, 22 March 2011
2 1107 Sat, 26 March 2011 00:58
By: vjeedigunta
  sql library miss rate (2 Merged)
oracle database 10.2.0.4
By: karioookey on Fri, 18 March 2011
15 3924 Tue, 22 March 2011 14:29
By: Michel Cadot
  SQL Tuning ...
Oracle 11g R2
By: aucrun on Tue, 22 March 2011
1 908 Tue, 22 March 2011 13:02
By: BlackSwan
icon8.gif 9582.69043 gigabytes of physical read total bytes and increasing!
11gR2 on Linux RedHat
By: nabeelkhan on Thu, 17 March 2011
8 4074 Sat, 19 March 2011 03:12
By: John Watson
  INDEXES on TIMESTAMP
Oracle 11.2 WIndows Vista 64bit
By: amcghie on Thu, 17 March 2011
0 6558 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 642 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 3088 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1172 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1089 Thu, 10 March 2011 21:15
By: Flyby
  prev_hash_value not changing in v$session
Oracle 10.2.0.4.0 on RHEL
By: OraKaran on Thu, 10 March 2011
6 1558 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9684 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1483 Thu, 10 March 2011 07:36
By: marcodba
  Stored Procedure is taking too long time to Execute. (2 Merged)
Oracle 11.2
By: nanuvamsi on Fri, 04 March 2011
6 2342 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1345 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1775 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 991 Fri, 04 March 2011 03:43
By: cookiemonster
  Tunning the query and 4000-5000 parameter in IN clause
By: forroughuse on Wed, 02 March 2011
12 802 Thu, 03 March 2011 12:12
By: Littlefoot
  Collecting stats
oracle 10.2.0.1.0 - windows XP
By: muktha_22 on Thu, 03 March 2011
1 537 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 1153 Mon, 28 February 2011 17:19
By: BlackSwan
  faster processing of records needed: performance isue
oracle 9i/10g/11g
By: ashish_sun123 on Sat, 26 February 2011
2 1056 Mon, 28 February 2011 08:01
By: michael_bialik
icon4.gif Wrong REDO log file location
Oracle 10G, Solaris 10
By: Tlg13team on Fri, 25 February 2011
4 2490 Fri, 25 February 2011 20:43
By: wkk1020
  help to wrire the procedure
oracle,10g,unix
By: vickey_sagar1 on Fri, 25 February 2011
2 602 Fri, 25 February 2011 15:10
By: cookiemonster
  performance tuning
general
By: goldenshot2727 on Thu, 22 April 2010
4 1197 Fri, 25 February 2011 07:31
By: samosimo
  Cursor_sharing setting in OLTP environment
Oracle 9i R2, 10g R2
By: OraKaran on Tue, 22 February 2011
11 1903 Wed, 23 February 2011 08:13
By: OraKaran
  Identify blocking sessions
11.1.0.7, Standard Edition
By: John Watson on Mon, 21 February 2011
4 1793 Tue, 22 February 2011 03:49
By: John Watson
  Slow Sql query
Oracle 10.2.0.3
By: Its_me_ved on Thu, 17 February 2011
8 1677 Sun, 20 February 2011 06:00
By: Its_me_ved
  full table scan
10.2.0.4
By: sathik123 on Sat, 19 February 2011
2 934 Sun, 20 February 2011 00:26
By: Michel Cadot
icon5.gif Performance tuning of PL/SQL Procedure
Oracle 10.2.0.5
By: Santrupta on Sun, 13 February 2011
10 1699 Thu, 17 February 2011 09:26
By: cookiemonster
  Performance issue in jsp application
Oracle 10.2.0.3,jsp
By: Its_me_ved on Wed, 16 February 2011
2 1050 Wed, 16 February 2011 05:52
By: rleishman
  Bulk Update
Oracle 11g
By: rcd70 on Tue, 15 February 2011
1 1312 Tue, 15 February 2011 18:54
By: BlackSwan
icon7.gif Optimal REDO log file size
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 10 February 2011
9 7798 Mon, 14 February 2011 03:44
By: Tlg13team
  Performance tuning
oracle 9i/10g/11g
By: ashish_sun123 on Sun, 13 February 2011
6 681 Sun, 13 February 2011 23:32
By: Michel Cadot
  SELECT query
Oracle,11.1.0.6,RHEL 5
By: arunb1982 on Fri, 11 February 2011
6 727 Fri, 11 February 2011 12:44
By: Michel Cadot
  Queries on PGA Settings and related Memory Management
Oracle 9i on RHEL
By: OraKaran on Fri, 11 February 2011
8 3245 Fri, 11 February 2011 11:14
By: OraKaran
  Delete command running taking long time
windows server 2003, oracle 11g DB
By: pradies on Fri, 11 February 2011
9 1690 Fri, 11 February 2011 05:33
By: OraKaran
  Application is slow when no of connections goes up
Oracle Database 8.1.7 on Solaris
By: rajan69 on Wed, 09 February 2011
2 895 Wed, 09 February 2011 07:19
By: cookiemonster
  How to Change execution plan of Currently Executing Statement?
Oracle 10.2.4.0 on RHEL
By: OraKaran on Tue, 08 February 2011
6 2429 Wed, 09 February 2011 03:21
By: OraKaran
  data caching
oraclge 10g
By: gamba on Mon, 07 February 2011
7 692 Tue, 08 February 2011 03:30
By: cookiemonster
  Real time speed improvements & autotrace results.
Oracle 9.2/Solaris
By: Roachcoach on Fri, 04 February 2011
11 2831 Mon, 07 February 2011 09:43
By: Roachcoach
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 Aug 01 18:51:02 CDT 2014

Total time taken to generate the page: 0.17343 seconds