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.

		keep pool By: grpatwari on Wed, 22 April 2009 05:25
		Re: keep pool By: Michel Cadot on Wed, 22 April 2009 05:29
		Re: keep pool By: grpatwari on Wed, 22 April 2009 05:41
		Re: keep pool By: Michel Cadot on Wed, 22 April 2009 05:46
		Re: keep pool By: grpatwari on Wed, 22 April 2009 05:48
		Re: keep pool By: BlackSwan on Wed, 22 April 2009 20:55
		Re: keep pool By: grpatwari on Wed, 22 April 2009 22:22
		Re: keep pool By: JRowbottom on Fri, 24 April 2009 07:20
		Re: keep pool By: grpatwari on Fri, 24 April 2009 07:29
		Re: keep pool By: Michel Cadot on Fri, 24 April 2009 07:44
		Re: keep pool By: JRowbottom on Wed, 29 April 2009 08:53

		Job queue process takes more then 90 % cpu By: sameer_2230 on Wed, 29 April 2009 03:14
		Re: Job queue process takes more then 90 % cpu By: babuknb on Wed, 29 April 2009 03:28
		Re: Job queue process takes more then 90 % cpu By: sameer_2230 on Wed, 29 April 2009 04:32
		Re: Job queue process takes more then 90 % cpu By: babuknb on Wed, 29 April 2009 04:40
		Re: Job queue process takes more then 90 % cpu By: sameer_2230 on Wed, 29 April 2009 04:52
		Re: Job queue process takes more then 90 % cpu By: babuknb on Wed, 29 April 2009 05:33

		DBWR writes entire dirty block ? By: tridentadm on Mon, 27 April 2009 07:13
		Re: DBWR writes entire dirty block ? By: Michel Cadot on Mon, 27 April 2009 08:12
		Re: DBWR writes entire dirty block ? By: tridentadm on Mon, 27 April 2009 11:30
		Re: DBWR writes entire dirty block ? By: Michel Cadot on Mon, 27 April 2009 11:58
		Re: DBWR writes entire dirty block ? By: BlackSwan on Mon, 27 April 2009 12:12

		Hints USE_HASH (merged) By: Anne Simms on Tue, 31 March 2009 10:39
		Re: Hints USE_HASH By: rleishman on Wed, 01 April 2009 05:20
		Re: Hints USE_HASH By: Anne Simms on Wed, 01 April 2009 07:37
		Re: Hints USE_HASH By: Anne Simms on Wed, 01 April 2009 09:18
		Re: Hints USE_HASH By: Anne Simms on Mon, 06 April 2009 13:50
		Re: Hints USE_HASH By: Michel Cadot on Tue, 07 April 2009 00:37
		Re: Hints USE_HASH By: Anne Simms on Tue, 07 April 2009 09:26
		Re: Hints USE_HASH By: scottwmackey on Thu, 23 April 2009 22:49
		Re: Hints USE_HASH By: Anne Simms on Mon, 27 April 2009 08:28
		Re: Hints USE_HASH (merged) By: BlackSwan on Mon, 06 April 2009 14:00
		Re: Hints USE_HASH (merged) By: coleing on Mon, 06 April 2009 17:13
		Re: Hints USE_HASH (merged) By: Anne Simms on Tue, 07 April 2009 13:20
		Re: Hints USE_HASH (merged) By: BlackSwan on Tue, 07 April 2009 17:17
		Re: Hints USE_HASH (merged) By: Anne Simms on Wed, 08 April 2009 07:58
		Re: Hints USE_HASH (merged) By: coleing on Wed, 08 April 2009 01:26

		SQL PERFORMANCE ANALYZER By: rsreddy28 on Sun, 26 April 2009 05:48
		Re: SQL PERFORMANCE ANALYZER By: Mahesh Rajendran on Sun, 26 April 2009 08:09

		Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Fri, 17 April 2009 00:51
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: rleishman on Sat, 18 April 2009 23:47
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Sun, 19 April 2009 23:31
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: rleishman on Tue, 21 April 2009 22:06
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Wed, 22 April 2009 02:11
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: rleishman on Wed, 22 April 2009 21:42
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Thu, 23 April 2009 05:34
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: rleishman on Thu, 23 April 2009 22:27
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Sat, 25 April 2009 00:09
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Sat, 25 April 2009 01:14
		Re: Query Rewrite Failed After RLS policy applied(QSM-01284) By: rleishman on Sat, 25 April 2009 21:31

		PL SQL performance tuning By: vinod_tiwari on Tue, 21 April 2009 01:37
		Re: PL SQL performance tuning By: user2004 on Tue, 21 April 2009 03:43
		Re: PL SQL performance tuning By: vinod_tiwari on Tue, 21 April 2009 04:55
		Re: PL SQL performance tuning By: rleishman on Tue, 21 April 2009 22:01

