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.

		Join Query problem. One using index while another full table scan By: honeybee on Thu, 14 September 2006 22:11
		Re: Join Query problem. One using index while another full table scan By: rleishman on Fri, 15 September 2006 00:34
		Re: Join Query problem. One using index while another full table scan By: honeybee on Fri, 15 September 2006 01:01
		Re: Join Query problem. One using index while another full table scan By: rleishman on Fri, 15 September 2006 23:20

		problems with updating big table by commit at end By: coral_3 on Thu, 14 September 2006 09:05
		Re: problems with updating big table by commit at end By: Mahesh Rajendran on Thu, 14 September 2006 09:10
		Re: problems with updating big table by commit at end By: rleishman on Fri, 15 September 2006 00:26
		Re: problems with updating big table by commit at end By: coral_3 on Fri, 15 September 2006 10:11

		Number of Datafiles in a Tablespace By: faiz_hyd on Fri, 15 September 2006 09:38
		Re: Number of Datafiles in a Tablespace By: Mahesh Rajendran on Fri, 15 September 2006 09:44
		Re: Number of Datafiles in a Tablespace By: faiz_hyd on Fri, 15 September 2006 10:04

		Estimate_Percent for Analyze Schema By: rkulasek on Tue, 12 September 2006 00:32
		Re: Estimate_Percent for Analyze Schema By: Mahesh Rajendran on Tue, 12 September 2006 03:56
		Re: Estimate_Percent for Analyze Schema By: rkulasek on Tue, 12 September 2006 04:56
		Re: Estimate_Percent for Analyze Schema By: Mahesh Rajendran on Tue, 12 September 2006 08:18
		Re: Estimate_Percent for Analyze Schema By: rkulasek on Thu, 14 September 2006 00:25

		Analyze increases cost By: manish mendiratta on Wed, 13 September 2006 20:21
		Re: Analyze increases cost By: rleishman on Wed, 13 September 2006 21:31

		help with coming up a test case! By: orausern on Mon, 11 September 2006 07:23
		Re: help with coming up a test case! By: Liza79 on Mon, 11 September 2006 07:54
		Re: help with coming up a test case! By: orausern on Mon, 11 September 2006 10:24
		Re: help with coming up a test case! By: rleishman on Tue, 12 September 2006 06:38
		Re: help with coming up a test case! By: orausern on Tue, 12 September 2006 09:32
		Re: help with coming up a test case! By: JRowbottom on Wed, 13 September 2006 07:29

		Merge Partition into 1 single partition By: faiz_hyd on Tue, 12 September 2006 13:48
		Re: Merge Partition into 1 single partition By: email.sandeepnaik on Tue, 12 September 2006 21:23

		sql_trace question By: rkl1 on Mon, 11 September 2006 14:01
		Re: sql_trace question By: AndreyPozhidaev on Tue, 12 September 2006 03:45

		enable Full-Text Search By: javed122 on Mon, 11 September 2006 06:02
		Re: enable Full-Text Search By: ebrian on Mon, 11 September 2006 08:44
		Re: enable Full-Text Search By: javed122 on Mon, 11 September 2006 09:08

		Scale of DBA_HIST_SQLSTAT values By: kwalz58 on Thu, 07 September 2006 11:09
		Re: Scale of DBA_HIST_SQLSTAT values By: shoblock on Sun, 10 September 2006 14:25
		Re: Scale of DBA_HIST_SQLSTAT values By: kwalz58 on Mon, 11 September 2006 09:06

		other buffer pool .... cache sizes ?? By: tridentadm on Thu, 07 September 2006 22:43
		Re: other buffer pool .... cache sizes ?? By: tarundua on Fri, 08 September 2006 01:17
		Re: other buffer pool .... cache sizes ?? By: JSI2001 on Fri, 08 September 2006 03:05
		Re: other buffer pool .... cache sizes ?? By: tarundua on Fri, 08 September 2006 03:52
		Re: other buffer pool .... cache sizes ?? By: JSI2001 on Fri, 08 September 2006 03:58
		Re: other buffer pool .... cache sizes ?? By: goudelly on Fri, 08 September 2006 09:27
		Re: other buffer pool .... cache sizes ?? By: JSI2001 on Fri, 08 September 2006 09:32

		Big data Inserts By: rkl1 on Fri, 18 August 2006 12:47
		Re: Big data Inserts By: nmacdannald on Fri, 18 August 2006 13:29
		Re: Big data Inserts By: kimant on Fri, 08 September 2006 05:03
		Re: Big data Inserts By: rleishman on Fri, 08 September 2006 07:48
		Re: Big data Inserts By: goudelly on Fri, 08 September 2006 09:17

		inserting data in append mode .. what adv ?? By: tridentadm on Mon, 04 September 2006 05:43
		Re: inserting data in append mode .. what adv ?? By: wagnerch on Mon, 04 September 2006 06:42
		Re: inserting data in append mode .. what adv ?? By: goudelly on Fri, 08 September 2006 09:07

		Index Usage and SQL Tuning Question By: mohannemani on Thu, 07 September 2006 17:15
		Re: Index Usage and SQL Tuning Question By: BlackSwan on Thu, 07 September 2006 17:43
		Re: Index Usage and SQL Tuning Question By: rleishman on Fri, 08 September 2006 07:45

		column to look for in v$system_event By: tridentadm on Thu, 07 September 2006 00:01
		Re: column to look for in v$system_event By: tarundua on Thu, 07 September 2006 04:28
		Re: column to look for in v$system_event By: tridentadm on Thu, 07 September 2006 23:24
		Re: column to look for in v$system_event By: tarundua on Fri, 08 September 2006 01:07

