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.

		Sql slow query plan By: vasudevan on Wed, 12 September 2007 10:19
		Re: Sql slow query plan By: Michel Cadot on Wed, 12 September 2007 10:35

		Too much memory consumed in SGA By: rrodriguez56 on Mon, 10 September 2007 11:08
		Re: Too much memory consumed in SGA By: smartin on Tue, 11 September 2007 14:56
		Re: Too much memory consumed in SGA By: rrodriguez56 on Wed, 12 September 2007 10:19

		SMON TOP PROCESS By: pag63 on Wed, 12 September 2007 09:28
		Re: SMON TOP PROCESS By: MarcL on Wed, 12 September 2007 09:33

		DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 04:36
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 04:49
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 05:23
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 05:33
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 05:36
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 05:44
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 05:58
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 06:11
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 06:15
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 06:36
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 07:08
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Tue, 11 September 2007 07:30
		Re: DB_Cache_Hit Ratio less than 70 By: Michel Cadot on Tue, 11 September 2007 08:20
		Re: DB_Cache_Hit Ratio less than 70 By: tkmittal1 on Wed, 12 September 2007 03:41
		<more>
		<more>

		What is the different between Oracle parse and application parse? By: trantuananh24hg on Tue, 11 September 2007 23:06
		Re: What is the different between Oracle parse and application parse? By: Michel Cadot on Wed, 12 September 2007 01:10

		Trying to tune a query. By: galan_josel on Mon, 10 September 2007 23:08
		Re: Trying to tune a query. By: Michel Cadot on Tue, 11 September 2007 01:22
		Re: Trying to tune a query. By: galan_josel on Tue, 11 September 2007 05:51
		Re: Trying to tune a query. By: Michel Cadot on Tue, 11 September 2007 05:53
		Re: Trying to tune a query. By: galan_josel on Tue, 11 September 2007 05:58
		Re: Trying to tune a query. By: mson77 on Tue, 11 September 2007 19:50
		Re: Trying to tune a query. By: galan_josel on Tue, 11 September 2007 21:41

		Error when I try to connect to a database using sqlplus By: alexia_net on Tue, 11 September 2007 04:04
		Re: Error when I try to connect to a database using sqlplus By: Michel Cadot on Tue, 11 September 2007 04:11
		Re: Error when I try to connect to a database using sqlplus By: Arju on Tue, 11 September 2007 04:11
		Re: Error when I try to connect to a database using sqlplus By: Arju on Tue, 11 September 2007 04:13
		Re: Error when I try to connect to a database using sqlplus By: Michel Cadot on Tue, 11 September 2007 04:17
		Re: Error when I try to connect to a database using sqlplus By: alexia_net on Tue, 11 September 2007 05:36

		a lot of rollback problem By: thorin666 on Mon, 10 September 2007 16:17
		Re: a lot of rollback problem By: Michel Cadot on Mon, 10 September 2007 23:20
		Re: a lot of rollback problem By: thorin666 on Tue, 11 September 2007 04:50
		Re: a lot of rollback problem By: Michel Cadot on Tue, 11 September 2007 04:55

		How many connection are on line By: alexia_net on Tue, 11 September 2007 03:29
		Re: How many connection are on line By: alexia_net on Tue, 11 September 2007 03:30
		Re: How many connection are on line By: Arju on Tue, 11 September 2007 03:36
		Re: How many connection are on line By: alexia_net on Tue, 11 September 2007 04:17

		CPU usage has been 100% consistently By: sreehari on Thu, 16 August 2007 05:49
		Re: CPU usage has been 100% consistently By: cbruhn2 on Thu, 16 August 2007 06:12
		Re: CPU usage has been 100% consistently By: sreehari on Mon, 20 August 2007 14:42
		Re: CPU usage has been 100% consistently By: michael_bialik on Wed, 22 August 2007 14:18
		Re: CPU usage has been 100% consistently By: vasudevan on Tue, 28 August 2007 13:36
		Re: CPU usage has been 100% consistently By: cvs_1984 on Wed, 29 August 2007 07:49
		Re: CPU usage has been 100% consistently By: rupaliss on Tue, 11 September 2007 01:31

		Query running slow .. a day before it was fine By: luckyally on Wed, 22 August 2007 15:27
		Re: Query running slow .. a day before it was fine By: BlackSwan on Wed, 22 August 2007 15:54
		Re: Query running slow .. a day before it was fine By: ebrian on Thu, 23 August 2007 03:33
		Re: Query running slow .. a day before it was fine By: luckyally on Sun, 02 September 2007 23:55
		Re: Query running slow .. a day before it was fine By: pablolee on Mon, 03 September 2007 00:01
		Re: Query running slow .. a day before it was fine By: jai_subi on Thu, 06 September 2007 07:30
		Re: Query running slow .. a day before it was fine By: mson77 on Thu, 06 September 2007 08:01
		Re: Query running slow .. a day before it was fine By: rupaliss on Tue, 11 September 2007 01:16
		Re: Query running slow .. a day before it was fine By: Arju on Tue, 11 September 2007 01:26

		Too many redo log file (merged) By: vikeshcool@hotmail.com on Thu, 06 September 2007 05:36
		too many redo log file By: vikeshcool@hotmail.com on Mon, 10 September 2007 03:05
		Re: too many redo log file By: Mohammad Taj on Mon, 10 September 2007 03:08
		Re: too many redo log file By: Michel Cadot on Mon, 10 September 2007 03:13
		Re: Too many redo log file (merged) By: Arju on Mon, 10 September 2007 22:13
		Re: Too many redo log file (merged) By: vikeshcool@hotmail.com on Mon, 10 September 2007 22:20
		Re: Too many redo log file (merged) By: Arju on Mon, 10 September 2007 22:36
		Re: Too many redo log file (merged) By: vikeshcool@hotmail.com on Mon, 10 September 2007 22:43
		Re: Too many redo log file (merged) By: Michel Cadot on Mon, 10 September 2007 23:09
		Re: Too many redo log file (merged) By: Arju on Mon, 10 September 2007 23:05
		Re: Too many redo log file (merged) By: BlackSwan on Mon, 10 September 2007 23:15

		Table lock Blocking By: kflee2000 on Sun, 09 September 2007 22:55
		Re: Table lock Blocking By: BlackSwan on Sun, 09 September 2007 23:23
		Re: Table lock Blocking By: kflee2000 on Mon, 10 September 2007 00:11
		Re: Table lock Blocking By: Michel Cadot on Mon, 10 September 2007 01:05
		Re: Table lock Blocking By: kflee2000 on Mon, 10 September 2007 01:24
		Re: Table lock Blocking By: Michel Cadot on Mon, 10 September 2007 01:35

		How to identify a parse of SQL statement? By: trantuananh24hg on Fri, 07 September 2007 05:53
		Re: How to identify a parse of SQL statement? By: Michel Cadot on Fri, 07 September 2007 07:28
		Re: How to identify a parse of SQL statement? By: trantuananh24hg on Fri, 07 September 2007 20:58
		Re: How to identify a parse of SQL statement? By: muzahid on Sun, 09 September 2007 12:34
		Re: How to identify a parse of SQL statement? By: Michel Cadot on Sun, 09 September 2007 13:43

		How can we get statistics on a table being used 24/7 in a database By: coolboy2005in on Sun, 09 September 2007 07:57
		Re: How can we get statistics on a table being used 24/7 in a database By: coolboy2005in on Sun, 09 September 2007 08:01
		Re: How can we get statistics on a table being used 24/7 in a database By: Mohammad Taj on Sun, 09 September 2007 08:02
		Re: How can we get statistics on a table being used 24/7 in a database By: coolboy2005in on Sun, 09 September 2007 08:10
		Re: How can we get statistics on a table being used 24/7 in a database By: mson77 on Sun, 09 September 2007 10:46

		Instance Efficiency By: vasudevan on Fri, 07 September 2007 08:26
		Re: Instance Efficiency By: Michel Cadot on Fri, 07 September 2007 08:41
		Re: Instance Efficiency By: vasudevan on Fri, 07 September 2007 09:08
		Re: Instance Efficiency By: Michel Cadot on Fri, 07 September 2007 13:02
		Re: Instance Efficiency By: muzahid on Fri, 07 September 2007 12:51

		Procedure Tuning By: yashora on Thu, 06 September 2007 05:39
		Re: Procedure Tuning By: Michel Cadot on Thu, 06 September 2007 05:42
		Re: Procedure Tuning By: yashora on Thu, 06 September 2007 05:44
		Re: Procedure Tuning By: Michel Cadot on Thu, 06 September 2007 05:45
		Re: Procedure Tuning By: yashora on Thu, 06 September 2007 05:48
		Re: Procedure Tuning By: Michel Cadot on Thu, 06 September 2007 06:01
		Re: Procedure Tuning By: rleishman on Thu, 06 September 2007 22:01

		Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Mon, 27 August 2007 03:29
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Mon, 27 August 2007 03:41
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Mon, 27 August 2007 03:58
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Mon, 27 August 2007 04:01
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Mon, 27 August 2007 04:17
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: rleishman on Mon, 27 August 2007 21:16
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Tue, 28 August 2007 02:21
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Tue, 28 August 2007 02:22
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Tue, 28 August 2007 07:24
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Tue, 28 August 2007 07:43
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Tue, 28 August 2007 08:09
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Tue, 28 August 2007 08:15
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Tue, 28 August 2007 08:58
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Tue, 28 August 2007 08:59
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Tue, 28 August 2007 09:49
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: Mohammad Taj on Tue, 28 August 2007 09:52
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: zzasteven on Wed, 29 August 2007 15:18
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Fri, 31 August 2007 02:10
		Re: Oracle10g 10.0.2.0.1 Performance Problems By: mson77 on Wed, 05 September 2007 23:48

		Can anyone sent me the good peformance & tuning pdf file for 10g By: priyachopra on Sat, 01 September 2007 08:59
		Re: Can anyone sent me the good peformance & tuning pdf file for 10g By: BlackSwan on Sat, 01 September 2007 09:08
		Re: Can anyone sent me the good peformance & tuning pdf file for 10g By: Michel Cadot on Sat, 01 September 2007 09:23
		Re: Can anyone sent me the good peformance & tuning pdf file for 10g By: mson77 on Wed, 05 September 2007 23:29

		STATSPACK ANALYSIS TOOL By: navaneethdba on Wed, 01 August 2007 00:45
		Re: STATSPACK ANALYSIS TOOL By: Michel Cadot on Wed, 01 August 2007 01:00
		Re: STATSPACK ANALYSIS TOOL By: navaneethdba on Wed, 01 August 2007 01:21
		Re: STATSPACK ANALYSIS TOOL By: BlackSwan on Wed, 01 August 2007 01:28
		Re: STATSPACK ANALYSIS TOOL By: navaneethdba on Wed, 01 August 2007 01:31
		Re: STATSPACK ANALYSIS TOOL By: goggy on Fri, 31 August 2007 02:47
		Re: STATSPACK ANALYSIS TOOL By: Michel Cadot on Fri, 31 August 2007 03:28
		Re: STATSPACK ANALYSIS TOOL By: mson77 on Wed, 05 September 2007 23:19

		Help - Tuning query By: orasaket on Fri, 24 August 2007 05:53
		Re: Help - Tuning query By: Michel Cadot on Fri, 24 August 2007 06:11
		Re: Help - Tuning query By: rleishman on Fri, 24 August 2007 08:04
		Re: Help - Tuning query By: orasaket on Fri, 24 August 2007 07:57
		Re: Help - Tuning query By: michael_bialik on Wed, 05 September 2007 14:06
		Re: Help - Tuning query By: mson77 on Wed, 05 September 2007 19:16

		Which is memory set to shared pool? By: trantuananh24hg on Tue, 04 September 2007 22:11
		Re: Which is memory set to shared pool? By: Arju on Tue, 04 September 2007 22:15
		Re: Which is memory set to shared pool? By: trantuananh24hg on Tue, 04 September 2007 22:25
		Re: Which is memory set to shared pool? By: Arju on Tue, 04 September 2007 22:46
		Re: Which is memory set to shared pool? By: trantuananh24hg on Wed, 05 September 2007 02:29
		Re: Which is memory set to shared pool? By: Michel Cadot on Wed, 05 September 2007 02:49
		Re: Which is memory set to shared pool? By: DreamzZ on Wed, 05 September 2007 10:15

