OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning
Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

		How many times Queries/DML statement run over a week. By: Oraclist on Tue, 22 July 2008 06:58
		Re: How many times Queries/DML statement run over a week. By: Michel Cadot on Tue, 22 July 2008 07:16
		Re: How many times Queries/DML statement run over a week. By: Oraclist on Tue, 22 July 2008 07:24
		Re: How many times Queries/DML statement run over a week. By: Michel Cadot on Tue, 22 July 2008 08:29

		Need help to Optimize this query By: srajan on Mon, 21 July 2008 10:19
		Re: Need help to Optimize this query By: BlackSwan on Mon, 21 July 2008 10:22
		Re: Need help to Optimize this query By: rajatratewal on Tue, 22 July 2008 05:49

		How to enable Bitmap Index By: Swadhin on Mon, 21 July 2008 07:59
		Re: How to enable Bitmap Index By: Michel Cadot on Mon, 21 July 2008 08:07

		oracle9i By: shrinika on Fri, 18 July 2008 15:26
		Re: oracle9i By: BlackSwan on Fri, 18 July 2008 15:43
		Re: oracle9i By: shrinika on Sat, 19 July 2008 15:21
		Re: oracle9i By: Michel Cadot on Sun, 20 July 2008 00:55

		maximum number of process exceeded By: jimit_shaili on Sat, 19 July 2008 02:12
		Re: maximum number of process exceeded By: jimit_shaili on Sat, 19 July 2008 02:15
		Re: maximum number of process exceeded By: Michel Cadot on Sat, 19 July 2008 02:17
		Re: maximum number of process exceeded By: jimit_shaili on Sat, 19 July 2008 03:07
		Re: maximum number of process exceeded By: Michel Cadot on Sat, 19 July 2008 03:34

user I/O and read by other session waits

