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.

		Run TKPROF.............. By: naveenkumar001 on Mon, 20 August 2007 11:04
		Re: Run TKPROF.............. By: Michel Cadot on Mon, 20 August 2007 11:34
		Re: Run TKPROF.............. By: naveenkumar001 on Mon, 20 August 2007 12:34
		Re: Run TKPROF.............. By: Michel Cadot on Mon, 20 August 2007 12:53

		Time taken to refresh with DBMS_REFRESH By: kamragulshan on Mon, 20 August 2007 05:12
		Re: Time taken to refresh with DBMS_REFRESH By: Michel Cadot on Mon, 20 August 2007 11:34

		How to implement SQL changes when tuning By: mson77 on Sun, 19 August 2007 22:09
		Re: How to implement SQL changes when tuning By: Michel Cadot on Mon, 20 August 2007 00:58
		Re: How to implement SQL changes when tuning By: mson77 on Mon, 20 August 2007 01:01

		Currently Executing statement not available in Trace file- Oracle 10g By: orasaket on Sun, 19 August 2007 07:35
		Re: Currently Executing statement not available in Trace file- Oracle 10g By: Michel Cadot on Sun, 19 August 2007 09:48
		Re: Currently Executing statement not available in Trace file- Oracle 10g By: orasaket on Sun, 19 August 2007 10:33
		Re: Currently Executing statement not available in Trace file- Oracle 10g By: Michel Cadot on Sun, 19 August 2007 12:34
		Re: Currently Executing statement not available in Trace file- Oracle 10g By: rleishman on Sun, 19 August 2007 22:00

		Currently executing statement for Oracle Job- Oracle 10g By: orasaket on Sun, 19 August 2007 07:22
		Re: Currently executing statement for Oracle Job- Oracle 10g By: Michel Cadot on Sun, 19 August 2007 09:49
		Re: Currently executing statement for Oracle Job- Oracle 10g By: orasaket on Sun, 19 August 2007 10:35
		Re: Currently executing statement for Oracle Job- Oracle 10g By: orasaket on Sun, 19 August 2007 10:59
		Re: Currently executing statement for Oracle Job- Oracle 10g By: Michel Cadot on Sun, 19 August 2007 12:31

		CONTEXT index By: yesukannan on Sat, 18 August 2007 05:24
		Re: CONTEXT index By: ebrian on Sat, 18 August 2007 08:58

		SQL Tuning By: mson77 on Tue, 14 August 2007 21:53
		Re: SQL Tuning By: BlackSwan on Tue, 14 August 2007 22:04
		Re: SQL Tuning By: mson77 on Tue, 14 August 2007 22:24
		Re: SQL Tuning By: BlackSwan on Tue, 14 August 2007 22:30
		Re: SQL Tuning By: mson77 on Tue, 14 August 2007 22:54
		Re: SQL Tuning By: BlackSwan on Tue, 14 August 2007 23:16
		Re: SQL Tuning By: mson77 on Tue, 14 August 2007 23:29
		Re: SQL Tuning By: BlackSwan on Tue, 14 August 2007 23:39
		Re: SQL Tuning By: mson77 on Tue, 14 August 2007 23:49
		Re: SQL Tuning By: Michel Cadot on Wed, 15 August 2007 01:36
		Re: SQL Tuning By: mson77 on Wed, 15 August 2007 09:08
		Re: SQL Tuning By: BlackSwan on Wed, 15 August 2007 09:14
		Re: SQL Tuning By: mson77 on Wed, 15 August 2007 09:18
		Re: SQL Tuning By: Michel Cadot on Wed, 15 August 2007 09:33
		Re: SQL Tuning By: mson77 on Wed, 15 August 2007 09:42
		Re: SQL Tuning By: mson77 on Wed, 15 August 2007 20:33
		Re: SQL Tuning By: BlackSwan on Wed, 15 August 2007 09:28
		Re: SQL Tuning By: BlackSwan on Wed, 15 August 2007 21:12
		Re: SQL Tuning By: mson77 on Wed, 15 August 2007 21:24
		Re: SQL Tuning By: BlackSwan on Wed, 15 August 2007 21:40
		Re: SQL Tuning By: mson77 on Thu, 16 August 2007 00:32
		Re: SQL Tuning By: BlackSwan on Thu, 16 August 2007 00:43
		Re: SQL Tuning By: mson77 on Thu, 16 August 2007 01:12
		Re: SQL Tuning By: mson77 on Thu, 16 August 2007 12:02
		Re: SQL Tuning By: mson77 on Sat, 18 August 2007 00:46

		TUNNING By: qasim845 on Thu, 16 August 2007 14:45
		Re: TUNNING By: S.Rajaram on Thu, 16 August 2007 15:58
		Re: TUNNING By: qasim845 on Thu, 16 August 2007 16:55
		Re: TUNNING By: BlackSwan on Thu, 16 August 2007 17:04
		Re: TUNNING By: qasim845 on Thu, 16 August 2007 17:10
		Re: TUNNING By: BlackSwan on Thu, 16 August 2007 17:27
		Re: TUNNING By: shoaib_143 on Thu, 16 August 2007 19:00
		Re: TUNNING By: rleishman on Thu, 16 August 2007 21:49
		Re: TUNNING By: qasim845 on Fri, 17 August 2007 07:51

		Some missing concepts and definitions By: mson77 on Thu, 16 August 2007 14:08
		Re: Some missing concepts and definitions By: S.Rajaram on Thu, 16 August 2007 16:18
		Re: Some missing concepts and definitions By: rleishman on Thu, 16 August 2007 21:57
		Re: Some missing concepts and definitions By: mson77 on Fri, 17 August 2007 00:29

		Indexes on LMT By: sudipsarkar on Thu, 16 August 2007 13:15
		Re: Indexes on LMT By: Michel Cadot on Thu, 16 August 2007 13:18
		Re: Indexes on LMT By: sudipsarkar on Thu, 16 August 2007 13:40
		Re: Indexes on LMT By: rleishman on Thu, 16 August 2007 21:59

		How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 11:15
		Re: How to recreate statistics to whole schema? By: Michel Cadot on Thu, 16 August 2007 11:22
		Re: How to recreate statistics to whole schema? By: BlackSwan on Thu, 16 August 2007 11:22
		Re: How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 11:49
		Re: How to recreate statistics to whole schema? By: BlackSwan on Thu, 16 August 2007 11:55
		Re: How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 12:08
		Re: How to recreate statistics to whole schema? By: BlackSwan on Thu, 16 August 2007 12:17
		Re: How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 12:41
		Re: How to recreate statistics to whole schema? By: Michel Cadot on Thu, 16 August 2007 13:19
		Re: How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 13:31
		Re: How to recreate statistics to whole schema? By: BlackSwan on Thu, 16 August 2007 12:52
		Re: How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 13:18