The difference of execution plans

By: dingwei on Sun, 19 April 2009 01:11

		SQL too slow By: rzkhan on Thu, 16 April 2009 00:04
		Re: SQL too slow By: trantuananh24hg on Thu, 16 April 2009 03:49
		Re: SQL too slow By: ahudspith on Thu, 16 April 2009 08:46
		Re: SQL too slow By: rzkhan on Thu, 16 April 2009 21:43
		Re: SQL too slow By: trantuananh24hg on Thu, 16 April 2009 21:52
		Re: SQL too slow By: rzkhan on Thu, 16 April 2009 22:30
		Re: SQL too slow By: trantuananh24hg on Thu, 16 April 2009 22:45
		Re: SQL too slow By: rzkhan on Fri, 17 April 2009 02:00
		Re: SQL too slow By: BlackSwan on Fri, 17 April 2009 08:47

		Query is getting stuck after adding one filter condition is where clause By: gurinder_mann2004 on Fri, 10 April 2009 03:10
		Re: Query is getting stuck after adding one filter condition is where claus... By: vamsi kasina on Fri, 10 April 2009 11:04
		Re: Query is getting stuck after adding one filter condition is where claus... By: gurinder_mann2004 on Sun, 12 April 2009 22:43
		Re: Query is getting stuck after adding one filter condition is where claus... By: dasu1232001 on Mon, 13 April 2009 00:15
		Re: Query is getting stuck after adding one filter condition is where claus... By: dasu1232001 on Mon, 13 April 2009 00:51
		Re: Query is getting stuck after adding one filter condition is where claus... By: gurinder_mann2004 on Mon, 13 April 2009 03:41
		Re: Query is getting stuck after adding one filter condition is where claus... By: dasu1232001 on Mon, 13 April 2009 23:26
		Re: Query is getting stuck after adding one filter condition is where claus... By: dasu1232001 on Mon, 13 April 2009 23:49
		Re: Query is getting stuck after adding one filter condition is where claus... By: gurinder_mann2004 on Fri, 17 April 2009 00:15

		problem while generating AWR report By: rituraj on Tue, 14 April 2009 23:43
		Re: problem while generating AWR report By: Mahesh Rajendran on Wed, 15 April 2009 00:13
		Re: problem while generating AWR report By: rituraj on Thu, 16 April 2009 10:22
		Re: problem while generating AWR report By: Mahesh Rajendran on Thu, 16 April 2009 10:37
		Re: problem while generating AWR report By: BlackSwan on Thu, 16 April 2009 10:25
		Re: problem while generating AWR report By: rituraj on Thu, 16 April 2009 10:55
		Re: problem while generating AWR report By: Mahesh Rajendran on Thu, 16 April 2009 11:00
		Re: problem while generating AWR report By: rituraj on Thu, 16 April 2009 11:51
		Re: problem while generating AWR report By: Mahesh Rajendran on Thu, 16 April 2009 12:01

		improve the performance (merged 2) By: swas_fly on Wed, 15 April 2009 23:29
		Re: improving query performance By: BlackSwan on Wed, 15 April 2009 23:34
		improve the performance By: swas_fly on Wed, 15 April 2009 23:34
		Re: improve the performance By: BlackSwan on Wed, 15 April 2009 23:36
		Re: improve the performance By: swas_fly on Wed, 15 April 2009 23:46
		Re: improve the performance By: Michel Cadot on Wed, 15 April 2009 23:40
		Re: improve the performance By: swas_fly on Wed, 15 April 2009 23:49
		Re: improve the performance By: Michel Cadot on Thu, 16 April 2009 00:36
		Re: improve the performance By: JRowbottom on Thu, 16 April 2009 06:36
		Re: improve the performance By: JRowbottom on Thu, 16 April 2009 06:40
		Re: improving query performance By: Michel Cadot on Wed, 15 April 2009 23:39

		want to change snap level in 10g r2 By: rituraj on Tue, 14 April 2009 12:39
		Re: want to change snap level in 10g r2 By: BlackSwan on Tue, 14 April 2009 12:42

		improving query performance By: swas_fly on Tue, 14 April 2009 10:26
		Re: improving query performance By: Michel Cadot on Tue, 14 April 2009 12:29

		Explain Plan By: vinniora on Tue, 14 April 2009 00:52
		Re: Explain Plan By: Michel Cadot on Tue, 14 April 2009 01:13

		TKprof shows fetching taking long time By: spur230 on Wed, 01 April 2009 13:53
		Re: TKprof shows fetching taking long time By: BlackSwan on Thu, 02 April 2009 09:37
		Re: TKprof shows fetching taking long time By: ajitpal.s on Fri, 03 April 2009 08:35
		Re: TKprof shows fetching taking long time By: mayur316 on Sun, 12 April 2009 02:49
		Re: TKprof shows fetching taking long time By: rleishman on Sun, 12 April 2009 18:30
		Re: TKprof shows fetching taking long time By: spur230 on Sun, 12 April 2009 19:13
		Re: TKprof shows fetching taking long time By: BlackSwan on Sun, 12 April 2009 20:06
		Re: TKprof shows fetching taking long time By: rleishman on Sun, 12 April 2009 23:16

		create dynamic partitions in oracle 9 By: parasuramchekuri on Fri, 10 April 2009 08:45
		Re: create dynamic partitions in oracle 9 By: BlackSwan on Fri, 10 April 2009 08:48
		Re: create dynamic partitions in oracle 9 By: Michel Cadot on Fri, 10 April 2009 08:50
		Re: create dynamic partitions in oracle 9 By: parasuramchekuri on Fri, 10 April 2009 08:52
		Re: create dynamic partitions in oracle 9 By: Michel Cadot on Fri, 10 April 2009 08:55
		Re: create dynamic partitions in oracle 9 By: parasuramchekuri on Fri, 10 April 2009 08:59
		Re: create dynamic partitions in oracle 9 By: Michel Cadot on Fri, 10 April 2009 11:13
		Re: create dynamic partitions in oracle 9 By: rleishman on Sat, 11 April 2009 07:25
		Re: create dynamic partitions in oracle 9 By: BlackSwan on Fri, 10 April 2009 08:57
		Re: create dynamic partitions in oracle 9 By: BlackSwan on Fri, 10 April 2009 09:05

		Bind variable versus CURSOR_SHARING='SIMILAR' By: shrinika on Fri, 10 April 2009 21:25
		Re: Bind variable versus CURSOR_SHARING='SIMILAR' By: trantuananh24hg on Fri, 10 April 2009 22:16
		Re: Bind variable versus CURSOR_SHARING='SIMILAR' By: shrinika on Fri, 10 April 2009 22:54
		Re: Bind variable versus CURSOR_SHARING='SIMILAR' By: trantuananh24hg on Fri, 10 April 2009 23:19

		List partition and Index partitioning (merged) By: jimit_shaili on Mon, 06 April 2009 01:03
		Re: List partition and Index partitioning By: BlackSwan on Mon, 06 April 2009 01:06
		Re: List partition and Index partitioning By: jimit_shaili on Mon, 06 April 2009 01:25
		Re: List partition and Index partitioning By: jimit_shaili on Mon, 06 April 2009 01:28
		Re: List partition and Index partitioning By: jimit_shaili on Mon, 06 April 2009 01:57
		Re: List partition and Index partitioning By: jimit_shaili on Tue, 07 April 2009 01:03
		Re: List partition and Index partitioning By: Michel Cadot on Tue, 07 April 2009 01:24
		Re: List partition and Index partitioning By: jimit_shaili on Tue, 07 April 2009 23:47
		Re: List partition and Index partitioning By: BlackSwan on Tue, 07 April 2009 23:50
		Index partitioning By: jimit_shaili on Thu, 09 April 2009 03:06
		Re: Index partitioning By: Michel Cadot on Thu, 09 April 2009 03:10
		Re: List partition and Index partitioning (merged) By: jimit_shaili on Thu, 09 April 2009 04:02
		Re: List partition and Index partitioning (merged) By: jimit_shaili on Thu, 09 April 2009 05:37
		Re: List partition and Index partitioning (merged) By: rleishman on Thu, 09 April 2009 22:03
		Re: List partition and Index partitioning (merged) By: jimit_shaili on Fri, 10 April 2009 00:34

		Can any one help me to tune this query. By: vipinsonkar2000 on Sat, 04 April 2009 01:10
		Re: Can any one help me to tune this query. By: Michel Cadot on Sat, 04 April 2009 01:25
		Re: Can any one help me to tune this query. By: vipinsonkar2000 on Sat, 04 April 2009 01:48
		Re: Can any one help me to tune this query. By: Michel Cadot on Sat, 04 April 2009 02:38
		Re: Can any one help me to tune this query. By: BlackSwan on Sat, 04 April 2009 09:20
		Re: Can any one help me to tune this query. By: vipinsonkar2000 on Mon, 06 April 2009 01:50
		Re: Can any one help me to tune this query. By: Michel Cadot on Mon, 06 April 2009 01:57
		Re: Can any one help me to tune this query. By: BlackSwan on Mon, 06 April 2009 01:55
		Re: Can any one help me to tune this query. By: vipinsonkar2000 on Mon, 06 April 2009 03:48
		Re: Can any one help me to tune this query. By: JRowbottom on Thu, 09 April 2009 05:07

		PCTFREE and PCTUSED By: nandusb on Sat, 21 March 2009 04:43
		Re: PCTFREE and PCTUSED By: Michel Cadot on Sat, 21 March 2009 04:54
		Re: PCTFREE and PCTUSED By: nandusb on Sat, 21 March 2009 05:27
		Re: PCTFREE and PCTUSED By: BlackSwan on Sat, 21 March 2009 09:49
		Re: PCTFREE and PCTUSED By: rakesh.c.purohit on Thu, 09 April 2009 02:08
		Re: PCTFREE and PCTUSED By: Michel Cadot on Thu, 09 April 2009 02:39

		Report Taking So Much Of Time and goes into ORA-01555 By: sumitgarg on Wed, 08 April 2009 05:35
		Re: Report Taking So Much Of Time and goes into ORA-01555 By: sumitgarg on Wed, 08 April 2009 07:05
		Re: Report Taking So Much Of Time and goes into ORA-01555 By: cookiemonster on Wed, 08 April 2009 07:26
		Re: Report Taking So Much Of Time and goes into ORA-01555 By: BlackSwan on Wed, 08 April 2009 22:25
		Re: Report Taking So Much Of Time and goes into ORA-01555 By: sumitgarg on Wed, 08 April 2009 23:13

		how to optimize sql for query big table? (merged 3) By: kevin_ye on Wed, 08 April 2009 04:48
		how to optimize sql for query big table? By: kevin_ye on Wed, 08 April 2009 04:55
		Re: how to optimize sql for query big table? (merged 3) By: BlackSwan on Wed, 08 April 2009 13:34
		Re: how to optimize sql for query big table? (merged 3) By: kevin_ye on Wed, 08 April 2009 21:25

		SQL Tuning Help By: crazykuda on Wed, 08 April 2009 14:17
		Re: SQL Tuning Help By: BlackSwan on Wed, 08 April 2009 15:08

		ORA-00604: error occurred at recursive SQL level x By: rakesh.c.purohit on Wed, 08 April 2009 08:34
		Re: ORA-00604: error occurred at recursive SQL level x By: Mahesh Rajendran on Wed, 08 April 2009 08:47

		v$session output By: loveoracle on Mon, 06 April 2009 11:43
		Re: v$session output By: BlackSwan on Mon, 06 April 2009 11:52
		Re: v$session output By: loveoracle on Mon, 06 April 2009 11:57
		Re: v$session output By: Michel Cadot on Mon, 06 April 2009 12:07
		Re: v$session output By: loveoracle on Mon, 06 April 2009 12:12
		Re: v$session output By: Michel Cadot on Mon, 06 April 2009 12:44
		Re: v$session output By: loveoracle on Tue, 07 April 2009 02:27
		Re: v$session output By: Michel Cadot on Tue, 07 April 2009 02:58
		Re: v$session output By: loveoracle on Tue, 07 April 2009 04:24
		Re: v$session output By: Michel Cadot on Tue, 07 April 2009 05:55

		Temp Tablespace usage By: dbcop on Sat, 04 April 2009 09:50
		Re: Temp Tablespace usage By: oraxperts on Sat, 04 April 2009 19:18

		difference between analyze table and dbms_stats.gatherstatistic By: rituraj on Thu, 02 April 2009 09:21
		Re: difference between analyze table and dbms_stats.gatherstatistic By: Michel Cadot on Thu, 02 April 2009 09:24
		Re: difference between analyze table and dbms_stats.gatherstatistic By: BlackSwan on Thu, 02 April 2009 09:25

		'show parameter allow' doesnt work By: rituraj on Wed, 01 April 2009 13:45
		Re: 'show parameter allow' doesnt work By: Michel Cadot on Wed, 01 April 2009 13:48
		Re: 'show parameter allow' doesnt work By: rituraj on Wed, 01 April 2009 13:55
		Re: 'show parameter allow' doesnt work By: BlackSwan on Wed, 01 April 2009 13:49
		Re: 'show parameter allow' doesnt work By: BlackSwan on Wed, 01 April 2009 13:50
		Re: 'show parameter allow' doesnt work By: rituraj on Wed, 01 April 2009 13:55

		how to give kill session priviledge to normal user By: rituraj on Wed, 01 April 2009 10:57
		Re: how to give kill session priviledge to normal user By: JRowbottom on Wed, 01 April 2009 11:00
		Re: how to give kill session priviledge to normal user By: Mahesh Rajendran on Wed, 01 April 2009 11:00
		Re: how to give kill session priviledge to normal user By: Michel Cadot on Wed, 01 April 2009 11:14

		contention on temprary tablespace By: rituraj on Wed, 01 April 2009 10:46
		Re: contention on temprary tablespace By: Mahesh Rajendran on Wed, 01 April 2009 10:50
		Re: contention on temprary tablespace By: rituraj on Wed, 01 April 2009 11:06
		Re: contention on temprary tablespace By: Mahesh Rajendran on Wed, 01 April 2009 11:12

		Performance degrades suddenly. By: it_me24 on Mon, 30 March 2009 11:32
		Re: Performance degrades suddenly. By: Mahesh Rajendran on Mon, 30 March 2009 12:19
		Re: Performance degrades suddenly. By: it_me24 on Mon, 30 March 2009 13:18
		Re: Performance degrades suddenly. By: Mahesh Rajendran on Mon, 30 March 2009 13:25
		Re: Performance degrades suddenly. By: it_me24 on Mon, 30 March 2009 13:21
		Re: Performance degrades suddenly. By: it_me24 on Mon, 30 March 2009 13:37
		Re: Performance degrades suddenly. By: Mahesh Rajendran on Mon, 30 March 2009 14:21
		Re: Performance degrades suddenly. By: rleishman on Tue, 31 March 2009 02:00
		Re: Performance degrades suddenly. By: it_me24 on Wed, 01 April 2009 00:12
		Re: Performance degrades suddenly. By: dingwei on Wed, 01 April 2009 03:13
		Re: Performance degrades suddenly. By: rleishman on Wed, 01 April 2009 05:12

		bad index choose when using rownum < 9 or less By: lionel.ducret on Tue, 31 March 2009 04:44
		Re: bad index choose when using rownum < 9 or less By: dingwei on Wed, 01 April 2009 03:15

		KEEP POOL By: AlinaC on Tue, 31 March 2009 20:50
		Re: KEEP POOL By: BlackSwan on Tue, 31 March 2009 20:53
		Re: KEEP POOL By: AlinaC on Tue, 31 March 2009 20:56
		Re: KEEP POOL By: BlackSwan on Tue, 31 March 2009 21:06

		What if not give any ext in datafile........ By: sameer_2230 on Sat, 28 March 2009 02:08
		Re: What if not give any ext in datafile........ By: Mahesh Rajendran on Sat, 28 March 2009 06:14
		Re: What if not give any ext in datafile........ By: JRowbottom on Mon, 30 March 2009 10:09

