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.

		Merge join Cartesian and Buffer Sort By: trantuananh24hg on Tue, 30 December 2008 20:50
		Re: Merge join Cartesian and Buffer Sort By: rleishman on Tue, 30 December 2008 23:25
		Re: Merge join Cartesian and Buffer Sort By: trantuananh24hg on Wed, 31 December 2008 01:36
		Re: Merge join Cartesian and Buffer Sort By: rleishman on Thu, 01 January 2009 06:30

		Sql query performance By: huda10 on Mon, 29 December 2008 04:25
		Re: Sql query performance By: Michel Cadot on Mon, 29 December 2008 04:40
		Re: Sql query performance By: rleishman on Mon, 29 December 2008 05:51
		Re: Sql query performance By: huda10 on Mon, 29 December 2008 05:52
		Re: Sql query performance By: huda10 on Mon, 29 December 2008 05:53
		Re: Sql query performance By: rleishman on Mon, 29 December 2008 05:56
		Re: Sql query performance By: huda10 on Mon, 29 December 2008 05:57
		Re: Sql query performance By: rleishman on Mon, 29 December 2008 05:58
		Re: Sql query performance By: huda10 on Mon, 29 December 2008 06:09
		Re: Sql query performance By: huda10 on Mon, 29 December 2008 06:24
		Re: Sql query performance By: rleishman on Mon, 29 December 2008 20:57

		Fetch is taking too long By: srinivas4u2 on Mon, 22 December 2008 17:07
		Re: Fetch is taking too long By: rleishman on Mon, 22 December 2008 22:25
		Re: Fetch is taking too long By: srinivas4u2 on Tue, 23 December 2008 10:36
		Re: Fetch is taking too long By: srinivas4u2 on Wed, 24 December 2008 06:47
		Re: Fetch is taking too long By: rleishman on Thu, 25 December 2008 23:23
		Re: Fetch is taking too long By: srinivas4u2 on Mon, 29 December 2008 08:26

		Thread 1 cannot allocate new log By: suspect on Mon, 29 December 2008 03:05
		Re: Thread 1 cannot allocate new log By: tahpush on Mon, 29 December 2008 03:32
		Re: Thread 1 cannot allocate new log By: Frank Naude on Mon, 29 December 2008 03:42
		Re: Thread 1 cannot allocate new log By: suspect on Mon, 29 December 2008 03:59

		One query with two where Conditions on same column By: virmahi on Tue, 23 December 2008 04:03
		Re: One query with two where Conditions on same column By: JRowbottom on Tue, 23 December 2008 04:10
		Re: One query with two where Conditions on same column By: virmahi on Tue, 23 December 2008 04:59
		Re: One query with two where Conditions on same column By: rleishman on Tue, 23 December 2008 05:36
		Re: One query with two where Conditions on same column By: virmahi on Tue, 23 December 2008 05:48
		Re: One query with two where Conditions on same column By: virmahi on Wed, 24 December 2008 03:20
		Re: One query with two where Conditions on same column By: S.Rajaram on Wed, 24 December 2008 04:53
		Re: One query with two where Conditions on same column By: virmahi on Mon, 29 December 2008 03:09
		Re: One query with two where Conditions on same column By: S.Rajaram on Tue, 23 December 2008 05:38

		performance of delete/insert deteriorate over time By: Orna on Wed, 24 December 2008 09:59
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Wed, 24 December 2008 16:46
		Re: performance of delete/insert deteriorate over time By: Orna on Wed, 24 December 2008 16:55
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Wed, 24 December 2008 17:10
		Re: performance of delete/insert deteriorate over time By: Orna on Wed, 24 December 2008 18:25
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Wed, 24 December 2008 20:24
		Re: performance of delete/insert deteriorate over time By: Orna on Thu, 25 December 2008 05:31
		Re: performance of delete/insert deteriorate over time By: Orna on Fri, 26 December 2008 18:50
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Fri, 26 December 2008 18:56
		Re: performance of delete/insert deteriorate over time By: Orna on Fri, 26 December 2008 18:59
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Fri, 26 December 2008 19:08
		Re: performance of delete/insert deteriorate over time By: Orna on Fri, 26 December 2008 19:11
		Re: performance of delete/insert deteriorate over time By: Mahesh Rajendran on Fri, 26 December 2008 19:26
		Re: performance of delete/insert deteriorate over time By: rleishman on Sat, 27 December 2008 02:36
		Re: performance of delete/insert deteriorate over time By: Orna on Sat, 27 December 2008 06:37
		<more>
		Re: performance of delete/insert deteriorate over time By: michael_bialik on Sat, 27 December 2008 08:18
		Re: performance of delete/insert deteriorate over time By: Orna on Sat, 27 December 2008 17:48

		Left outer join taking more time By: srihari.gurram on Tue, 23 December 2008 03:21
		Re: Left outer join taking more time By: Frank Naude on Tue, 23 December 2008 03:23
		Re: Left outer join taking more time By: srihari.gurram on Tue, 23 December 2008 21:38
		Re: Left outer join taking more time By: srihari.gurram on Thu, 25 December 2008 21:05
		Re: Left outer join taking more time By: rleishman on Thu, 25 December 2008 22:58
		Re: Left outer join taking more time By: srihari.gurram on Fri, 26 December 2008 04:08
		Re: Left outer join taking more time By: Kevin Meade on Fri, 26 December 2008 09:21
		Re: Left outer join taking more time By: rleishman on Sat, 27 December 2008 02:43
		Re: Left outer join taking more time By: rleishman on Sat, 27 December 2008 02:51
		Re: Left outer join taking more time By: srihari.gurram on Sat, 27 December 2008 08:57
		Re: Left outer join taking more time By: Kevin Meade on Sat, 27 December 2008 11:18

		Query Rewrite to Utilize Materialized Views on a Remote Database By: gunalmel on Tue, 23 December 2008 10:42
		Re: Query Rewrite to Utilize Materialized Views on a Remote Database By: coleing on Tue, 23 December 2008 16:58
		Re: Query Rewrite to Utilize Materialized Views on a Remote Database By: rleishman on Thu, 25 December 2008 23:36
		Re: Query Rewrite to Utilize Materialized Views on a Remote Database By: coleing on Fri, 26 December 2008 18:30

		Relate question to MViews By: trantuananh24hg on Thu, 25 December 2008 22:28
		Re: Relate question to MViews By: rleishman on Thu, 25 December 2008 22:37
		Re: Relate question to MViews By: trantuananh24hg on Thu, 25 December 2008 23:09
		Re: Relate question to MViews By: rleishman on Thu, 25 December 2008 23:15
		Re: Relate question to MViews By: trantuananh24hg on Fri, 26 December 2008 03:09

		I've got a slowly query By: trantuananh24hg on Wed, 24 December 2008 21:56
		Re: I've got a slowly query By: rleishman on Thu, 25 December 2008 23:11
		Re: I've got a slowly query By: trantuananh24hg on Thu, 25 December 2008 23:18

		Bitmap indexes "drop/create" or "disable/rebuild" By: Ferrarist on Tue, 23 December 2008 04:52
		Re: Bitmap indexes "drop/create" or "disable/rebuild" By: rleishman on Tue, 23 December 2008 05:44
		Re: Bitmap indexes "drop/create" or "disable/rebuild" By: Ferrarist on Wed, 24 December 2008 04:38

		sql-tuning for specific query? By: mm_kanish05 on Wed, 24 December 2008 00:37
		Re: sql-tuning for specific query? By: michael_bialik on Wed, 24 December 2008 01:00
		Re: sql-tuning for specific query? By: mm_kanish05 on Wed, 24 December 2008 02:48
		Re: sql-tuning for specific query? By: cookiemonster on Wed, 24 December 2008 02:54
		Re: sql-tuning for specific query? By: mm_kanish05 on Wed, 24 December 2008 03:16

		SQL Tuning By: sd_md_rizwan@yahoo.com on Tue, 23 December 2008 01:52
		Re: SQL Tuning By: Frank Naude on Tue, 23 December 2008 01:55
		Re: SQL Tuning By: michael_bialik on Tue, 23 December 2008 01:56
		Re: SQL Tuning By: sd_md_rizwan@yahoo.com on Tue, 23 December 2008 07:30
		Re: SQL Tuning By: michael_bialik on Tue, 23 December 2008 08:14
		Re: SQL Tuning By: sd_md_rizwan@yahoo.com on Wed, 24 December 2008 00:08
		Re: SQL Tuning By: michael_bialik on Wed, 24 December 2008 00:45

		Substr,LTrim,Rtrim making query run slow By: virmahi on Tue, 23 December 2008 05:06
		Re: Substr,LTrim,Rtrim making query run slow By: rleishman on Tue, 23 December 2008 05:33
		Re: Substr,LTrim,Rtrim making query run slow By: virmahi on Tue, 23 December 2008 05:49
		Re: Substr,LTrim,Rtrim making query run slow By: michael_bialik on Tue, 23 December 2008 08:17

		Full table scan when one type of records By: senaka on Tue, 23 December 2008 06:27
		Re: Full table scan when one type of records By: Michel Cadot on Tue, 23 December 2008 06:48

		Querying the database faster By: sandipshahare on Mon, 22 December 2008 23:49
		Re: Querying the database faster By: Frank Naude on Tue, 23 December 2008 01:15
		Re: Querying the database faster By: sandipshahare on Tue, 23 December 2008 01:25

		Query tuning By: virmahi on Mon, 22 December 2008 00:20
		Re: Query tuning By: Frank Naude on Mon, 22 December 2008 02:11
		Re: Query tuning By: virmahi on Mon, 22 December 2008 03:01
		Re: Query tuning By: Frank Naude on Mon, 22 December 2008 04:17

		What is difference between 2 statements? By: trantuananh24hg on Fri, 19 December 2008 02:53
		Re: What is difference between 2 statements? By: yaseendba on Fri, 19 December 2008 03:28
		Re: What is difference between 2 statements? By: Michel Cadot on Fri, 19 December 2008 03:30
		Re: What is difference between 2 statements? By: trantuananh24hg on Sat, 20 December 2008 21:56

		poor performance of Exchange partition on composite range-hash tables By: ora_tune on Fri, 12 December 2008 16:57
		Re: poor performance of Exchange partition on composite range-hash tables By: rleishman on Tue, 16 December 2008 00:21
		Re: poor performance of Exchange partition on composite range-hash tables By: ora_tune on Tue, 16 December 2008 14:07
		Re: poor performance of Exchange partition on composite range-hash tables By: rleishman on Tue, 16 December 2008 21:22
		Re: poor performance of Exchange partition on composite range-hash tables By: ora_tune on Wed, 17 December 2008 12:07
		Re: poor performance of Exchange partition on composite range-hash tables By: rleishman on Wed, 17 December 2008 20:40
		Re: poor performance of Exchange partition on composite range-hash tables By: ora_tune on Fri, 19 December 2008 13:14
		Re: poor performance of Exchange partition on composite range-hash tables By: rleishman on Fri, 19 December 2008 15:21

		open cursors By: grpatwari on Fri, 19 December 2008 00:43
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 00:45
		Re: open cursors By: grpatwari on Fri, 19 December 2008 01:02
		Re: open cursors By: Michel Cadot on Fri, 19 December 2008 01:06
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 01:06
		Re: open cursors By: grpatwari on Fri, 19 December 2008 02:12
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 02:42
		Re: open cursors By: grpatwari on Fri, 19 December 2008 03:13
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 03:37
		Re: open cursors By: grpatwari on Fri, 19 December 2008 04:00
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 04:05
		Re: open cursors By: grpatwari on Fri, 19 December 2008 04:24
		Re: open cursors By: Frank Naude on Fri, 19 December 2008 04:27

		Identifying trace files and how to retrieve from the server (merged) By: sathyam2627 on Tue, 16 December 2008 23:27
		Re: Identifying trace files and how to retrieve from the server (merged) By: Mahesh Rajendran on Wed, 17 December 2008 09:51
		Re: Identifying trace files and how to retrieve from the server (merged) By: Mahesh Rajendran on Wed, 17 December 2008 10:04
		Re: Identifying trace files and how to retrieve from the server (merged) By: sathyam2627 on Wed, 17 December 2008 23:38
		Re: Identifying trace files and how to retrieve from the server (merged) By: trantuananh24hg on Thu, 18 December 2008 20:18

