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

    Replies Views Last message
  SQL Tuning ...
Oracle 11g R2
By: aucrun on Tue, 22 March 2011
1 904 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 4068 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 6545 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 637 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 3079 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1169 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1085 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 1552 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9665 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1475 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 2335 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1337 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1769 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 984 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 798 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 535 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 1151 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 1053 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 2399 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 598 Fri, 25 February 2011 15:10
By: cookiemonster
  performance tuning
general
By: goldenshot2727 on Thu, 22 April 2010
4 1192 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 1895 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 1783 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 1667 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 932 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 1682 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 1044 Wed, 16 February 2011 05:52
By: rleishman
  Bulk Update
Oracle 11g
By: rcd70 on Tue, 15 February 2011
1 1311 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 7534 Mon, 14 February 2011 03:44
By: Tlg13team
  Performance tuning
oracle 9i/10g/11g
By: ashish_sun123 on Sun, 13 February 2011
6 680 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 718 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 3229 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 1683 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 893 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 2418 Wed, 09 February 2011 03:21
By: OraKaran
  data caching
oraclge 10g
By: gamba on Mon, 07 February 2011
7 685 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 2826 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 1006 Mon, 07 February 2011 02:08
By: priyankt
  tunning
oracle 10g/windows 2003
By: gxeon on Fri, 04 February 2011
5 733 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 1111 Thu, 03 February 2011 06:34
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: Fri Jul 25 11:43:44 CDT 2014

Total time taken to generate the page: 0.06545 seconds