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

    Replies Views Last message
icon8.gif 9582.69043 gigabytes of physical read total bytes and increasing!
11gR2 on Linux RedHat
By: nabeelkhan on Thu, 17 March 2011
8 4013 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 6390 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 616 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 3024 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1114 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1046 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 1505 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9414 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1428 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 2242 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1261 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1722 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 911 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 764 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 515 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 1112 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 1027 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 895 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 554 Fri, 25 February 2011 15:10
By: cookiemonster
  performance tuning
general
By: goldenshot2727 on Thu, 22 April 2010
4 1158 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 1794 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 1673 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 1601 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 895 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 1569 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 1019 Wed, 16 February 2011 05:52
By: rleishman
  Bulk Update
Oracle 11g
By: rcd70 on Tue, 15 February 2011
1 1266 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 3813 Mon, 14 February 2011 03:44
By: Tlg13team
  Performance tuning
oracle 9i/10g/11g
By: ashish_sun123 on Sun, 13 February 2011
6 659 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 631 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 3041 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 1579 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 863 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 2298 Wed, 09 February 2011 03:21
By: OraKaran
  data caching
oraclge 10g
By: gamba on Mon, 07 February 2011
7 662 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 2741 Mon, 07 February 2011 09:43
By: Roachcoach
  Update columns of one table using another table
Oracle 10G
By: priyankt on Sun, 06 February 2011
4 953 Mon, 07 February 2011 02:08
By: priyankt
  tunning
oracle 10g/windows 2003
By: gxeon on Fri, 04 February 2011
5 678 Fri, 04 February 2011 08:11
By: gxeon
  Query Regarding Nested Loop
Oracle 9i R2 on RHEL
By: OraKaran on Thu, 27 January 2011
27 1070 Thu, 03 February 2011 06:34
By: Michel Cadot
  No Snapshot Avaliable for AWR Report
Oracle 11g, Windows 2003
By: pradies on Tue, 01 February 2011
8 3849 Wed, 02 February 2011 01:35
By: Michel Cadot
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 Apr 24 19:25:17 CDT 2014

Total time taken to generate the page: 0.16196 seconds