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

    Replies Views Last message
  Why Oracle don't use my predefined index?
Oracle 10G, windows
By: Tlg13team on Thu, 07 April 2011
5 1054 Thu, 07 April 2011 02:43
By: Roachcoach
  Execution plan question
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
By: Buchas on Tue, 05 April 2011
15 2432 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 636 Wed, 06 April 2011 06:08
By: michael_bialik
  how to use index on "ON in MERGE statement"?
10g, windows 2003 server.
By: kang on Wed, 06 April 2011
19 1001 Wed, 06 April 2011 04:59
By: Roachcoach
  Just clarification my mind about redo log file size
Oracle 10G
By: Tlg13team on Wed, 06 April 2011
3 2045 Wed, 06 April 2011 01:16
By: Michel Cadot
  please help me tune this query
By: miroconnect@yahoo.com on Sun, 03 April 2011
3 779 Mon, 04 April 2011 09:10
By: cookiemonster
  Query getting slowed running in Oracle 10g compared to Oracle 9i
Oracle 10g, Linux
By: ram anand on Wed, 30 March 2011
24 2769 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 964 Mon, 04 April 2011 02:26
By: cookiemonster
  derived column index
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
3 811 Sat, 02 April 2011 08:37
By: BlackSwan
  using between slows query
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
1 1009 Sat, 02 April 2011 01:24
By: Michel Cadot
  Performance tuning of query with self join
By: preethavinay on Thu, 31 March 2011
6 1240 Fri, 01 April 2011 02:48
By: Its_me_ved
icon5.gif split a large table to small pieces?
Oracle 10G, Solaris 10
By: Tlg13team on Mon, 28 March 2011
12 1561 Thu, 31 March 2011 03:40
By: Kevin Meade
  Can I use Oracle Hint to use index in a query which uses UNION
Oracle 10g
By: arijitdey80 on Thu, 31 March 2011
1 1489 Thu, 31 March 2011 01:52
By: Michel Cadot
  Why are these explain plans missing some info and messed up like they've been simultaneously written
Windows 7 Pro, x64bit
By: ilharco on Tue, 29 March 2011
8 1424 Tue, 29 March 2011 17:06
By: BlackSwan
  nested select / instead-of-trigger and views=no index used
10g 10.2.0.4
By: Kevin Meade on Tue, 08 September 2009
10 2247 Tue, 29 March 2011 08:47
By: ipynnonen
  Performance issue with long running query
Oracle 11i
By: prasadpsk on Wed, 23 March 2011
14 1890 Tue, 29 March 2011 03:16
By: rleishman
  How to assure partition table is better than non-partition table (2 MERGED)
Oracle 10g R2
By: Tlg13team on Fri, 25 March 2011
11 1333 Mon, 28 March 2011 21:19
By: BlackSwan
  row cache lock/dc_users??
oracle 11g solaris 10
By: chris32680 on Thu, 17 March 2011
21 10025 Mon, 28 March 2011 09:03
By: Michel Cadot
icon5.gif clarification of query EXPLAIN plan
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 24 March 2011
5 871 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 1137 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 4012 Tue, 22 March 2011 14:29
By: Michel Cadot
  SQL Tuning ...
Oracle 11g R2
By: aucrun on Tue, 22 March 2011
1 931 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 4129 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 6666 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 662 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 3125 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1199 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1126 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 1582 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9820 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1520 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 2410 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1383 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1806 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 1020 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 827 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 543 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 1171 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 1064 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 2528 Fri, 25 February 2011 20:43
By: wkk1020
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: Sun Sep 21 22:00:12 CDT 2014

Total time taken to generate the page: 0.11657 seconds