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
Order by Clause is too slow Oracle 11g r2 centos linux By: oravijay on Fri, 12 November 2010	4	16474	Fri, 12 November 2010 16:59 By: rleishman
query problem By: narang79 on Wed, 10 November 2010	5	3595	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	8595	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	4501	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	9856	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	3732	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	3990	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	2927	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	20587	Tue, 02 November 2010 14:43 By: John Watson
Query Oracle 9i By: ajaykumarkona on Mon, 01 November 2010	6	3047	Tue, 02 November 2010 03:50 By: Roachcoach
union in one go oracle 10g By: prashant_ora on Mon, 01 November 2010	5	3015	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	3159	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	5361	Thu, 28 October 2010 03:05 By: John Watson
Group By taking more time (merged) By: srivardhan on Tue, 26 October 2010	10	3264	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	3057	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	2734	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	4161	Mon, 25 October 2010 03:20 By: michael_bialik
PCTFREE AND PCTUSED By: sunayana_girl on Mon, 18 October 2010	7	5468	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	44375	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	4523	Tue, 19 October 2010 10:47 By: sandhyaa
AWR analysis By: dba1234 on Thu, 14 October 2010	1	9116	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	5901	Tue, 19 October 2010 02:49 By: Yasir Hashmi
QUERY OPTIMIZATION By: ending20 on Sun, 17 October 2010	1	2708	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	2583	Fri, 15 October 2010 10:06 By: mandie722
(probably) basic CBO question Oracle 11g By: chris32680 on Thu, 14 October 2010	7	4215	Fri, 15 October 2010 09:19 By: BlackSwan
Related to data base import By: rajik86ece on Thu, 14 October 2010	2	2550	Fri, 15 October 2010 02:19 By: Michel Cadot
How we do Optimisation and tuning By: habibkhanp11 on Thu, 14 October 2010	1	2577	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	9914	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	4051	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	3365	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	4477	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	4032	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	7376	Sun, 03 October 2010 05:06 By: sky_lt
Performace issue in update oracle 11g By: ravi214u on Wed, 29 September 2010	2	10827	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	8821	Wed, 29 September 2010 00:05 By: Michel Cadot
Query Tunning By: bhatwalne on Mon, 27 September 2010	5	2881	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	2850	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	3643	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	2307	Mon, 27 September 2010 01:10 By: Michel Cadot
"Fast refresh" MV too slow By: ss1_3 on Thu, 23 September 2010	2	3122	Fri, 24 September 2010 18:03 By: rleishman