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.

		Full table scan - Queries By: ashishkumarmahanta80 on Mon, 05 May 2014 07:51
		Re: Full table scan - Queries By: Roachcoach on Mon, 05 May 2014 08:28
		Re: Full table scan - Queries By: BlackSwan on Mon, 05 May 2014 08:49
		Re: Full table scan - Queries By: ashishkumarmahanta80 on Mon, 05 May 2014 19:54
		Re: Full table scan - Queries By: BlackSwan on Mon, 05 May 2014 20:25
		Re: Full table scan - Queries By: ashishkumarmahanta80 on Mon, 05 May 2014 23:39
		Re: Full table scan - Queries By: Lalit Kumar B on Tue, 06 May 2014 04:03

		After updating memory_target, performance is degraded By: ashishkumarmahanta80 on Mon, 28 April 2014 05:36
		Re: After updating memory_target, performance is degraded By: Lalit Kumar B on Mon, 28 April 2014 06:31
		Re: After updating memory_target, performance is degraded By: Michel Cadot on Mon, 28 April 2014 07:22
		Re: After updating memory_target, performance is degraded By: Lalit Kumar B on Mon, 28 April 2014 07:51
		Re: After updating memory_target, performance is degraded By: ashishkumarmahanta80 on Tue, 29 April 2014 02:41
		Re: After updating memory_target, performance is degraded By: Michel Cadot on Tue, 29 April 2014 03:11
		Re: After updating memory_target, performance is degraded By: ashishkumarmahanta80 on Wed, 30 April 2014 05:42
		Re: After updating memory_target, performance is degraded By: Michel Cadot on Mon, 28 April 2014 07:24

		performance Tuning By: ramchandru1989 on Tue, 22 April 2014 01:15
		Re: performance Tuning By: John Watson on Tue, 22 April 2014 01:20
		Re: performance Tuning By: flyboy on Tue, 22 April 2014 01:34
		Re: performance Tuning By: ramchandru1989 on Tue, 22 April 2014 01:55
		Re: performance Tuning By: John Watson on Tue, 22 April 2014 02:00
		Re: performance Tuning By: Kevin Meade on Tue, 29 April 2014 19:20

		ODI Performance issue with flat file By: giridhar123 on Fri, 25 April 2014 02:21
		Re: ODI Performance issue with flat file By: BlackSwan on Fri, 25 April 2014 07:35

		performance imapct on stats collection By: ravikanth_b on Thu, 24 April 2014 17:27
		Re: performance imapct on stats collection By: BlackSwan on Thu, 24 April 2014 17:53
		Re: performance imapct on stats collection By: ravikanth_b on Thu, 24 April 2014 18:10
		Re: performance imapct on stats collection By: BlackSwan on Thu, 24 April 2014 18:18
		Re: performance imapct on stats collection By: ravikanth_b on Thu, 24 April 2014 18:32
		Re: performance imapct on stats collection By: rleishman on Thu, 24 April 2014 18:53
		Re: performance imapct on stats collection By: ravikanth_b on Thu, 24 April 2014 19:37
		Re: performance imapct on stats collection By: BlackSwan on Thu, 24 April 2014 19:43
		Re: performance imapct on stats collection By: BlackSwan on Thu, 24 April 2014 18:56

		Need to Understand Explain plan By: na.dharma@gmail.com on Thu, 24 April 2014 00:22
		Re: Need to Understand Explain plan By: Michel Cadot on Thu, 24 April 2014 00:48
		Re: Need to Understand Explain plan By: cookiemonster on Thu, 24 April 2014 02:40

		Scripts to find Indexes which are candidate for Rebuild By: hitesh.bhatt on Tue, 22 April 2014 03:10
		Re: Scripts to find Indexes which are candidate for Rebuild By: Roachcoach on Tue, 22 April 2014 03:21
		Re: Scripts to find Indexes which are candidate for Rebuild By: hitesh.bhatt on Tue, 22 April 2014 03:42
		Re: Scripts to find Indexes which are candidate for Rebuild By: Roachcoach on Tue, 22 April 2014 03:46
		Re: Scripts to find Indexes which are candidate for Rebuild By: John Watson on Tue, 22 April 2014 04:20
		Re: Scripts to find Indexes which are candidate for Rebuild By: hitesh.bhatt on Tue, 22 April 2014 04:31
		Re: Scripts to find Indexes which are candidate for Rebuild By: Roachcoach on Tue, 22 April 2014 09:00
		Re: Scripts to find Indexes which are candidate for Rebuild By: BlackSwan on Tue, 22 April 2014 09:16
		Re: Scripts to find Indexes which are candidate for Rebuild By: hitesh.bhatt on Wed, 23 April 2014 03:23
		Re: Scripts to find Indexes which are candidate for Rebuild By: BlackSwan on Wed, 23 April 2014 08:17

		Please help me for getting best execution plan as my create view script is ... By: msol25 on Tue, 25 March 2014 04:20
		Re: Please help me for getting best execution plan as my create view script... By: cookiemonster on Tue, 25 March 2014 04:37
		Re: Please help me for getting best execution plan as my create view script... By: msol25 on Tue, 25 March 2014 04:42
		Re: Please help me for getting best execution plan as my create view script... By: Roachcoach on Tue, 25 March 2014 04:47
		Re: Please help me for getting best execution plan as my create view script... By: John Watson on Tue, 25 March 2014 05:06
		Re: Please help me for getting best execution plan as my create view script... By: BlackSwan on Tue, 22 April 2014 09:52

		Archive log issues By: patdev on Thu, 17 April 2014 12:06
		Re: Archive log issues By: BlackSwan on Thu, 17 April 2014 12:48

		Would making indexes "invisible" be the right approach for this? By: ThomasG on Wed, 26 March 2014 06:02
		Re: Would making indexes "invisible" be the right approach for th... By: Roachcoach on Wed, 26 March 2014 06:17
		Re: Would making indexes "invisible" be the right approach for th... By: ThomasG on Wed, 26 March 2014 08:01
		Re: Would making indexes "invisible" be the right approach for th... By: ThomasG on Tue, 15 April 2014 12:52
		Re: Would making indexes "invisible" be the right approach for th... By: Lalit Kumar B on Thu, 17 April 2014 04:30

		query optimization phase By: Johnny_aig on Tue, 15 April 2014 13:18
		Re: query optimization phase By: Lalit Kumar B on Wed, 16 April 2014 01:06
		Re: query optimization phase By: Johnny_aig on Wed, 16 April 2014 03:35
		Re: query optimization phase By: Lalit Kumar B on Wed, 16 April 2014 03:58
		Re: query optimization phase By: Johnny_aig on Wed, 16 April 2014 07:54
		Re: query optimization phase By: cookiemonster on Wed, 16 April 2014 08:08
		Re: query optimization phase By: Lalit Kumar B on Wed, 16 April 2014 08:21
		Re: query optimization phase By: Johnny_aig on Wed, 16 April 2014 08:39
		Re: query optimization phase By: Lalit Kumar B on Wed, 16 April 2014 08:49

		Can I instruct Oracle 11g to deliberately delay query completion? By: jvanh on Fri, 11 April 2014 10:53
		Re: Can I instruct Oracle 11g to deliberately delay query completion? By: John Watson on Fri, 11 April 2014 11:01
		Re: Can I instruct Oracle 11g to deliberately delay query completion? By: Roachcoach on Mon, 14 April 2014 02:24
		Re: Can I instruct Oracle 11g to deliberately delay query completion? By: jvanh on Tue, 15 April 2014 04:55

		Its confusing me lot.... By: harpreetsinghkup on Fri, 11 April 2014 10:31
		Re: Its confusing me lot.... By: Michel Cadot on Fri, 11 April 2014 10:46
		Re: Its confusing me lot.... By: harpreetsinghkup on Fri, 11 April 2014 11:03
		Re: Its confusing me lot.... By: BlackSwan on Fri, 11 April 2014 11:46
		Re: Its confusing me lot.... By: Roachcoach on Mon, 14 April 2014 02:29
		Re: Its confusing me lot.... By: Michel Cadot on Fri, 11 April 2014 12:17

		enq: TM - contention By: rishwinger on Wed, 09 April 2014 01:48
		Re: enq: TM - contention By: John Watson on Wed, 09 April 2014 01:53
		Re: enq: TM - contention By: rishwinger on Wed, 09 April 2014 02:36
		Re: enq: TM - contention By: John Watson on Wed, 09 April 2014 02:43
		Re: enq: TM - contention By: rishwinger on Wed, 09 April 2014 02:46
		Re: enq: TM - contention By: John Watson on Wed, 09 April 2014 02:50
		Re: enq: TM - contention By: John Watson on Wed, 09 April 2014 02:46
		Re: enq: TM - contention By: Michel Cadot on Wed, 09 April 2014 03:29
		Re: enq: TM - contention By: rishwinger on Wed, 09 April 2014 03:44
		Re: enq: TM - contention By: John Watson on Wed, 09 April 2014 03:54
		Re: enq: TM - contention By: rishwinger on Wed, 09 April 2014 04:45
		Re: enq: TM - contention By: Michel Cadot on Wed, 09 April 2014 05:20
		Re: enq: TM - contention By: rishwinger on Wed, 09 April 2014 05:44
		Re: enq: TM - contention By: Michel Cadot on Wed, 09 April 2014 05:52
		Re: enq: TM - contention By: Michel Cadot on Wed, 09 April 2014 05:53
		Re: enq: TM - contention By: Michel Cadot on Wed, 09 April 2014 02:33

		DATA BASE IS WORKING VERY SLOW By: arvindnegi2007 on Wed, 09 April 2014 02:11
		Re: DATA BASE IS WORKING VERY SLOW By: Michel Cadot on Wed, 09 April 2014 02:29

		COUNT STOPKEY issue -- performance issue By: balaji123 on Mon, 07 April 2014 23:21
		Re: COUNT STOPKEY issue -- performance issue By: Roachcoach on Tue, 08 April 2014 01:56
		Re: COUNT STOPKEY issue -- performance issue By: rleishman on Tue, 08 April 2014 19:51

		5M record insert takes two hours By: That Don Guy on Wed, 02 April 2014 16:29
		Re: 5M record insert takes two hours By: BlackSwan on Wed, 02 April 2014 16:43
		Re: 5M record insert takes two hours By: cookiemonster on Thu, 03 April 2014 02:30
		Re: 5M record insert takes two hours By: Kevin Meade on Fri, 04 April 2014 22:32
		Re: 5M record insert takes two hours By: d_seng on Mon, 07 April 2014 10:54

		Materialized View not being used on production (works elsewhere) By: d_seng on Wed, 26 February 2014 05:10
		Re: Materialized View not being used on production (works elsewhere) By: rleishman on Thu, 27 February 2014 23:55
		Re: Materialized View not being used on production (works elsewhere) By: rleishman on Thu, 27 February 2014 23:56
		Re: Materialized View not being used on production (works elsewhere) By: d_seng on Fri, 28 February 2014 09:57
		Re: Materialized View not being used on production (works elsewhere) By: d_seng on Thu, 27 March 2014 06:04
		Re: Materialized View not being used on production (works elsewhere) By: BlackSwan on Thu, 27 March 2014 06:10
		Re: Materialized View not being used on production (works elsewhere) By: d_seng on Thu, 27 March 2014 15:04
		Re: Materialized View not being used on production (works elsewhere) By: rleishman on Mon, 31 March 2014 20:00
		Re: Materialized View not being used on production (works elsewhere) By: Roachcoach on Tue, 01 April 2014 02:27
		Re: Materialized View not being used on production (works elsewhere) By: d_seng on Mon, 07 April 2014 10:32

		SQL performance By: huda_10@yahoo.co.in on Sun, 30 March 2014 04:27
		Re: SQL performance By: BlackSwan on Sun, 30 March 2014 09:15
		Re: SQL performance By: John Watson on Sun, 30 March 2014 11:36
		Re: SQL performance By: huda_10@yahoo.co.in on Mon, 31 March 2014 00:35
		Re: SQL performance By: huda_10@yahoo.co.in on Mon, 31 March 2014 00:38
		Re: SQL performance By: BlackSwan on Mon, 31 March 2014 00:43
		Re: SQL performance By: Littlefoot on Mon, 31 March 2014 00:53
		Re: SQL performance By: huda_10@yahoo.co.in on Tue, 01 April 2014 03:03
		Re: SQL performance By: huda_10@yahoo.co.in on Tue, 01 April 2014 03:04
		Re: SQL performance By: huda_10@yahoo.co.in on Tue, 01 April 2014 03:05
		Re: SQL performance By: Kevin Meade on Wed, 02 April 2014 00:02
		Re: SQL performance By: John Watson on Wed, 02 April 2014 01:41
		Re: SQL performance By: huda_10@yahoo.co.in on Wed, 02 April 2014 07:18
		Re: SQL performance By: michael_bialik on Thu, 03 April 2014 05:32

		elapsed_time_delta in dba_hist_sqlstat By: VIP2013 on Wed, 26 March 2014 06:25
		Re: elapsed_time_delta in dba_hist_sqlstat By: VIP2013 on Thu, 27 March 2014 10:07

		Best Design for batch processing using BLOB Types By: luxofmcc on Tue, 25 March 2014 14:41
		Re: Best Design for batch processing using BLOB Types By: BlackSwan on Tue, 25 March 2014 14:43

		sql result cache for improving the performance (merged 4) By: kiranrathodkr916 on Sat, 22 March 2014 03:05
		Re: sql result cache for improving the performance By: John Watson on Sat, 22 March 2014 03:36
		Re: sql result cache for improving the performance By: Michel Cadot on Sat, 22 March 2014 03:39
		Re: sql result cache for improving the performance By: kiranrathodkr916 on Sat, 22 March 2014 08:54
		Re: sql result cache for improving the performance By: BlackSwan on Sat, 22 March 2014 09:02
		What is your experience with Oracle's result caching feature? By: kiranrathodkr916 on Sun, 23 March 2014 08:28
		Re: What is your experience with Oracle's result caching feature? By: Michel Cadot on Sun, 23 March 2014 09:48
		Re: What is your experience with Oracle's result caching feature? By: BlackSwan on Sun, 23 March 2014 09:53
		Re: What is your experience with Oracle's result caching feature? By: kiranrathodkr916 on Sun, 23 March 2014 10:04
		Re: What is your experience with Oracle's result caching feature? By: kiranrathodkr916 on Sun, 23 March 2014 10:07
		Re: What is your experience with Oracle's result caching feature? By: BlackSwan on Sun, 23 March 2014 10:14
		no improvement using result cache By: ashwanth77 on Mon, 24 March 2014 03:34
		Re: no improvement using result cahce By: ashwanth77 on Mon, 24 March 2014 03:43
		Re: no improvement using result cahce By: John Watson on Mon, 24 March 2014 03:56
		Re: no improvement using result cahce By: ashwanth77 on Mon, 24 March 2014 04:02
		Re: no improvement using result cahce By: Michel Cadot on Mon, 24 March 2014 04:44
		Re: no improvement using result cahce By: ashwanth77 on Mon, 24 March 2014 04:59
		why isn't my result cache not working? By: ashwanth77 on Tue, 25 March 2014 01:42
		Re: why isn't my result cache not working? By: John Watson on Tue, 25 March 2014 01:57
		Re: why isn't my result cache not working? By: ashwanth77 on Tue, 25 March 2014 02:52
		Re: why isn't my result cache not working? By: John Watson on Tue, 25 March 2014 03:03
		Re: why isn't my result cache not working? By: ashwanth77 on Tue, 25 March 2014 05:15

		Use of Hints in Oracle 11g to get desired Execution Plan By: rekha.singhal@tcs.com on Thu, 20 March 2014 03:09
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: John Watson on Thu, 20 March 2014 03:41
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: LNossov on Thu, 20 March 2014 13:51
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: rekha.singhal@tcs.com on Thu, 20 March 2014 23:48
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: John Watson on Fri, 21 March 2014 02:11
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: rekha.singhal@tcs.com on Fri, 21 March 2014 02:23
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: Kevin Meade on Sat, 22 March 2014 19:20
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: Kevin Meade on Sun, 23 March 2014 21:54
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: Kevin Meade on Sun, 23 March 2014 22:20
		Re: Use of Hints in Oracle 11g to get desired Execution Plan By: Kevin Meade on Mon, 24 March 2014 00:29

		statement with big cost By: Roger22 on Fri, 21 March 2014 05:17
		Re: statement with big cost By: cookiemonster on Fri, 21 March 2014 05:30
		Re: statement with big cost By: Roger22 on Fri, 21 March 2014 05:36
		Re: statement with big cost By: Roger22 on Fri, 21 March 2014 05:37
		Re: statement with big cost By: cookiemonster on Fri, 21 March 2014 05:46
		Re: statement with big cost By: Roger22 on Fri, 21 March 2014 07:08
		Re: statement with big cost By: cookiemonster on Fri, 21 March 2014 08:46
		Re: statement with big cost By: Roger22 on Fri, 21 March 2014 09:05
		Re: statement with big cost By: BlackSwan on Fri, 21 March 2014 09:08
		Re: statement with big cost By: cookiemonster on Fri, 21 March 2014 09:18

		session uga memory By: ashu205 on Tue, 18 March 2014 07:33
		Re: session uga memory By: BlackSwan on Wed, 19 March 2014 18:42

		What does "session uga memory"/"session uga memory max"... By: Kevin Meade on Tue, 18 March 2014 05:21
		Re: What does "session uga memory"/"session uga memory max&q... By: cookiemonster on Tue, 18 March 2014 05:26
		Re: What does "session uga memory"/"session uga memory max&q... By: Kevin Meade on Tue, 18 March 2014 05:37
		Re: What does "session uga memory"/"session uga memory max&q... By: Kevin Meade on Tue, 18 March 2014 05:49
		Re: What does "session uga memory"/"session uga memory max&q... By: Kevin Meade on Tue, 18 March 2014 06:09

		SQL Execution Runtime Measure By: ind9 on Fri, 14 March 2014 17:54
		Re: SQL Execution Runtime Measure By: John Watson on Sat, 15 March 2014 02:25
		Re: SQL Execution Runtime Measure By: ind9 on Sat, 15 March 2014 03:33
		Re: SQL Execution Runtime Measure By: John Watson on Sat, 15 March 2014 05:45

		What is the most expensive dml transaction, insert, update, delete? By: steves on Sun, 24 March 2013 03:37
		Re: What is the most expensive dml transaction, insert, update, delete? By: Michel Cadot on Sun, 24 March 2013 04:08
		Re: What is the most expensive dml transaction, insert, update, delete? By: steves on Sun, 24 March 2013 04:27
		Re: What is the most expensive dml transaction, insert, update, delete? By: Michel Cadot on Sun, 24 March 2013 06:04
		Re: What is the most expensive dml transaction, insert, update, delete? By: steves on Sun, 24 March 2013 06:16
		Re: What is the most expensive dml transaction, insert, update, delete? By: rleishman on Mon, 25 March 2013 21:40
		Re: What is the most expensive dml transaction, insert, update, delete? By: Michel Cadot on Tue, 26 March 2013 01:24
		Re: What is the most expensive dml transaction, insert, update, delete? By: youngryand on Fri, 14 March 2014 12:48
		Re: What is the most expensive dml transaction, insert, update, delete? By: BlackSwan on Fri, 14 March 2014 12:53
		Re: What is the most expensive dml transaction, insert, update, delete? By: youngryand on Fri, 14 March 2014 13:30
		Re: What is the most expensive dml transaction, insert, update, delete? By: John Watson on Fri, 14 March 2014 15:25
		Re: What is the most expensive dml transaction, insert, update, delete? By: youngryand on Fri, 14 March 2014 17:49
		Re: What is the most expensive dml transaction, insert, update, delete? By: Michel Cadot on Fri, 14 March 2014 13:01

		Sql Tuning Advisor - Privileges (sqltrpt.sql) By: hitesh.bhatt on Thu, 13 March 2014 22:35
		Re: Sql Tuning Advisor - Privileges (sqltrpt.sql) By: BlackSwan on Thu, 13 March 2014 22:41
		Re: Sql Tuning Advisor - Privileges (sqltrpt.sql) By: hitesh.bhatt on Thu, 13 March 2014 22:49

		Incorrect cardinalty estimate when using a local non-prefixed unique index By: John Watson on Fri, 07 March 2014 03:08
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: cookiemonster on Fri, 07 March 2014 03:13
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: John Watson on Fri, 07 March 2014 03:23
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: cookiemonster on Fri, 07 March 2014 05:47
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: John Watson on Fri, 07 March 2014 12:26
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: John Watson on Fri, 07 March 2014 12:37
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: hkchital on Tue, 11 March 2014 03:38
		Re: Incorrect cardinalty estimate when using a local non-prefixed unique in... By: rleishman on Thu, 13 March 2014 20:04

		SQL Repair By: younusc on Mon, 10 March 2014 10:50
		Re: SQL Repair By: John Watson on Mon, 10 March 2014 11:04
		Re: SQL Repair By: younusc on Tue, 11 March 2014 08:43
		Re: SQL Repair By: Markwillium on Thu, 13 March 2014 00:02

		database performance tuning By: likhonisrat on Tue, 11 March 2014 06:37
		Re: database performance tuning By: John Watson on Tue, 11 March 2014 06:42

		Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 21:42
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 21:44
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 21:50
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 21:51
		Re: Query is taking long time By: BlackSwan on Sun, 09 March 2014 22:01
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 22:15
		Re: Query is taking long time By: BlackSwan on Sun, 09 March 2014 22:23
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 23:07
		Re: Query is taking long time By: BlackSwan on Sun, 09 March 2014 23:12
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 23:30
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 23:31
		Re: Query is taking long time By: Vivek_Garg on Sun, 09 March 2014 23:32
		Re: Query is taking long time By: John Watson on Mon, 10 March 2014 02:03
		Re: Query is taking long time By: nishant87 on Mon, 10 March 2014 04:35
		Re: Query is taking long time By: nishant87 on Mon, 10 March 2014 04:39
		Re: Query is taking long time By: nishant87 on Mon, 10 March 2014 04:41
		Re: Query is taking long time By: John Watson on Mon, 10 March 2014 04:49

		How to find throughput by query, session and database wise? By: suresh.wst on Sun, 02 March 2014 01:29
		Re: How to find throughput by query, session and database wise? By: John Watson on Sun, 02 March 2014 02:30
		Re: How to find throughput by query, session and database wise? By: BlackSwan on Sun, 02 March 2014 08:35
		Re: How to find throughput by query, session and database wise? By: suresh.wst on Tue, 04 March 2014 12:06
		Re: How to find throughput by query, session and database wise? By: BlackSwan on Tue, 04 March 2014 12:11
		Re: How to find throughput by query, session and database wise? By: suresh.wst on Tue, 04 March 2014 12:14
		Re: How to find throughput by query, session and database wise? By: BlackSwan on Tue, 04 March 2014 12:32
		Re: How to find throughput by query, session and database wise? By: John Watson on Tue, 04 March 2014 13:33
		Re: How to find throughput by query, session and database wise? By: Kevin Meade on Tue, 04 March 2014 22:01
		Re: How to find throughput by query, session and database wise? By: suresh.wst on Fri, 07 March 2014 01:41

		Difference in elapsed time of the query where everything in the trace seems... By: Vivek_Garg on Thu, 06 March 2014 06:46
		Re: Difference in elapsed time of the query where everything in the trace s... By: John Watson on Thu, 06 March 2014 07:09

		AWR - "db file parallel read" + "direct path read" wait... By: hitesh.bhatt on Tue, 18 February 2014 08:02
		Re: AWR - "db file parallel read" + "direct path read" ... By: BlackSwan on Tue, 18 February 2014 08:20
		Re: AWR - "db file parallel read" + "direct path read" ... By: Kevin Meade on Fri, 21 February 2014 20:46
		Re: AWR - "db file parallel read" + "direct path read" ... By: trantuananh24hg on Sun, 02 March 2014 22:03

		Oracle contain clause performance issue By: balaji123 on Fri, 28 February 2014 00:47
		Re: Oracle contain clause performance issue By: balaji123 on Fri, 28 February 2014 01:13
		Re: Oracle contain clause performance issue By: balaji123 on Fri, 28 February 2014 02:13

		Oracle Architecture By: gasbie on Sun, 23 February 2014 20:37
		Re: Oracle Architecture By: BlackSwan on Sun, 23 February 2014 20:55
		Re: Oracle Architecture By: John Watson on Mon, 24 February 2014 00:49

		AWR top events:: enq: TX - row lock contention By: hitesh.bhatt on Thu, 20 February 2014 06:43
		Re: AWR top events:: enq: TX - row lock contention By: John Watson on Thu, 20 February 2014 06:49
		Re: AWR top events:: enq: TX - row lock contention By: Kevin Meade on Fri, 21 February 2014 20:44

		Bloom filter joins By: Kevin Meade on Thu, 20 February 2014 07:15
		Re: Tuning query without where clause By: John Watson on Thu, 20 February 2014 14:02
		Re: Tuning query without where clause By: John Watson on Thu, 20 February 2014 14:04
		Re: Tuning query without where clause By: msol25 on Fri, 21 February 2014 05:56
		Re: Tuning query without where clause By: Kevin Meade on Fri, 21 February 2014 20:16

Pages (119): [ « ‹ 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sat Apr 20 03:00:06 CDT 2024