metric defintion for SYSMETRIC

By: dermot_egan on Thu, 18 December 2008 05:47

		SQL tuning By: mhdmehraj on Tue, 25 November 2008 00:47
		Re: SQL tuning By: rleishman on Wed, 26 November 2008 20:13
		Re: SQL tuning By: sibgat on Tue, 16 December 2008 07:24
		Re: SQL tuning By: rleishman on Tue, 16 December 2008 21:38

		Post SHRINK Actions : REBUILD INDEX & CBO Stats ? By: TomG on Tue, 16 December 2008 10:44
		Re: Post SHRINK Actions : REBUILD INDEX & CBO Stats ? By: rleishman on Tue, 16 December 2008 21:36

		Histograms: 32 character limit generates inaccurate stats By: zaff on Tue, 16 December 2008 09:47
		Re: Histograms: 32 character limit generates inaccurate stats By: Michel Cadot on Tue, 16 December 2008 10:04
		Re: Histograms: 32 character limit generates inaccurate stats By: zaff on Tue, 16 December 2008 10:31
		Re: Histograms: 32 character limit generates inaccurate stats By: Mahesh Rajendran on Tue, 16 December 2008 13:11

		Simple query taking too long - looking for Index Suggestion By: agurm on Fri, 12 December 2008 10:40
		Re: Simple query taking too long - looking for Index Suggestion By: Michel Cadot on Fri, 12 December 2008 11:22
		Re: Simple query taking too long - looking for Index Suggestion By: agurm on Fri, 12 December 2008 13:27
		Re: Simple query taking too long - looking for Index Suggestion By: Michel Cadot on Fri, 12 December 2008 14:31
		Re: Simple query taking too long - looking for Index Suggestion By: agurm on Fri, 12 December 2008 23:22
		Re: Simple query taking too long - looking for Index Suggestion By: Michel Cadot on Sat, 13 December 2008 01:43
		Re: Simple query taking too long - looking for Index Suggestion By: rleishman on Mon, 15 December 2008 23:58

		Redo Log Tuning By: rumman on Sun, 14 December 2008 22:52
		Re: Redo Log Tuning By: Michel Cadot on Mon, 15 December 2008 00:47
		Re: Redo Log Tuning By: Frank Naude on Mon, 15 December 2008 02:00

		How SELECT affects remote database from which data is selected By: lotusdeva on Fri, 12 December 2008 12:42
		Re: How SELECT affects remote database from which data is selected By: Michel Cadot on Fri, 12 December 2008 12:52
		Re: How SELECT affects remote database from which data is selected By: lotusdeva on Fri, 12 December 2008 15:49
		Re: How SELECT affects remote database from which data is selected By: Mahesh Rajendran on Fri, 12 December 2008 16:36
		Re: How SELECT affects remote database from which data is selected By: lotusdeva on Fri, 12 December 2008 16:56
		Re: How SELECT affects remote database from which data is selected By: Mahesh Rajendran on Fri, 12 December 2008 17:09
		Re: How SELECT affects remote database from which data is selected By: Mahesh Rajendran on Fri, 12 December 2008 17:11
		Re: How SELECT affects remote database from which data is selected By: Michel Cadot on Sat, 13 December 2008 01:31

