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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
DBMS Stats gathering Oracle 10.2.0.4,Linux By: preet_kumar on Tue, 26 October 2010	1	978	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	409	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	941	Mon, 25 October 2010 03:20 By: michael_bialik
PCTFREE AND PCTUSED By: sunayana_girl on Mon, 18 October 2010	7	1394	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	6036	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	1657	Tue, 19 October 2010 10:47 By: sandhyaa
AWR analysis By: dba1234 on Thu, 14 October 2010	1	3317	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	1023	Tue, 19 October 2010 02:49 By: Yasir Hashmi
QUERY OPTIMIZATION By: ending20 on Sun, 17 October 2010	1	644	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	721	Fri, 15 October 2010 10:06 By: mandie722
(probably) basic CBO question Oracle 11g By: chris32680 on Thu, 14 October 2010	7	542	Fri, 15 October 2010 09:19 By: BlackSwan
Related to data base import By: rajik86ece on Thu, 14 October 2010	2	418	Fri, 15 October 2010 02:19 By: Michel Cadot
How we do Optimisation and tuning By: habibkhanp11 on Thu, 14 October 2010	1	574	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	5814	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	811	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	671	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	843	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	908	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	970	Sun, 03 October 2010 05:06 By: sky_lt
Performace issue in update oracle 11g By: ravi214u on Wed, 29 September 2010	2	1621	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	2919	Wed, 29 September 2010 00:05 By: Michel Cadot
Query Tunning By: bhatwalne on Mon, 27 September 2010	5	553	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	454	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	1108	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	488	Mon, 27 September 2010 01:10 By: Michel Cadot
"Fast refresh" MV too slow By: ss1_3 on Thu, 23 September 2010	2	729	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	768	Fri, 24 September 2010 08:30 By: cookiemonster
queary taking time Oracle10.2.0.1/linux By: goracle9 on Thu, 23 September 2010	2	894	Thu, 23 September 2010 04:54 By: goracle9
Performance over a DB link!! By: ankurgodambe on Sun, 10 July 2005	10	7382	Wed, 22 September 2010 07:57 By: rleishman
Performance tunning oracle 8i By: vishalsrivastava on Mon, 20 September 2010	3	653	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	5339	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	734	Wed, 15 September 2010 08:02 By: Michel Cadot
Sql Tunning Concept Oracle 10g By: nagpalgggmailcom on Wed, 15 September 2010	5	717	Wed, 15 September 2010 06:16 By: Roachcoach
To find the indexes (used and unused on the table Oracle 10g on "Windows XP" and "Sun Solaris" By: xclusiveravi523 on Wed, 15 September 2010	3	559	Wed, 15 September 2010 05:36 By: Michel Cadot
Query performance gain using statistics By: jackman1 on Mon, 09 August 2010	6	2296	Tue, 14 September 2010 10:08 By: jackman1
Need to tune query Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production By: knw15pwr on Wed, 08 September 2010	15	1165	Tue, 14 September 2010 03:46 By: cookiemonster
Procedures not getting executed Oracle 9.2.0.8 (HP-UX) By: indrajit2002 on Mon, 13 September 2010	3	547	Mon, 13 September 2010 09:20 By: cookiemonster
Standard vs Advanced Compression Windows Server 2008, Oracle 11g R2 By: datadrums on Wed, 18 August 2010	3	1938	Sun, 12 September 2010 18:45 By: Kevin Meade
Is there a better way to rewrite this query? Oracle 11g , Linux By: kvignes1 on Wed, 08 September 2010	8	838	Sun, 12 September 2010 18:13 By: Kevin Meade
Obtaining 10046 Wait Events for Parallel Slaves 10.2.0.4 / Sparc / Solaris By: rleishman on Fri, 10 September 2010	0	4639	Fri, 10 September 2010 01:42 By: rleishman