By: kumar.joy on Fri, 18 July 2008 17:39

		query tuning By: vickey_sagar1 on Mon, 14 July 2008 07:07
		Re: query tuning By: Kriptas on Mon, 14 July 2008 14:02
		Re: query tuning By: rleishman on Mon, 14 July 2008 22:08
		Re: query tuning By: Kriptas on Mon, 14 July 2008 22:19
		Re: query tuning By: vickey_sagar1 on Tue, 15 July 2008 07:42
		Re: query tuning By: Kriptas on Tue, 15 July 2008 11:25
		Re: query tuning By: BlackSwan on Tue, 15 July 2008 11:34
		Re: query tuning By: vickey_sagar1 on Fri, 18 July 2008 06:42
		Re: query tuning By: BlackSwan on Fri, 18 July 2008 09:24
		Re: query tuning By: Kriptas on Fri, 18 July 2008 12:11

		Effect on physical standby database By: jimit_shaili on Fri, 18 July 2008 00:15
		Re: Effect on physical standby database By: Michel Cadot on Fri, 18 July 2008 00:44

		replacing with single update statement By: kumarbo7 on Wed, 16 July 2008 19:49
		Re: replacing with single update statement By: BlackSwan on Wed, 16 July 2008 20:03
		Re: replacing with single update statement By: kumarbo7 on Wed, 16 July 2008 20:20
		Re: replacing with single update statement By: BlackSwan on Wed, 16 July 2008 20:34
		Re: replacing with single update statement By: kumarbo7 on Wed, 16 July 2008 21:23
		Re: replacing with single update statement By: Kriptas on Wed, 16 July 2008 23:24
		Re: replacing with single update statement By: kumarbo7 on Thu, 17 July 2008 06:42
		Re: replacing with single update statement By: Kriptas on Thu, 17 July 2008 19:15
		Re: replacing with single update statement By: kumarbo7 on Thu, 17 July 2008 22:40

		Oracle runs SLOWER on XEON than Pentium Dual By: tranzicija on Thu, 17 July 2008 02:59
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: JRowbottom on Thu, 17 July 2008 03:03
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: JRowbottom on Thu, 17 July 2008 03:06
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: tahpush on Thu, 17 July 2008 03:43
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: tranzicija on Thu, 17 July 2008 04:44
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: JRowbottom on Thu, 17 July 2008 05:21
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: JRowbottom on Thu, 17 July 2008 05:22
		Re: Oracle runs SLOWER on XEON than Pentium Dual By: tranzicija on Thu, 17 July 2008 08:09

		table caching By: manish.verma@sify.com on Tue, 15 July 2008 07:15
		Re: table caching By: Michel Cadot on Tue, 15 July 2008 07:46
		Re: table caching By: JRowbottom on Wed, 16 July 2008 07:32

		what are the various steps of query processing By: manish.verma@sify.com on Thu, 10 July 2008 06:42
		Re: what are the various steps of query processing By: Michel Cadot on Thu, 10 July 2008 07:06
		Re: what are the various steps of query processing By: manish.verma@sify.com on Tue, 15 July 2008 07:43
		Re: what are the various steps of query processing By: Michel Cadot on Tue, 15 July 2008 11:36

		Index Partitioning By: jimit_shaili on Mon, 14 July 2008 01:11
		Re: Index Partitioning By: Michel Cadot on Mon, 14 July 2008 01:28
		Re: Index Partitioning By: jimit_shaili on Mon, 14 July 2008 04:18
		Re: Index Partitioning By: Michel Cadot on Mon, 14 July 2008 05:03
		Re: Index Partitioning By: jimit_shaili on Mon, 14 July 2008 05:31
		Re: Index Partitioning By: Michel Cadot on Mon, 14 July 2008 05:35
		Re: Index Partitioning By: jimit_shaili on Tue, 15 July 2008 00:47
		Re: Index Partitioning By: Michel Cadot on Tue, 15 July 2008 00:58
		Re: Index Partitioning By: jimit_shaili on Tue, 15 July 2008 02:21
		Re: Index Partitioning By: Michel Cadot on Tue, 15 July 2008 02:39

		pls help to reduce some loop By: simplesanju on Thu, 10 July 2008 00:53
		Re: pls help to reduce some loop By: BlackSwan on Thu, 10 July 2008 00:58
		Re: pls help to reduce some loop By: Michel Cadot on Thu, 10 July 2008 01:06
		Re: pls help to reduce some loop By: simplesanju on Thu, 10 July 2008 01:12
		Re: pls help to reduce some loop By: simplesanju on Thu, 10 July 2008 01:29
		Re: pls help to reduce some loop By: Michel Cadot on Thu, 10 July 2008 02:36
		Re: pls help to reduce some loop By: BlackSwan on Thu, 10 July 2008 01:14
		Re: pls help to reduce some loop By: rleishman on Thu, 10 July 2008 02:47
		Re: pls help to reduce some loop By: orafan23 on Thu, 10 July 2008 05:57
		Re: pls help to reduce some loop By: Kevin Meade on Thu, 10 July 2008 19:35
		Re: pls help to reduce some loop By: Kevin Meade on Thu, 10 July 2008 20:32
		Re: pls help to reduce some loop By: simplesanju on Thu, 10 July 2008 23:23
		Re: pls help to reduce some loop By: Kevin Meade on Fri, 11 July 2008 10:25
		Re: pls help to reduce some loop By: simplesanju on Mon, 14 July 2008 03:05
		Re: pls help to reduce some loop By: TheSingerman on Fri, 11 July 2008 22:23
		Re: pls help to reduce some loop By: Kevin Meade on Mon, 14 July 2008 10:40
		Re: pls help to reduce some loop By: simplesanju on Mon, 14 July 2008 23:11

		Oracle Query Tuning By: hedonist123 on Mon, 14 July 2008 10:45
		Re: Oracle Query Tuning By: BlackSwan on Mon, 14 July 2008 10:52
		Re: Oracle Query Tuning By: Kriptas on Mon, 14 July 2008 14:08
		Re: Oracle Query Tuning By: rleishman on Mon, 14 July 2008 21:59

		Nasty query re-write By: svguerin3 on Tue, 24 June 2008 10:39
		Re: Nasty query re-write By: Michel Cadot on Tue, 24 June 2008 10:43
		Re: Nasty query re-write By: S.Rajaram on Tue, 24 June 2008 11:00
		Re: Nasty query re-write By: svguerin3 on Tue, 24 June 2008 11:15
		Re: Nasty query re-write By: Michel Cadot on Tue, 24 June 2008 11:20
		Re: Nasty query re-write By: svguerin3 on Tue, 24 June 2008 11:54
		Re: Nasty query re-write By: rleishman on Tue, 24 June 2008 21:55
		Re: Nasty query re-write By: svguerin3 on Tue, 24 June 2008 23:46
		Re: Nasty query re-write By: rleishman on Wed, 25 June 2008 01:05
		Re: Nasty query re-write By: svguerin3 on Wed, 25 June 2008 10:27
		Re: Nasty query re-write By: svguerin3 on Fri, 27 June 2008 09:08
		Re: Nasty query re-write By: rleishman on Mon, 30 June 2008 04:22
		Re: Nasty query re-write By: svguerin3 on Mon, 30 June 2008 13:10
		Re: Nasty query re-write By: svguerin3 on Tue, 24 June 2008 11:21
		Re: Nasty query re-write By: BlackSwan on Mon, 30 June 2008 13:20
		Re: Nasty query re-write By: svguerin3 on Mon, 30 June 2008 13:29
		Re: Nasty query re-write By: BlackSwan on Mon, 30 June 2008 13:46
		Re: Nasty query re-write By: svguerin3 on Mon, 30 June 2008 15:15
		Re: Nasty query re-write By: rleishman on Mon, 30 June 2008 23:40
		Re: Nasty query re-write By: svguerin3 on Mon, 30 June 2008 23:54
		Re: Nasty query re-write By: svguerin3 on Tue, 01 July 2008 15:55
		Re: Nasty query re-write By: rleishman on Tue, 01 July 2008 22:20
		Re: Nasty query re-write By: svguerin3 on Thu, 03 July 2008 12:39
		Re: Nasty query re-write By: rleishman on Sat, 05 July 2008 02:52
		Re: Nasty query re-write By: Kevin Meade on Sat, 12 July 2008 21:42
		Re: Nasty query re-write By: svguerin3 on Mon, 14 July 2008 10:27

		query performance By: Altitude on Mon, 14 July 2008 04:46
		Re: query performance By: pablolee on Mon, 14 July 2008 07:59

		how to force parallel to subquery of select statement ? By: eyuval26 on Sun, 13 July 2008 03:41
		Re: how to force parallel to subquery of select statement ? By: Michel Cadot on Sun, 13 July 2008 05:29
		Re: how to force parallel to subquery of select statement ? By: eyuval26 on Sun, 13 July 2008 05:36
		Re: how to force parallel to subquery of select statement ? By: Michel Cadot on Sun, 13 July 2008 08:41
		Re: how to force parallel to subquery of select statement ? By: Kevin Meade on Sun, 13 July 2008 09:51
		Re: how to force parallel to subquery of select statement ? By: eyuval26 on Sun, 13 July 2008 10:05
		Re: how to force parallel to subquery of select statement ? By: coleing on Sun, 13 July 2008 16:27
		Re: how to force parallel to subquery of select statement ? By: rleishman on Mon, 14 July 2008 03:13

		Create Index ? By: ArvindBhope on Sat, 12 July 2008 06:33
		Re: Create Index ? By: rleishman on Sat, 12 July 2008 06:46
		Re: Create Index ? By: Michel Cadot on Sat, 12 July 2008 10:07
		Re: Create Index ? By: Kevin Meade on Sun, 13 July 2008 10:09

		GATHERING STATISTICS By: acarella on Fri, 11 July 2008 11:23
		Re: GATHERING STATISTICS By: BlackSwan on Fri, 11 July 2008 11:27
		Re: GATHERING STATISTICS By: acarella on Fri, 11 July 2008 11:30
		Re: GATHERING STATISTICS By: Michel Cadot on Fri, 11 July 2008 11:37
		COMPUTE STATISTICS By: acarella on Fri, 11 July 2008 11:35
		Re: GATHERING STATISTICS By: BlackSwan on Fri, 11 July 2008 11:36
		Re: GATHERING STATISTICS By: Kriptas on Sat, 12 July 2008 17:46

		Bind variable in a data warehouse By: stegau on Wed, 09 July 2008 15:11
		Re: Bind variable in a data warehouse By: BlackSwan on Wed, 09 July 2008 15:19
		Re: Bind variable in a data warehouse By: rleishman on Wed, 09 July 2008 22:20
		Re: Bind variable in a data warehouse By: stegau on Thu, 10 July 2008 12:34
		Re: Bind variable in a data warehouse By: rleishman on Fri, 11 July 2008 07:54

		Query running slow By: poratips on Wed, 02 July 2008 20:08
		Re: Query running slow By: Michel Cadot on Wed, 02 July 2008 23:30
		Re: Query running slow By: poratips on Thu, 03 July 2008 00:13
		Re: Query running slow By: Michel Cadot on Thu, 03 July 2008 00:52
		Re: Query running slow By: rleishman on Thu, 03 July 2008 03:24
		Re: Query running slow By: poratips on Thu, 03 July 2008 07:58
		Re: Query running slow By: rleishman on Sat, 05 July 2008 02:56
		Re: Query running slow By: Kriptas on Sat, 05 July 2008 14:32
		Re: Query running slow By: poratips on Thu, 10 July 2008 13:35

		ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: ashish1986 on Wed, 09 July 2008 05:27
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: rleishman on Wed, 09 July 2008 22:31
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: Michel Cadot on Wed, 09 July 2008 23:13
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: ashish1986 on Wed, 09 July 2008 23:34
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: Michel Cadot on Wed, 09 July 2008 23:43
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: ashish1986 on Wed, 09 July 2008 23:51
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: Michel Cadot on Wed, 09 July 2008 23:55
		Re: ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded By: JRowbottom on Thu, 10 July 2008 05:54

		SQL Tuning (Multicolumn Range Parttiion Pruning) By: sujitdba on Tue, 08 July 2008 09:13
		Re: SQL Tuning (Multicolumn Range Parttiion Pruning) By: JRowbottom on Tue, 08 July 2008 09:59
		Re: SQL Tuning (Multicolumn Range Parttiion Pruning) By: sujitdba on Wed, 09 July 2008 10:52
		Re: SQL Tuning (Multicolumn Range Parttiion Pruning) By: JRowbottom on Wed, 09 July 2008 11:38

		Query plan change By: jinga on Wed, 09 July 2008 07:18
		Re: Query plan change By: Michel Cadot on Wed, 09 July 2008 07:40
		Re: Query plan change By: jinga on Wed, 09 July 2008 08:06
		Re: Query plan change By: tahpush on Wed, 09 July 2008 08:30

		update is slow with CLOB data By: shrinika on Sat, 28 June 2008 23:11
		Re: update is slow with CLOB data By: BlackSwan on Sat, 28 June 2008 23:21
		Re: update is slow with CLOB data By: shrinika on Tue, 01 July 2008 17:30
		Re: update is slow with CLOB data By: BlackSwan on Tue, 01 July 2008 17:39
		Re: update is slow with CLOB data By: shrinika on Tue, 01 July 2008 17:42
		Re: update is slow with CLOB data By: shrinika on Tue, 01 July 2008 18:08
		Re: update is slow with CLOB data By: BlackSwan on Tue, 01 July 2008 18:37
		Re: update is slow with CLOB data By: shrinika on Tue, 01 July 2008 21:08
		Re: update is slow with CLOB data By: shrinika on Wed, 02 July 2008 05:31
		Re: update is slow with CLOB data By: shrinika on Tue, 08 July 2008 10:47

		Optimizing the Query By: itroome on Tue, 08 July 2008 07:32
		Re: Optimizing the Query By: Michel Cadot on Tue, 08 July 2008 07:34

		What do Oracle waits mean By: lunaut on Mon, 07 July 2008 13:26
		Re: What do Oracle waits mean By: BlackSwan on Mon, 07 July 2008 13:29
		Re: What do Oracle waits mean By: Michel Cadot on Mon, 07 July 2008 14:17

		Materialized view not getting used By: vkumar on Mon, 07 July 2008 09:25
		Re: Materialized view not getting used By: BlackSwan on Mon, 07 July 2008 09:46

		UNION causing slow performance By: svguerin3 on Sat, 05 July 2008 01:07
		Re: UNION causing slow performance By: Michel Cadot on Sat, 05 July 2008 01:50
		Re: UNION causing slow performance By: svguerin3 on Sat, 05 July 2008 02:17
		Re: UNION causing slow performance By: rleishman on Sat, 05 July 2008 02:49
		Re: UNION causing slow performance By: Michel Cadot on Sat, 05 July 2008 02:59
		Re: UNION causing slow performance By: svguerin3 on Sat, 05 July 2008 15:18
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 14:43
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 15:55
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 15:58
		Re: UNION causing slow performance By: svguerin3 on Sat, 05 July 2008 17:24
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 18:04
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 18:14
		Re: UNION causing slow performance By: Kriptas on Sat, 05 July 2008 18:30
		Re: UNION causing slow performance By: svguerin3 on Sat, 05 July 2008 19:48
		Re: UNION causing slow performance By: rleishman on Sun, 06 July 2008 00:45
		Re: UNION causing slow performance By: svguerin3 on Sun, 06 July 2008 03:48
		Re: UNION causing slow performance By: Kriptas on Sun, 06 July 2008 01:51
		Re: UNION causing slow performance By: Kriptas on Sun, 06 July 2008 04:22
		Re: UNION causing slow performance By: rleishman on Sun, 06 July 2008 06:11
		Re: UNION causing slow performance By: rleishman on Sun, 06 July 2008 07:21
		Re: UNION causing slow performance By: Kriptas on Sun, 06 July 2008 06:22
		Re: UNION causing slow performance By: Kriptas on Sun, 06 July 2008 08:27

		Query taking much time By: virmahi on Thu, 03 July 2008 04:49
		Re: Query taking much time By: Frank on Thu, 03 July 2008 04:55
		Re: Query taking much time By: virmahi on Thu, 03 July 2008 05:19
		Re: Query taking much time By: JRowbottom on Thu, 03 July 2008 05:25
		Re: Query taking much time By: virmahi on Thu, 03 July 2008 05:34
		Re: Query taking much time By: JRowbottom on Thu, 03 July 2008 05:39
		Re: Query taking much time By: virmahi on Thu, 03 July 2008 05:54
		Re: Query taking much time By: S.Rajaram on Thu, 03 July 2008 07:21
		Re: Query taking much time By: virmahi on Thu, 03 July 2008 23:32
		Re: Query taking much time By: virmahi on Fri, 04 July 2008 02:42
		Re: Query taking much time By: JRowbottom on Fri, 04 July 2008 02:45
		Re: Query taking much time By: virmahi on Fri, 04 July 2008 03:02
		Re: Query taking much time By: JRowbottom on Fri, 04 July 2008 03:12
		Re: Query taking much time By: Frank on Fri, 04 July 2008 03:21
		<more>
		Re: Query taking much time By: Kriptas on Sat, 05 July 2008 14:17

		temp space estimation ? By: ArvindBhope on Sat, 05 July 2008 09:33
		Re: temp space estimation ? By: BlackSwan on Sat, 05 July 2008 10:08
		Re: temp space estimation ? By: Michel Cadot on Sat, 05 July 2008 10:18
		Re: temp space estimation ? By: ArvindBhope on Sat, 05 July 2008 10:32
		Re: temp space estimation ? By: Michel Cadot on Sat, 05 July 2008 10:44

		Oracle10g very slow on windows2003 server By: safhanghauri on Sat, 05 July 2008 06:47
		Re: Oracle10g very slow on windows2003 server By: BlackSwan on Sat, 05 July 2008 08:13

		How heavy an AWR snapshot is By: lunaut on Wed, 02 July 2008 18:07
		Re: How heavy an AWR snapshot is By: BlackSwan on Wed, 02 July 2008 18:19
		Re: How heavy an AWR snapshot is By: lunaut on Thu, 03 July 2008 14:42
		Re: How heavy an AWR snapshot is By: alanm on Fri, 04 July 2008 06:03

		Problem sorting and inserting huge data (merged) By: ravashingravi on Wed, 02 July 2008 23:04
		Re: Problem sorting huge data By: BlackSwan on Wed, 02 July 2008 23:05
		Problem sorting and inserting huge data By: ravashingravi on Wed, 02 July 2008 23:27
		Re: Problem sorting and inserting huge data By: Michel Cadot on Thu, 03 July 2008 00:49
		Re: Problem sorting and inserting huge data By: rleishman on Thu, 03 July 2008 03:41
		Re: Problem sorting and inserting huge data By: Michel Cadot on Wed, 02 July 2008 23:39
		Re: Problem sorting huge data By: flyboy on Wed, 02 July 2008 23:44
		Re: Problem sorting and inserting huge data (merged) By: coleing on Thu, 03 July 2008 17:45