shared pool, invalidations and creation indexes ??

By: tridentadm on Thu, 07 September 2006 22:42

		ORA-01652 - Temporary Tablespace problems!! By: Tizza on Tue, 05 September 2006 10:52
		Re: ORA-01652 - Temporary Tablespace problems!! By: BlackSwan on Tue, 05 September 2006 11:27
		Re: ORA-01652 - Temporary Tablespace problems!! By: wwllzpz on Wed, 06 September 2006 02:34

		Hash join hint not being used By: speaker on Tue, 05 September 2006 05:32
		Re: Hash join hint not being used By: rleishman on Tue, 05 September 2006 07:33
		Re: Hash join hint not being used By: kimant on Tue, 05 September 2006 07:54
		Re: Hash join hint not being used By: kimant on Tue, 05 September 2006 07:56
		Re: Hash join hint not being used By: rleishman on Wed, 06 September 2006 01:18

		advantage of append mode ?? By: tridentadm on Mon, 04 September 2006 05:59
		Re: advantage of append mode ?? By: aorehek on Mon, 04 September 2006 07:38
		Re: advantage of append mode ?? By: ebrian on Tue, 05 September 2006 11:12

		analyze table By: bahy91 on Tue, 05 September 2006 07:29
		Re: analyze table By: Mahesh Rajendran on Tue, 05 September 2006 07:33
		Re: analyze table By: bahy91 on Tue, 05 September 2006 07:39
		Re: analyze table By: Mahesh Rajendran on Tue, 05 September 2006 07:44

		Check if the Index is performing good or not By: bahy91 on Mon, 04 September 2006 09:02
		Re: Check if the Index is performing good or not By: BlackSwan on Mon, 04 September 2006 10:10
		Re: Check if the Index is performing good or not By: bahy91 on Tue, 05 September 2006 07:30
		Re: Check if the Index is performing good or not By: Mahesh Rajendran on Tue, 05 September 2006 07:35
		Re: Check if the Index is performing good or not By: rleishman on Tue, 05 September 2006 07:36

		Performance tuning SQL By: speaker on Fri, 01 September 2006 02:26
		Re: Performance tuning SQL By: kimant on Fri, 01 September 2006 02:48
		Re: Performance tuning SQL By: JSI2001 on Fri, 01 September 2006 05:02
		Re: Performance tuning SQL By: BlackSwan on Fri, 01 September 2006 20:57

		Cursor time out error(open cursor on bottleneck) By: pareshr on Fri, 01 September 2006 06:29
		Re: Cursor time out error(open cursor on bottleneck) By: BlackSwan on Fri, 01 September 2006 20:48

		db file scattered and sequential read wait events ? By: tridentadm on Fri, 01 September 2006 01:12
		Re: db file scattered and sequential read wait events ? By: kimant on Fri, 01 September 2006 02:39

		how to calculate shared pool size ?? By: tridentadm on Thu, 31 August 2006 04:37
		Re: how to calculate shared pool size ?? By: Frank Naude on Thu, 31 August 2006 04:43

		when was COST optimizer introduced ? By: tridentadm on Wed, 30 August 2006 04:00
		Re: when was COST optimizer introduced ? By: wagnerch on Wed, 30 August 2006 05:37
		Re: when was COST optimizer introduced ? By: seemit on Wed, 30 August 2006 05:43
		Re: when was COST optimizer introduced ? By: JRowbottom on Thu, 31 August 2006 03:30

		what to do about this one !!! By: seemit on Wed, 30 August 2006 05:31
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 05:42
		Re: what to do about this one !!! By: seemit on Wed, 30 August 2006 05:58
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 06:57
		Re: what to do about this one !!! By: seemit on Wed, 30 August 2006 07:06
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 07:06
		Re: what to do about this one !!! By: seemit on Wed, 30 August 2006 07:16
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 07:23
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 07:30
		Re: what to do about this one !!! By: seemit on Wed, 30 August 2006 07:46
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 07:48
		Re: what to do about this one !!! By: wagnerch on Wed, 30 August 2006 07:58
		Re: what to do about this one !!! By: seemit on Wed, 30 August 2006 08:31

		Oracle 9i redo logging performance poor in relation to DB2 on Solaris. Plea... By: adamb on Fri, 18 August 2006 09:52
		Re: Oracle 9i redo logging performance poor in relation to DB2 on Solaris. ... By: oracleminded on Fri, 18 August 2006 21:17
		Re: Oracle 9i redo logging performance poor in relation to DB2 on Solaris. ... By: adamb on Wed, 30 August 2006 06:32

		Temp Data files Size By: mian imran on Tue, 29 August 2006 04:22
		Re: Temp Data files Size By: Mahesh Rajendran on Tue, 29 August 2006 05:03
		Re: Temp Data files Size By: mian imran on Wed, 30 August 2006 00:16

		Large Volume Updates And Performance By: Jackofalltrades on Tue, 29 August 2006 10:03
		Re: Large Volume Updates And Performance By: BlackSwan on Tue, 29 August 2006 10:29
		Re: Large Volume Updates And Performance By: Jackofalltrades on Tue, 29 August 2006 12:24
		Re: Large Volume Updates And Performance By: wagnerch on Tue, 29 August 2006 12:53
		Re: Large Volume Updates And Performance By: rleishman on Tue, 29 August 2006 23:02