DB Monitoring tool

By: winnerMedas on Thu, 16 August 2007 12:13

		oracle.exe 100% during many hours By: mson77 on Thu, 16 August 2007 10:59
		Re: oracle.exe 100% during many hours By: mson77 on Thu, 16 August 2007 11:09

		very high redo space wait ratios on 10g By: sumang24 on Tue, 14 August 2007 12:15
		Re: very high redo space wait ratios on 10g By: Michel Cadot on Tue, 14 August 2007 12:43
		Re: very high redo space wait ratios on 10g By: orafaqer on Wed, 15 August 2007 08:36

		v$sga_target_advice view By: sumang24 on Tue, 14 August 2007 12:17
		Re: v$sga_target_advice view By: Michel Cadot on Tue, 14 August 2007 12:37

		Update Statement - Performance Tuning By: mymot on Tue, 14 August 2007 06:21
		Re: Update Statement - Performance Tuning By: Michel Cadot on Tue, 14 August 2007 06:32
		Re: Update Statement - Performance Tuning By: mymot on Tue, 14 August 2007 06:50
		Re: Update Statement - Performance Tuning By: cbruhn2 on Tue, 14 August 2007 08:02
		Re: Update Statement - Performance Tuning By: S.Rajaram on Tue, 14 August 2007 08:13

		how to find out the I/O and CPU bottleneks By: pavan27 on Mon, 13 August 2007 14:21
		Re: how to find out the I/O and CPU bottleneks By: DreamzZ on Mon, 13 August 2007 14:24

		Takes more time - DELETE. By: marlon_loyolite on Sat, 11 August 2007 06:54
		Re: Takes more time - DELETE. By: Michel Cadot on Sat, 11 August 2007 09:19
		Re: Takes more time - DELETE. By: DreamzZ on Mon, 13 August 2007 12:30

		Different Explain in Different Instances. By: maggy_ashee on Mon, 13 August 2007 03:51
		Re: Different Explain in Different Instances. By: rons on Mon, 13 August 2007 03:53
		Re: Different Explain in Different Instances. By: maggy_ashee on Mon, 13 August 2007 03:55
		Re: Different Explain in Different Instances. By: Michel Cadot on Mon, 13 August 2007 03:57
		Re: Different Explain in Different Instances. By: rons on Mon, 13 August 2007 03:58
		Re: Different Explain in Different Instances. By: maggy_ashee on Mon, 13 August 2007 06:28
		Re: Different Explain in Different Instances. By: pablolee on Mon, 13 August 2007 06:48
		Re: Different Explain in Different Instances. By: maggy_ashee on Mon, 13 August 2007 09:35

		10g performance tuning (how can I practice?) By: mson77 on Sat, 11 August 2007 22:43
		Re: 10g performance tuning (how can I practice?) By: BlackSwan on Sat, 11 August 2007 22:58
		Re: 10g performance tuning (how can I practice?) By: mson77 on Sat, 11 August 2007 23:20
		Re: 10g performance tuning (how can I practice?) By: BlackSwan on Sat, 11 August 2007 23:31
		Re: 10g performance tuning (how can I practice?) By: mson77 on Sat, 11 August 2007 23:44
		Re: 10g performance tuning (how can I practice?) By: mson77 on Sun, 12 August 2007 11:38
		Re: 10g performance tuning (how can I practice?) By: BlackSwan on Sun, 12 August 2007 12:24
		Re: 10g performance tuning (how can I practice?) By: mson77 on Sun, 12 August 2007 15:25
		Re: 10g performance tuning (how can I practice?) By: mson77 on Sun, 12 August 2007 22:24
		Re: 10g performance tuning (how can I practice?) By: BlackSwan on Sun, 12 August 2007 22:42

		cached objects in buffer By: pramodgaree on Sat, 11 August 2007 06:33
		Re: cached objects in buffer By: Michel Cadot on Sat, 11 August 2007 09:22

		Help - Histogram By: orasaket on Thu, 09 August 2007 12:04
		Re: Help - Histogram By: Michel Cadot on Thu, 09 August 2007 12:23
		Re: Help - Histogram By: orasaket on Thu, 09 August 2007 13:17
		Re: Help - Histogram By: Michel Cadot on Thu, 09 August 2007 13:34
		Re: Help - Histogram By: orasaket on Thu, 09 August 2007 14:36

