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

    Replies Views Last message
  Using ROW_NUMBER() reduces performance
Oracle 10g R2
By: antenc on Mon, 08 November 2010
5 8700 Mon, 08 November 2010 05:03
By: antenc
  Query to a partition table run to slow (2 Merged)
Oracle 9, HP-UX
By: RMSoares on Thu, 04 November 2010
4 3127 Sun, 07 November 2010 21:27
By: rleishman
  Partitioned table
windows xp, oracle 9.2.0.0
By: muktha_22 on Wed, 03 November 2010
3 3440 Wed, 03 November 2010 05:24
By: John Watson
  How do I justify using different disks (2 merged)
Oracle Database 10g Enterprise Edition 10.2.0.4.0 Prod, Microsoft Windows IA (32-bit)
By: kytemanaic on Tue, 02 November 2010
2 2442 Wed, 03 November 2010 02:22
By: kytemanaic
  DBMS_ADVISOR ORA-13699
11.2.0.1, Linux and Windows 32 bit
By: John Watson on Tue, 02 November 2010
4 19843 Tue, 02 November 2010 14:43
By: John Watson
  Query
Oracle 9i
By: ajaykumarkona on Mon, 01 November 2010
6 2410 Tue, 02 November 2010 03:50
By: Roachcoach
  union in one go
oracle 10g
By: prashant_ora on Mon, 01 November 2010
5 2016 Mon, 01 November 2010 11:14
By: Michel Cadot
icon7.gif Required tool for SQL Query
ORACLE 10g 10.2.0.1.0
By: dkdms2124 on Thu, 28 October 2010
4 2049 Thu, 28 October 2010 07:05
By: dkdms2124
  Oracle 11g r2 result_cache is Not working
linux centos 5
By: oravijay on Mon, 25 October 2010
10 4431 Thu, 28 October 2010 03:05
By: John Watson
  Group By taking more time (merged)
By: srivardhan on Tue, 26 October 2010
10 2374 Wed, 27 October 2010 04:38
By: Michel Cadot
  DBMS Stats gathering
Oracle 10.2.0.4,Linux
By: preet_kumar on Tue, 26 October 2010
1 2319 Tue, 26 October 2010 18:56
By: BlackSwan
  distributing datafiles in server
Win 2000,8.1.7
By: ultgnp on Tue, 26 October 2010
4 2174 Tue, 26 October 2010 02:49
By: Michel Cadot
  Difference in query performance
10.2.0.4
By: sandhyaa on Sat, 23 October 2010
9 3320 Mon, 25 October 2010 03:20
By: michael_bialik
  PCTFREE AND PCTUSED
By: sunayana_girl on Mon, 18 October 2010
7 3541 Wed, 20 October 2010 06:22
By: sunayana_girl
  PX Deq: Execute Reply
ORACLE 10G,10.2.0.3.0,AIX
By: rajatratewal on Tue, 19 October 2010
6 40156 Tue, 19 October 2010 11:52
By: rajatratewal
  MV refresh with atomic_refresh false
10.2.0.4
By: sandhyaa on Sun, 17 October 2010
3 3889 Tue, 19 October 2010 10:47
By: sandhyaa
  AWR analysis
By: dba1234 on Thu, 14 October 2010
1 8537 Tue, 19 October 2010 06:18
By: kamkan
  Full tablescan eventhough join is on indexed field
10.2.0.4
By: Anand Ramaswamy on Mon, 18 October 2010
9 5024 Tue, 19 October 2010 02:49
By: Yasir Hashmi
  QUERY OPTIMIZATION
By: ending20 on Sun, 17 October 2010
1 1972 Sun, 17 October 2010 06:57
By: rleishman
icon5.gif Returning all rows that equal a max(value)
Oracle,11.1.0.6,Linux
By: mandie722 on Thu, 14 October 2010
2 2123 Fri, 15 October 2010 10:06
By: mandie722
  (probably) basic CBO question
Oracle 11g
By: chris32680 on Thu, 14 October 2010
7 3394 Fri, 15 October 2010 09:19
By: BlackSwan
  Related to data base import
By: rajik86ece on Thu, 14 October 2010
2 1525 Fri, 15 October 2010 02:19
By: Michel Cadot
  How we do Optimisation and tuning
By: habibkhanp11 on Thu, 14 October 2010
1 1754 Thu, 14 October 2010 01:28
By: Michel Cadot
icon5.gif Need performance tuning in delete statement
Oracle 10g, windows
By: burasami on Tue, 12 October 2010
14 8914 Wed, 13 October 2010 02:38
By: burasami
  Order of executing indexes (2 merged)
oracle 10.2.0,4,0
By: Marnickxs on Fri, 08 October 2010
5 3290 Mon, 11 October 2010 16:56
By: rleishman
  Query Problem
Oracle 9.2.0.8(HP-UX)
By: indrajit2002 on Mon, 04 October 2010
6 2742 Tue, 05 October 2010 11:52
By: S.Rajaram
  Query running way too slow
Oracle 9.2.0.8 (HP-UX)
By: indrajit2002 on Mon, 04 October 2010
6 3839 Mon, 04 October 2010 21:51
By: rleishman
  Tuning Buffer cache and Buffer Busy Waits.
oracle 9.2.0.1.0 windows
By: muktha_22 on Sun, 03 October 2010
5 2732 Sun, 03 October 2010 14:57
By: Michel Cadot
  Column width convergation with Index performance
Oracel 10.2.x
By: sky_lt on Thu, 30 September 2010
24 5471 Sun, 03 October 2010 05:06
By: sky_lt
  Performace issue in update
oracle 11g
By: ravi214u on Wed, 29 September 2010
2 9737 Fri, 01 October 2010 10:21
By: LKBrwn_DBA
  DBA_WAITERS , BLOCKERS $ V$LOCK
Oracle Enterprise Edition 10.2.0.4, Solaris 10
By: jesuisantony on Fri, 24 September 2010
5 7232 Wed, 29 September 2010 00:05
By: Michel Cadot
  Query Tunning
By: bhatwalne on Mon, 27 September 2010
5 2067 Mon, 27 September 2010 15:23
By: Michel Cadot
  Columns of v$ sessions_event.
oracle 10.1.0.2.0 - windows
By: muktha_22 on Mon, 27 September 2010
7 2174 Mon, 27 September 2010 12:50
By: Michel Cadot
  Insert into table slows down query
Oracle 8i
By: dev_777 on Thu, 23 September 2010
3 3021 Mon, 27 September 2010 08:46
By: S.Rajaram
  Flushing Buffer Cache.
Oracle 9i.2, Windows.
By: muktha_22 on Mon, 27 September 2010
1 1540 Mon, 27 September 2010 01:10
By: Michel Cadot
  "Fast refresh" MV too slow
By: ss1_3 on Thu, 23 September 2010
2 2582 Fri, 24 September 2010 18:03
By: rleishman
  will effect the performace of DML on Fast refresh of Materialized view
Oracle 10g
By: victoryhendry on Fri, 24 September 2010
5 2464 Fri, 24 September 2010 08:30
By: cookiemonster
  queary taking time
Oracle10.2.0.1/linux
By: goracle9 on Thu, 23 September 2010
2 2354 Thu, 23 September 2010 04:54
By: goracle9
  Performance over a DB link!!
By: ankurgodambe on Sun, 10 July 2005
10 12053 Wed, 22 September 2010 07:57
By: rleishman
  Performance tunning
oracle 8i
By: vishalsrivastava on Mon, 20 September 2010
3 2147 Wed, 22 September 2010 00:12
By: Its_me_ved
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 May 24 20:14:19 CDT 2024