Connection Latency

By: amit.pansare on Mon, 28 August 2006 15:05

		SLOW Updates By: dpodborny on Fri, 25 August 2006 16:22
		Re: SLOW Updates By: nmacdannald on Fri, 25 August 2006 20:02
		Re: SLOW Updates By: rleishman on Mon, 28 August 2006 00:24
		Re: SLOW Updates By: dpodborny on Mon, 28 August 2006 08:05
		Re: SLOW Updates By: dpodborny on Mon, 28 August 2006 07:57

		Analyze Command By: javed122 on Fri, 25 August 2006 07:15
		Re: Analyze Command By: aorehek on Fri, 25 August 2006 07:36
		Re: Analyze Command By: javed122 on Fri, 25 August 2006 08:00
		Re: Analyze Command By: ebrian on Sat, 26 August 2006 08:20
		Re: Analyze Command By: javed122 on Mon, 28 August 2006 02:42

		the outline error why By: lazycat on Fri, 25 August 2006 01:25
		Re: the outline error why By: Mahesh Rajendran on Fri, 25 August 2006 02:59
		Re: the outline error why By: lazycat on Fri, 25 August 2006 03:00
		Re: the outline error why By: lazycat on Fri, 25 August 2006 03:09

		Oracle 9.0.2.7 enterprise problem By: hvvaghani on Tue, 01 August 2006 03:40
		Re: Oracle 9.0.2.7 enterprise problem By: nmacdannald on Sun, 06 August 2006 07:47
		Re: Oracle 9.0.2.7 enterprise problem By: pabs on Wed, 23 August 2006 11:00

		Shared Pool sizing By: kudur_kv on Tue, 22 August 2006 08:13
		Re: Shared Pool sizing By: tongucy on Tue, 22 August 2006 15:05
		Re: Shared Pool sizing By: Mahesh Rajendran on Tue, 22 August 2006 18:25
		Re: Shared Pool sizing By: tongucy on Wed, 23 August 2006 01:54
		Re: Shared Pool sizing By: Mahesh Rajendran on Wed, 23 August 2006 04:55
		Re: Shared Pool sizing By: kudur_kv on Wed, 23 August 2006 04:57
		Re: Shared Pool sizing By: Mahesh Rajendran on Wed, 23 August 2006 07:52
		Re: Shared Pool sizing By: kudur_kv on Wed, 23 August 2006 10:59

		Udmp Traces By: wahdany60 on Mon, 21 August 2006 05:29
		Re: Udmp Traces By: tongucy on Tue, 22 August 2006 15:08
		Re: Udmp Traces By: wahdany60 on Tue, 22 August 2006 15:35
		Re: Udmp Traces By: Yasir Hashmi on Tue, 22 August 2006 15:53
		Re: Udmp Traces By: wahdany60 on Tue, 22 August 2006 15:57
		Re: Udmp Traces By: Yasir Hashmi on Tue, 22 August 2006 16:16
		Re: Udmp Traces By: wahdany60 on Tue, 22 August 2006 16:20
		Re: Udmp Traces By: Yasir Hashmi on Tue, 22 August 2006 16:43
		Re: Udmp Traces By: Yasir Hashmi on Tue, 22 August 2006 17:07
		Re: Udmp Traces By: tongucy on Wed, 23 August 2006 01:50
		Re: Udmp Traces By: wahdany60 on Wed, 23 August 2006 09:47

		Index Use and Renaming Partitions By: faiz_hyd on Mon, 21 August 2006 10:26
		Re: Index Use and Renaming Partitions By: rleishman on Tue, 22 August 2006 05:00
		Re: Index Use and Renaming Partitions By: faiz_hyd on Tue, 22 August 2006 09:03
		Re: Index Use and Renaming Partitions By: rleishman on Wed, 23 August 2006 04:31

		Temp segment issue By: kudur_kv on Thu, 17 August 2006 12:14
		Re: Temp segment issue By: Mahesh Rajendran on Thu, 17 August 2006 12:39
		Re: Temp segment issue By: kudur_kv on Fri, 18 August 2006 04:10
		Re: Temp segment issue By: Mahesh Rajendran on Fri, 18 August 2006 05:01
		Re: Temp segment issue By: kudur_kv on Tue, 22 August 2006 11:21

		STATSPACK question on 10g and 8i By: toshidas2000 on Thu, 20 July 2006 13:36
		Re: STATSPACK question on 10g and 8i By: Frank Naude on Tue, 25 July 2006 03:10
		Re: STATSPACK question on 10g and 8i By: alexdabr on Tue, 22 August 2006 03:36

Pages (119): [ « ‹ 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Wed Jun 26 09:05:47 CDT 2024