Generate SQL Statements from 10046 trace file

By: jochenbandhauer on Thu, 03 July 2008 11:26

		free command By: mafc73 on Wed, 02 July 2008 07:00
		Re: free command By: BlackSwan on Wed, 02 July 2008 11:20
		Re: free command By: mafc73 on Thu, 03 July 2008 03:10
		Re: free command By: BlackSwan on Thu, 03 July 2008 08:53

		Query running slow By: areeb on Tue, 01 July 2008 13:22
		Re: Query running slow By: BlackSwan on Tue, 01 July 2008 13:39

		multiple dbwr processes and multiple archver process By: M.Shakeel Azeem on Fri, 11 January 2008 02:25
		Re: multiple dbwr processes and multiple archver process By: Michel Cadot on Fri, 11 January 2008 02:40
		Re: multiple dbwr processes and multiple archver process By: sophia.catfish on Tue, 01 July 2008 01:44
		Re: multiple dbwr processes and multiple archver process By: alanm on Tue, 01 July 2008 07:25

		Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008 05:04
		Re: Best way to partition my table By: Kriptas on Sun, 29 June 2008 07:22
		Re: Best way to partition my table By: coleing on Sun, 29 June 2008 16:24
		Re: Best way to partition my table By: rleishman on Sun, 29 June 2008 18:14
		Re: Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008 19:23
		Re: Best way to partition my table By: rleishman on Mon, 30 June 2008 03:55
		Re: Best way to partition my table By: coleing on Mon, 30 June 2008 16:32
		Re: Best way to partition my table By: rleishman on Mon, 30 June 2008 23:34

Pages (119): [ « ‹ 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Fri Jul 05 14:09:08 CDT 2024