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

    Replies Views Last message
  Performance hit of the application after moving the DB server
oracle 9i, 10g, forms 10g/9i, AS9i
By: rajesh4851 on Thu, 23 December 2010
1 2133 Thu, 23 December 2010 03:47
By: Michel Cadot
  archive log
oracle 10g
By: prashant_ora on Sun, 19 December 2010
8 5650 Wed, 22 December 2010 10:47
By: Roachcoach
  Temp tablespace full
ORACLE,9.2.0.5.0,AIX
By: lokeshracdba on Wed, 22 December 2010
1 2750 Wed, 22 December 2010 01:10
By: Michel Cadot
  delete procedure taking time
oracle,9i,unix
By: vickey_sagar1 on Tue, 21 December 2010
7 3111 Wed, 22 December 2010 00:01
By: rleishman
  Change in explain plan due to Oracle upgrade
Oracle 10.2.0.4.0, Windows Server 2003
By: chowdhhx on Tue, 14 December 2010
5 5279 Thu, 16 December 2010 19:14
By: BlackSwan
  Tune the query
Oracle9i
By: ajaykumarkona on Wed, 15 December 2010
4 2465 Wed, 15 December 2010 17:17
By: cookiemonster
  dbms_job
oracle 10g
By: prashant_ora on Tue, 14 December 2010
9 3416 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 3929 Wed, 15 December 2010 01:31
By: Michel Cadot
  dbms_lob.append
oracle 10g
By: prashant_ora on Mon, 13 December 2010
6 7161 Tue, 14 December 2010 12:10
By: prashant_ora
  help on Query tuning
oracle 10g
By: saaya123 on Tue, 14 December 2010
4 2807 Tue, 14 December 2010 06:25
By: rleishman
  Index leading columns
Oracle 10.2.0.3
By: pointers on Tue, 14 December 2010
4 4681 Tue, 14 December 2010 05:53
By: pointers
  TEMP usage history
Oracle 10g, Sun OS
By: gkrishn on Mon, 19 July 2010
6 18619 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 2985 Sun, 12 December 2010 09:01
By: Michel Cadot
  What are the best practices with indexes?
By: DataMouse on Fri, 10 December 2010
3 3344 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 5249 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 3430 Thu, 09 December 2010 08:43
By: BlackSwan
  Expensive Query
Oracle 11g
By: ashoka_bl on Mon, 06 December 2010
5 4264 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 11683 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 2051 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 2359 Thu, 02 December 2010 08:58
By: BlackSwan
  Why oracle doesn't use the index?
By: iblazquez on Thu, 02 December 2010
9 3647 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 4834 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 6088 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 2939 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 11011 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 9716 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 3177 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 3935 Sun, 21 November 2010 07:53
By: Michel Cadot
  order by
Oracle9i
By: ajaykumarkona on Thu, 18 November 2010
3 2863 Fri, 19 November 2010 15:23
By: rleishman
  Tune the query
Windows 2000, Oracle 10g
By: oraranjangmailcom on Fri, 19 November 2010
1 2183 Fri, 19 November 2010 08:50
By: BlackSwan
  Index with NVL
By: ss1_3 on Fri, 19 November 2010
2 3210 Fri, 19 November 2010 08:00
By: Michel Cadot
  Method of Tuning Database - row reduction
By: palhello on Wed, 20 October 2010
6 4250 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 15346 Thu, 18 November 2010 08:48
By: Michel Cadot
  Query running slow
Oracle 10g
By: virmahi on Thu, 18 November 2010
6 3166 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 4351 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 7953 Mon, 15 November 2010 13:42
By: annagel
  a lot of 'EXISTS' in query
Oracle 10g
By: mape on Mon, 15 November 2010
12 12068 Mon, 15 November 2010 12:14
By: Michel Cadot
  Slow Running Query
By: sameek1211 on Wed, 10 November 2010
20 5479 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 3429 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 3481 Sat, 13 November 2010 08:23
By: BlackSwan
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: Sat Aug 16 23:01:37 CDT 2025