netstat| grep 1522| wc -l

By: nonstopkaran on Wed, 05 September 2007 01:47

		db_cache_size - correct size By: rons on Mon, 13 August 2007 03:40
		Re: db_cache_size - correct size By: Arju on Mon, 13 August 2007 03:43
		Re: db_cache_size - correct size By: Mohammad Taj on Mon, 13 August 2007 03:47
		Re: db_cache_size - correct size By: rons on Mon, 13 August 2007 03:51
		Re: db_cache_size - correct size By: Arju on Mon, 13 August 2007 04:30
		Re: db_cache_size - correct size By: rons on Mon, 13 August 2007 04:42
		Re: db_cache_size - correct size By: rons on Mon, 13 August 2007 05:40
		Re: db_cache_size - correct size By: Michel Cadot on Mon, 13 August 2007 06:25
		Re: db_cache_size - correct size By: rons on Mon, 13 August 2007 06:32
		Re: db_cache_size - correct size By: Michel Cadot on Mon, 13 August 2007 06:43
		Re: db_cache_size - correct size By: trantuananh24hg on Tue, 04 September 2007 05:09
		Re: db_cache_size - correct size By: Michel Cadot on Tue, 04 September 2007 07:14

		shared memory realm already exists By: alexia_net on Fri, 24 August 2007 12:38
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 12:39
		Re: shared memory realm already exists By: BlackSwan on Fri, 24 August 2007 12:42
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 12:48
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 12:48
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 13:00
		Re: shared memory realm already exists By: BlackSwan on Fri, 24 August 2007 13:10
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 13:28
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 13:30
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 13:38
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 13:39
		Re: shared memory realm already exists By: alexia_net on Fri, 24 August 2007 15:21
		Re: shared memory realm already exists By: trantuananh24hg on Tue, 04 September 2007 04:02

		Hash join vs NL join By: beetel on Mon, 03 September 2007 01:01
		Re: Hash join vs NL join By: BlackSwan on Mon, 03 September 2007 01:06
		Re: Hash join vs NL join By: Michel Cadot on Mon, 03 September 2007 01:07
		Re: Hash join vs NL join By: beetel on Mon, 03 September 2007 02:22
		Re: Hash join vs NL join By: Michel Cadot on Mon, 03 September 2007 02:41
		Re: Hash join vs NL join By: rleishman on Mon, 03 September 2007 03:07
		Re: Hash join vs NL join By: beetel on Mon, 03 September 2007 12:00

		Database is slow. By: sanjay_kant on Sun, 02 September 2007 04:43
		Re: Database is slow. By: Arju on Sun, 02 September 2007 05:49
		Re: Database is slow. By: Michel Cadot on Sun, 02 September 2007 09:58
		Re: Database is slow. By: sanjay_kant on Sun, 02 September 2007 10:19
		Re: Database is slow. By: pablolee on Sun, 02 September 2007 23:08
		Re: Database is slow. By: Arju on Sun, 02 September 2007 22:16

		Duplicating ** million record table By: fakhar55 on Sun, 02 September 2007 02:02
		Re: Duplicating ** million record table By: muzahid on Sun, 02 September 2007 08:29

		warning message By: vasudevan on Thu, 23 August 2007 09:25
		Re: warning message By: S.Rajaram on Fri, 31 August 2007 13:54

		rebuilding index By: adee_saleh on Thu, 28 June 2007 21:01
		Re: rebuilding index By: BlackSwan on Thu, 28 June 2007 21:13
		Re: rebuilding index By: DreamzZ on Thu, 28 June 2007 22:24
		Re: rebuilding index By: Michel Cadot on Fri, 29 June 2007 01:14
		Re: rebuilding index By: pablolee on Fri, 29 June 2007 03:11
		Re: rebuilding index By: adee_saleh on Fri, 29 June 2007 09:53
		Re: rebuilding index By: Michel Cadot on Fri, 29 June 2007 10:35
		Re: rebuilding index By: rleishman on Fri, 29 June 2007 22:13
		Re: rebuilding index By: adee_saleh on Sat, 30 June 2007 10:58
		Re: rebuilding index By: rleishman on Sun, 01 July 2007 02:10
		Re: rebuilding index By: adee_saleh on Sun, 01 July 2007 08:07
		Re: rebuilding index By: faiz_hyd on Tue, 21 August 2007 14:01
		Re: rebuilding index By: rleishman on Tue, 21 August 2007 22:33
		Re: rebuilding index By: feroze on Wed, 29 August 2007 14:58
		Re: rebuilding index By: rleishman on Wed, 29 August 2007 22:03
		Re: rebuilding index By: BlackSwan on Tue, 21 August 2007 14:14
		Re: rebuilding index By: faiz_hyd on Tue, 21 August 2007 15:02
		Re: rebuilding index By: BlackSwan on Tue, 21 August 2007 15:15

		slow in scanning documents By: vasudevan on Tue, 28 August 2007 13:08
		Re: slow in scanning documents By: vasudevan on Wed, 29 August 2007 08:22

		CBO vs RBO By: rubhatta on Tue, 28 August 2007 11:36
		Re: CBO vs RBO By: Michel Cadot on Tue, 28 August 2007 11:56
		Re: CBO vs RBO By: gintsp on Tue, 28 August 2007 12:55
		Re: CBO vs RBO By: rubhatta on Tue, 28 August 2007 13:52
		Re: CBO vs RBO By: DreamzZ on Tue, 28 August 2007 14:04

		Output of Query is very slow through SQL By: sarfraz_attari on Tue, 28 August 2007 01:46
		Re: Output of Query is very slow through SQL By: Mohammad Taj on Tue, 28 August 2007 01:48
		Re: Output of Query is very slow through SQL By: muzahid on Tue, 28 August 2007 07:20
		Re: Output of Query is very slow through SQL By: Michel Cadot on Tue, 28 August 2007 08:22

		DBMS_APPLICATION_INFO Usage By: orasaket on Fri, 24 August 2007 07:59
		Re: DBMS_APPLICATION_INFO Usage By: rleishman on Fri, 24 August 2007 08:07

		about add more cpus.. By: hot3b3c on Fri, 24 August 2007 03:42
		Re: about add more cpus.. By: Michel Cadot on Fri, 24 August 2007 04:01
		Re: about add more cpus.. By: JRowbottom on Fri, 24 August 2007 05:25

		Baby Tuning !!! By: Creems on Thu, 23 August 2007 15:18
		Re: Baby Tuning !!! By: DreamzZ on Thu, 23 August 2007 15:41

		Too much IO By: marrec on Mon, 20 August 2007 02:46
		Re: Too much IO By: rleishman on Mon, 20 August 2007 03:18
		Re: Too much IO By: marrec on Mon, 20 August 2007 05:15
		Re: Too much IO By: JRowbottom on Thu, 23 August 2007 06:42

		Help-Histogram By: orasaket on Sun, 19 August 2007 10:31
		Re: Help-Histogram By: rleishman on Sun, 19 August 2007 22:08
		Re: Help-Histogram By: orasaket on Wed, 22 August 2007 04:13
		Re: Help-Histogram By: rleishman on Thu, 23 August 2007 03:14

		How to Ping (keep) table in db_keep_cache By: aslamkhalife on Wed, 22 August 2007 02:00
		Re: How to Ping (keep) table in db_keep_cache By: Michel Cadot on Wed, 22 August 2007 02:53
		Re: How to Ping (keep) table in db_keep_cache By: aslamkhalife on Wed, 22 August 2007 03:46

		AWR snap_id sequence By: adam15612 on Mon, 20 August 2007 11:57
		Re: AWR snap_id sequence By: DreamzZ on Mon, 20 August 2007 13:03
		Re: AWR snap_id sequence By: Michel Cadot on Mon, 20 August 2007 13:25
		Re: AWR snap_id sequence By: Michel Cadot on Mon, 20 August 2007 13:32
		Re: AWR snap_id sequence By: adam15612 on Mon, 20 August 2007 13:47
		Re: AWR snap_id sequence By: Michel Cadot on Mon, 20 August 2007 13:54
		Re: AWR snap_id sequence By: adam15612 on Mon, 20 August 2007 13:57

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

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:44:07 CDT 2024