AWR report analysis

By: John Charles on Mon, 30 March 2009 02:34

		Performance tuning By: avrillavinge on Fri, 27 March 2009 00:47
		Re: Performance tuning By: BlackSwan on Fri, 27 March 2009 00:49
		Re: Performance tuning By: avrillavinge on Fri, 27 March 2009 04:44
		Re: Performance tuning By: cookiemonster on Fri, 27 March 2009 04:54
		Re: Performance tuning By: avrillavinge on Fri, 27 March 2009 04:57

		Tkprof trace file meaning By: sr_orcl on Thu, 26 March 2009 06:38
		Re: Tkprof trace file meaning By: ThomasG on Thu, 26 March 2009 06:42
		Re: Tkprof trace file meaning By: sr_orcl on Thu, 26 March 2009 06:45
		Re: Tkprof trace file meaning By: BlackSwan on Thu, 26 March 2009 09:53

		statspack error By: somavamshi on Fri, 20 July 2007 01:18
		Re: statspack error By: Michel Cadot on Fri, 20 July 2007 01:26
		Re: statspack error By: DreamzZ on Fri, 20 July 2007 09:29
		Re: statspack error By: Michel Cadot on Fri, 20 July 2007 10:48
		Re: statspack error By: DreamzZ on Fri, 20 July 2007 10:58
		Re: statspack error By: Michel Cadot on Fri, 20 July 2007 11:22
		Re: statspack error By: Arsitobule on Tue, 24 March 2009 10:44
		Re: statspack error By: BlackSwan on Tue, 24 March 2009 10:49

		Performance tuning By: sivakumar.rj on Mon, 23 March 2009 02:10
		Re: Performance tuning By: Michel Cadot on Mon, 23 March 2009 02:13
		Re: Performance tuning By: JRowbottom on Tue, 24 March 2009 08:40

Pages (119): [ « ‹ 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 › »]

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 22:10:52 CDT 2024