OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
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	2172	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	19492	Tue, 02 November 2010 14:43 By: John Watson
Query Oracle 9i By: ajaykumarkona on Mon, 01 November 2010	6	2068	Tue, 02 November 2010 03:50 By: Roachcoach
union in one go oracle 10g By: prashant_ora on Mon, 01 November 2010	5	1703	Mon, 01 November 2010 11:14 By: Michel Cadot
Required tool for SQL Query ORACLE 10g 10.2.0.1.0 By: dkdms2124 on Thu, 28 October 2010	4	1764	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	4083	Thu, 28 October 2010 03:05 By: John Watson
Group By taking more time (merged) By: srivardhan on Tue, 26 October 2010	10	2003	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	2037	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	1863	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	3004	Mon, 25 October 2010 03:20 By: michael_bialik
PCTFREE AND PCTUSED By: sunayana_girl on Mon, 18 October 2010	7	3190	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	38239	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	3580	Tue, 19 October 2010 10:47 By: sandhyaa
AWR analysis By: dba1234 on Thu, 14 October 2010	1	8199	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	4598	Tue, 19 October 2010 02:49 By: Yasir Hashmi
QUERY OPTIMIZATION By: ending20 on Sun, 17 October 2010	1	1707	Sun, 17 October 2010 06:57 By: rleishman
Returning all rows that equal a max(value) Oracle,11.1.0.6,Linux By: mandie722 on Thu, 14 October 2010	2	1855	Fri, 15 October 2010 10:06 By: mandie722
(probably) basic CBO question Oracle 11g By: chris32680 on Thu, 14 October 2010	7	3068	Fri, 15 October 2010 09:19 By: BlackSwan
Related to data base import By: rajik86ece on Thu, 14 October 2010	2	1206	Fri, 15 October 2010 02:19 By: Michel Cadot
How we do Optimisation and tuning By: habibkhanp11 on Thu, 14 October 2010	1	1478	Thu, 14 October 2010 01:28 By: Michel Cadot
Need performance tuning in delete statement Oracle 10g, windows By: burasami on Tue, 12 October 2010	14	8517	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	2933	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	2422	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	3536	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	2390	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	4975	Sun, 03 October 2010 05:06 By: sky_lt
Performace issue in update oracle 11g By: ravi214u on Wed, 29 September 2010	2	9146	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	6841	Wed, 29 September 2010 00:05 By: Michel Cadot
Query Tunning By: bhatwalne on Mon, 27 September 2010	5	1779	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	1852	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	2746	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	1281	Mon, 27 September 2010 01:10 By: Michel Cadot
"Fast refresh" MV too slow By: ss1_3 on Thu, 23 September 2010	2	2293	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	2160	Fri, 24 September 2010 08:30 By: cookiemonster
queary taking time Oracle10.2.0.1/linux By: goracle9 on Thu, 23 September 2010	2	2068	Thu, 23 September 2010 04:54 By: goracle9
Performance over a DB link!! By: ankurgodambe on Sun, 10 July 2005	10	11712	Wed, 22 September 2010 07:57 By: rleishman
Performance tunning oracle 8i By: vishalsrivastava on Mon, 20 September 2010	3	1866	Wed, 22 September 2010 00:12 By: Its_me_ved
Oracle UNION ALL performance issue Oracle 10g By: victoryhendry on Thu, 09 September 2010	33	24681	Mon, 20 September 2010 03:17 By: Roachcoach
nested loops 10.2.0.1 linux 32 bit By: Yasir Hashmi on Tue, 14 September 2010	10	2889	Wed, 15 September 2010 08:02 By: Michel Cadot
Sql Tunning Concept Oracle 10g By: nagpalgggmailcom on Wed, 15 September 2010	5	2067	Wed, 15 September 2010 06:16 By: Roachcoach