dead ORADISM process

By: preet_kumar on Thu, 09 August 2007 05:30

		Index for Order by clause By: poratips on Mon, 30 July 2007 16:59
		Re: Index for Order by clause By: BlackSwan on Mon, 30 July 2007 17:17
		Re: Index for Order by clause By: rleishman on Mon, 30 July 2007 23:03
		Re: Index for Order by clause By: Michel Cadot on Tue, 31 July 2007 01:05
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 08:56
		Re: Index for Order by clause By: Michel Cadot on Tue, 31 July 2007 09:18
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 11:00
		Re: Index for Order by clause By: Michel Cadot on Tue, 31 July 2007 11:22
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 12:26
		Re: Index for Order by clause By: Michel Cadot on Tue, 31 July 2007 13:41
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 14:24
		Re: Index for Order by clause By: Michel Cadot on Tue, 31 July 2007 14:32
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 20:11
		Re: Index for Order by clause By: poratips on Tue, 31 July 2007 09:12
		Re: Index for Order by clause By: BlackSwan on Tue, 31 July 2007 23:45
		Re: Index for Order by clause By: poratips on Wed, 01 August 2007 10:14
		Re: Index for Order by clause By: BlackSwan on Wed, 01 August 2007 10:29
		Re: Index for Order by clause By: poratips on Wed, 01 August 2007 10:33
		Re: Index for Order by clause By: rleishman on Wed, 01 August 2007 17:38
		Re: Index for Order by clause By: poratips on Wed, 08 August 2007 22:57

		Error during Merge Statment By: pardeep on Wed, 08 August 2007 07:22
		Re: Error during Merge Statment By: Michel Cadot on Wed, 08 August 2007 07:28
		Re: Error during Merge Statment By: pardeep on Wed, 08 August 2007 07:34
		Re: Error during Merge Statment By: Michel Cadot on Wed, 08 August 2007 08:32
		Re: Error during Merge Statment By: pardeep on Wed, 08 August 2007 09:26
		Re: Error during Merge Statment By: Michel Cadot on Wed, 08 August 2007 10:06
		Re: Error during Merge Statment By: DreamzZ on Wed, 08 August 2007 11:44

		Creation of index By: donind on Mon, 06 August 2007 03:50
		Re: Creation of index By: rleishman on Mon, 06 August 2007 23:09
		Re: Creation of index By: donind on Tue, 07 August 2007 00:48
		Re: Creation of index By: rleishman on Tue, 07 August 2007 22:19

		reverse key index By: donind on Tue, 07 August 2007 05:47
		Re: reverse key index By: cbruhn2 on Tue, 07 August 2007 07:34
		Re: reverse key index By: rleishman on Tue, 07 August 2007 22:14

		Performance Slow - Jobs By: prashanth_gs on Tue, 07 August 2007 20:36
		Re: Performance Slow - Jobs By: BlackSwan on Tue, 07 August 2007 20:56

		Performance tunning By: qasim845 on Mon, 06 August 2007 12:14
		Re: Performance tunning By: rleishman on Mon, 06 August 2007 22:59
		Re: Performance tunning By: michael_bialik on Tue, 07 August 2007 03:12
		Re: Performance tunning By: qasim845 on Tue, 07 August 2007 08:15

		Performance problem when using Analytic Functions. Need Help !!! By: v@to on Tue, 07 August 2007 05:19
		Re: Performance problem when using Analytic Functions. Need Help !!! By: cbruhn2 on Tue, 07 August 2007 07:41
		Re: Performance problem when using Analytic Functions. Need Help !!! By: v@to on Tue, 07 August 2007 07:50

		stripping in oracle 10g dba? By: enchantress on Fri, 03 August 2007 08:44
		Re: stripping in oracle 10g dba? By: Michel Cadot on Fri, 03 August 2007 09:12
		Re: stripping in oracle 10g dba? By: DreamzZ on Fri, 03 August 2007 11:23
		Re: stripping in oracle 10g dba? By: enchantress on Mon, 06 August 2007 08:07
		Re: stripping in oracle 10g dba? By: enchantress on Mon, 06 August 2007 08:08

		Monthly Avg. CPU Time usage.. meaningful? By: subhrajitb on Sun, 05 August 2007 14:30
		Re: Monthly Avg. CPU Time usage.. meaningful? By: BlackSwan on Sun, 05 August 2007 19:20

		Sort Area Size - ORA-600 & ORA-02097 (merged) By: naveenkumar001 on Fri, 03 August 2007 07:55
		Re: Sort_Area_Size By: Michel Cadot on Fri, 03 August 2007 08:31
		Ora-02097................... By: naveenkumar001 on Fri, 03 August 2007 09:25
		Re: Ora-02097................... By: BlackSwan on Fri, 03 August 2007 10:23

		Problem when installing statspack By: chaitanya_krishna on Wed, 01 August 2007 06:12
		Re: Problem when installing statspack By: Michel Cadot on Wed, 01 August 2007 06:42
		Re: Problem when installing statspack By: chaitanya_krishna on Wed, 01 August 2007 23:04
		Re: Problem when installing statspack By: Mohammad Taj on Wed, 01 August 2007 23:26
		Re: Problem when installing statspack By: chaitanya_krishna on Thu, 02 August 2007 00:29
		Re: Problem when installing statspack By: BlackSwan on Thu, 02 August 2007 00:34
		Re: Problem when installing statspack By: chaitanya_krishna on Thu, 02 August 2007 00:52
		Re: Problem when installing statspack By: Michel Cadot on Thu, 02 August 2007 00:54
		Re: Problem when installing statspack By: chaitanya_krishna on Thu, 02 August 2007 02:25
		Re: Problem when installing statspack By: Michel Cadot on Thu, 02 August 2007 02:32
		Re: Problem when installing statspack By: chaitanya_krishna on Thu, 02 August 2007 05:47
		Re: Problem when installing statspack By: Michel Cadot on Thu, 02 August 2007 06:11
		Re: Problem when installing statspack By: chaitanya_krishna on Thu, 02 August 2007 07:19
		Re: Problem when installing statspack By: chaitanya_krishna on Fri, 03 August 2007 06:23

		Temp Datafiles Size By: mian imran on Tue, 31 July 2007 00:43
		Re: Temp Datafiles Size By: Michel Cadot on Tue, 31 July 2007 01:04
		Re: Temp Datafiles Size By: mian imran on Tue, 31 July 2007 01:53
		Re: Temp Datafiles Size By: cbruhn2 on Tue, 31 July 2007 07:16
		Re: Temp Datafiles Size By: mian imran on Fri, 03 August 2007 03:17
		Re: Temp Datafiles Size By: martijn on Fri, 03 August 2007 04:23

		query tuning By: vimal.negi on Mon, 30 July 2007 21:38
		Re: query tuning By: rleishman on Mon, 30 July 2007 23:01
		Re: query tuning By: vimal.negi on Mon, 30 July 2007 23:31
		Re: query tuning By: rleishman on Tue, 31 July 2007 22:43
		Re: query tuning By: vimal.negi on Tue, 31 July 2007 22:56
		Re: query tuning By: rleishman on Tue, 31 July 2007 23:15
		Re: query tuning By: vimal.negi on Tue, 31 July 2007 23:32
		Re: query tuning By: rleishman on Wed, 01 August 2007 03:08
		Re: query tuning By: vimal.negi on Thu, 02 August 2007 01:17
		Re: query tuning By: rleishman on Thu, 02 August 2007 05:37
		Re: query tuning By: vimal.negi on Thu, 02 August 2007 07:11
		Re: query tuning By: rleishman on Thu, 02 August 2007 18:55
		Re: query tuning By: vimal.negi on Thu, 02 August 2007 21:47
		Re: query tuning By: BlackSwan on Mon, 30 July 2007 23:33
		Re: query tuning By: vimal.negi on Tue, 31 July 2007 01:01
		Re: query tuning By: Michel Cadot on Tue, 31 July 2007 01:02
		Re: query tuning By: vimal.negi on Tue, 31 July 2007 01:06

		CAN WE USE HINT IN VIEW QUERY STATEMENT By: jainarayan5484 on Thu, 02 August 2007 09:55
		Re: CAN WE USE HINT IN VIEW QUERY STATEMENT By: DreamzZ on Thu, 02 August 2007 10:20
		Re: CAN WE USE HINT IN VIEW QUERY STATEMENT By: Michel Cadot on Thu, 02 August 2007 13:00

		How to Generate Statistics of a table and how to see in oracle 10g By: jainarayan5484 on Thu, 02 August 2007 09:25
		Re: How to Generate Statistics of a table and how to see in oracle 10g By: BlackSwan on Thu, 02 August 2007 10:20
		Re: How to Generate Statistics of a table and how to see in oracle 10g By: DreamzZ on Thu, 02 August 2007 10:22

		performance problem when use parallel and hash join on large tables By: fbucco on Tue, 31 July 2007 17:57
		Re: performance problem when use parallel and hash join on large tables By: BlackSwan on Tue, 31 July 2007 18:01
		Re: performance problem when use parallel and hash join on large tables By: fbucco on Wed, 01 August 2007 08:26
		Re: performance problem when use parallel and hash join on large tables By: Michel Cadot on Wed, 01 August 2007 08:53
		Re: performance problem when use parallel and hash join on large tables By: fbucco on Wed, 01 August 2007 13:08
		Re: performance problem when use parallel and hash join on large tables By: rleishman on Tue, 31 July 2007 23:00

		How to find out the bad sql statemets ? By: kesevan on Sat, 28 April 2007 01:53
		Re: How to find out the bad sql statemets ? By: Brayan on Sat, 28 April 2007 02:26
		Re: How to find out the bad sql statemets ? By: cliff_tian on Sat, 28 April 2007 03:27
		Re: How to find out the bad sql statemets ? By: Michel Cadot on Sat, 28 April 2007 07:49
		Re: How to find out the bad sql statemets ? By: ashok_mni on Wed, 01 August 2007 08:59
		Re: How to find out the bad sql statemets ? By: Michel Cadot on Wed, 01 August 2007 09:07
		Re: How to find out the bad sql statemets ? By: DreamzZ on Wed, 01 August 2007 10:49
		Re: How to find out the bad sql statemets ? By: Michel Cadot on Wed, 01 August 2007 10:55

Pages (119): [ « ‹ 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 › »]

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 01 05:27:43 CDT 2024