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

    Replies Views Last message
  Tune the query
Oracle9i
By: ajaykumarkona on Wed, 15 December 2010
4 1901 Wed, 15 December 2010 17:17
By: cookiemonster
  dbms_job
oracle 10g
By: prashant_ora on Tue, 14 December 2010
9 2719 Wed, 15 December 2010 14:23
By: Haraprasad Hota
  When to use sub-query and when to use join
11g R1, Windows
By: delna.sexy on Tue, 14 December 2010
9 3038 Wed, 15 December 2010 01:31
By: Michel Cadot
  dbms_lob.append
oracle 10g
By: prashant_ora on Mon, 13 December 2010
6 6359 Tue, 14 December 2010 12:10
By: prashant_ora
  help on Query tuning
oracle 10g
By: saaya123 on Tue, 14 December 2010
4 2112 Tue, 14 December 2010 06:25
By: rleishman
  Index leading columns
Oracle 10.2.0.3
By: pointers on Tue, 14 December 2010
4 3942 Tue, 14 December 2010 05:53
By: pointers
  TEMP usage history
Oracle 10g, Sun OS
By: gkrishn on Mon, 19 July 2010
6 17669 Mon, 13 December 2010 10:41
By: Michel Cadot
  SID column in V$SESSION
ORCLE 10g.2 WINDOWS XP
By: muktha_22 on Sun, 12 December 2010
2 1705 Sun, 12 December 2010 09:01
By: Michel Cadot
  What are the best practices with indexes?
By: DataMouse on Fri, 10 December 2010
3 2617 Sat, 11 December 2010 03:48
By: Littlefoot
  Query using rownum in where cluase with millions of records
Oracle 11g , Windows
By: pradies on Wed, 08 December 2010
10 2925 Thu, 09 December 2010 11:53
By: Michel Cadot
  Creating index on base tables of a view
By: mmtr on Thu, 09 December 2010
1 2567 Thu, 09 December 2010 08:43
By: BlackSwan
  Expensive Query
Oracle 11g
By: ashoka_bl on Mon, 06 December 2010
5 3489 Mon, 06 December 2010 05:53
By: flyboy
  SQL query performance tuning
Oracle 11g Suse Linux 11
By: burasami on Thu, 02 December 2010
5 10814 Sat, 04 December 2010 00:39
By: rleishman
  Trailing issue during processing huge data
Oracle 9i
By: adi_bbay on Fri, 03 December 2010
1 1409 Fri, 03 December 2010 02:01
By: Michel Cadot
  Confusion about Partitioning
11g,HP-UNIX B11.23
By: indrajit2002 on Thu, 02 December 2010
1 1486 Thu, 02 December 2010 08:58
By: BlackSwan
  Why oracle doesn't use the index?
By: iblazquez on Thu, 02 December 2010
9 2820 Thu, 02 December 2010 07:51
By: Roachcoach
  Analysys about a single oracle table
red hat linux 4/oracle 10g2
By: goracle9 on Tue, 30 November 2010
7 3039 Wed, 01 December 2010 08:43
By: Constancy
  SQL - Query Performance
Oracle Database 11g Release 11.1.0.6.0, Windows Server 2003
By: MSAM123 on Mon, 29 November 2010
25 4566 Wed, 01 December 2010 04:05
By: MSAM123
  Copy data's from Transaction database(db1) to Reporting database (db2)
Windows 2000, Oracle 10g
By: oraranjangmailcom on Fri, 26 November 2010
4 2212 Fri, 26 November 2010 04:15
By: Michel Cadot
  Performance issue for distributed transaction (2PC)
Oracle RDBMS 10.2.0.4, HP-UX 11.31
By: samg4ug on Fri, 26 November 2010
0 10002 Fri, 26 November 2010 02:17
By: samg4ug
  Improve performance of create statements on a highly fragmented disk
By: steffeli on Wed, 24 November 2010
7 8729 Wed, 24 November 2010 09:33
By: Roachcoach
  Sql Taking More CPU time (merged)
Oracle 10g ,Sun Solaris
By: saiphani723 on Tue, 23 November 2010
4 2500 Wed, 24 November 2010 00:50
By: michael_bialik
  Performance tuning (cache sub query results)
Oracle 10g
By: yosikal on Sun, 21 November 2010
1 3218 Sun, 21 November 2010 07:53
By: Michel Cadot
  order by
Oracle9i
By: ajaykumarkona on Thu, 18 November 2010
3 2202 Fri, 19 November 2010 15:23
By: rleishman
  Tune the query
Windows 2000, Oracle 10g
By: oraranjangmailcom on Fri, 19 November 2010
1 1731 Fri, 19 November 2010 08:50
By: BlackSwan
  Index with NVL
By: ss1_3 on Fri, 19 November 2010
2 2649 Fri, 19 November 2010 08:00
By: Michel Cadot
  Method of Tuning Database - row reduction
By: palhello on Wed, 20 October 2010
6 2833 Thu, 18 November 2010 23:34
By: rleishman
  Help me find the SQL using hash value? (ORA-00060)
rdbms 10.2, sles10 x64, three node RAC
By: hristo on Thu, 18 November 2010
2 14791 Thu, 18 November 2010 08:48
By: Michel Cadot
  Query running slow
Oracle 10g
By: virmahi on Thu, 18 November 2010
6 2438 Thu, 18 November 2010 04:49
By: Its_me_ved
  Procedure performance issue on new DB import?
Oracle 11g
By: chris32680 on Mon, 15 November 2010
13 3360 Mon, 15 November 2010 20:14
By: chris32680
  STOPKEY & Index Use
10.2.0.4.0 - 64bi, Windows 2003
By: annagel on Sat, 06 November 2010
15 6424 Mon, 15 November 2010 13:42
By: annagel
  a lot of 'EXISTS' in query
Oracle 10g
By: mape on Mon, 15 November 2010
12 11068 Mon, 15 November 2010 12:14
By: Michel Cadot
  Slow Running Query
By: sameek1211 on Wed, 10 November 2010
20 4219 Mon, 15 November 2010 03:00
By: michael_bialik
  Oracle Row Chaining and Migration
Oracle 10.2.0.4 AIX 6L
By: dba_7722 on Sat, 13 November 2010
4 2410 Sat, 13 November 2010 10:44
By: Michel Cadot
  which index is best for query performance
Oracel 11.1 Red Hat
By: nehaverma on Fri, 12 November 2010
5 2032 Sat, 13 November 2010 08:23
By: BlackSwan
  Order by Clause is too slow
Oracle 11g r2 centos linux
By: oravijay on Fri, 12 November 2010
4 14576 Fri, 12 November 2010 16:59
By: rleishman
  query problem
By: narang79 on Wed, 10 November 2010
5 2557 Wed, 10 November 2010 03:43
By: ramoradba
  MV when detailed table consists of Millions of records
By: ind9 on Tue, 09 November 2010
5 7850 Tue, 09 November 2010 04:47
By: ind9
  Query working very slow
oracle 10.2.0.4.0
By: navneet_sharma on Thu, 04 November 2010
9 3587 Tue, 09 November 2010 02:55
By: michael_bialik
  Using ROW_NUMBER() reduces performance
Oracle 10g R2
By: antenc on Mon, 08 November 2010
5 8612 Mon, 08 November 2010 05:03
By: antenc
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 Mar 28 19:27:55 CDT 2024