data pull from a table

By: dr46014 on Fri, 12 December 2008 12:08

		Converting Trace (.TRC) file to readable(HTML) file in forms 10g By: sureshAToracle on Thu, 04 December 2008 04:45
		Re: Converting Trace (.TRC) file to readable(HTML) file in forms 10g By: Kevin Meade on Fri, 12 December 2008 01:04

		How to improve the performance of "creating partition". By: abs_amit on Mon, 08 December 2008 07:38
		Re: How to improve the performance of "creating partition". By: flyboy on Mon, 08 December 2008 22:00
		Re: How to improve the performance of "creating partition". By: michael_bialik on Wed, 10 December 2008 04:11
		Re: How to improve the performance of "creating partition". By: abs_amit on Wed, 10 December 2008 04:53
		Re: How to improve the performance of "creating partition". By: coleing on Thu, 11 December 2008 19:12

		Keep buffer pool after restart of the server By: snomula on Mon, 08 December 2008 20:16
		Re: Keep buffer pool after restart of the server By: Michel Cadot on Mon, 08 December 2008 23:01
		Re: Keep buffer pool after restart of the server By: JRowbottom on Tue, 09 December 2008 07:08
		Re: Keep buffer pool after restart of the server By: snomula on Tue, 09 December 2008 12:04
		Re: Keep buffer pool after restart of the server By: JRowbottom on Wed, 10 December 2008 03:57
		Re: Keep buffer pool after restart of the server By: JRowbottom on Wed, 10 December 2008 03:59

		Table extents By: rcd70 on Sun, 07 December 2008 19:36
		Re: Table extents By: rleishman on Sun, 07 December 2008 20:01
		Re: Table extents By: rleishman on Sun, 07 December 2008 20:43
		Re: Table extents By: JRowbottom on Tue, 09 December 2008 07:13
		Re: Table extents By: Barbara Boehmer on Tue, 09 December 2008 15:05
		Re: Table extents By: Michel Cadot on Tue, 09 December 2008 15:22
		Re: Table extents By: Michel Cadot on Sun, 07 December 2008 23:39

		Problems with with-statement By: eigeneachse on Tue, 09 December 2008 04:16
		Re: Problems with with-statement ( solved ) By: eigeneachse on Tue, 09 December 2008 04:36
		Re: Problems with with-statement ( solved ) By: JRowbottom on Tue, 09 December 2008 07:06
		Re: Problems with with-statement By: coleing on Tue, 09 December 2008 11:23

		Oracle Benchmark Results for Different Servers brand name By: chara on Tue, 09 December 2008 03:30
		Re: Oracle Benchmark Results for Different Servers brand name By: Frank Naude on Tue, 09 December 2008 06:57

		Advice on SQL tuning By: svguerin3 on Wed, 03 December 2008 16:16
		Re: Advice on SQL tuning By: Michel Cadot on Thu, 04 December 2008 00:10
		Re: Advice on SQL tuning By: rleishman on Thu, 04 December 2008 05:37
		Re: Advice on SQL tuning By: svguerin3 on Thu, 04 December 2008 11:23
		Re: Advice on SQL tuning By: rleishman on Fri, 05 December 2008 02:20
		Re: Advice on SQL tuning By: svguerin3 on Fri, 05 December 2008 11:45
		Re: Advice on SQL tuning By: rleishman on Fri, 05 December 2008 19:12
		Re: Advice on SQL tuning By: svguerin3 on Mon, 08 December 2008 15:55
		Re: Advice on SQL tuning By: rleishman on Mon, 08 December 2008 23:32

		temp tablespace stats By: Georgette on Mon, 08 December 2008 15:05
		Re: temp tablespace stats By: Michel Cadot on Mon, 08 December 2008 22:59

		INDEX_DESC Hint By: Olivia on Mon, 08 December 2008 04:47
		Re: INDEX_DESC Hint By: Michel Cadot on Mon, 08 December 2008 05:11
		Re: INDEX_DESC Hint By: Olivia on Mon, 08 December 2008 08:12
		Re: INDEX_DESC Hint By: Michel Cadot on Mon, 08 December 2008 08:25

		USE_HASH By: jageesh on Mon, 08 December 2008 05:45
		Re: USE_HASH By: Michel Cadot on Mon, 08 December 2008 05:54
		Re: USE_HASH By: Frank Naude on Mon, 08 December 2008 06:01

		how to tune this query? By: Selva on Wed, 08 December 2004 23:07
		Re: how to tune this query? By: Art Metzer on Thu, 09 December 2004 04:59
		Re: how to tune this query? By: Selva on Thu, 09 December 2004 19:58
		Re: how to tune this query? By: dmerin on Sun, 07 December 2008 22:45

Pages (119): [ « ‹ 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Mon Jul 08 16:13:05 CDT 2024