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.

		ORACLE TUNING PROBLEM ON LAPTOP By: gaupa on Mon, 02 January 2006 00:08
		Re: ORACLE TUNING PROBLEM ON LAPTOP By: Frank on Mon, 02 January 2006 00:12
		Re: ORACLE TUNING PROBLEM ON LAPTOP By: gaupa on Mon, 02 January 2006 00:17
		Re: ORACLE TUNING PROBLEM ON LAPTOP By: Frank on Mon, 02 January 2006 00:28
		Re: ORACLE TUNING PROBLEM ON LAPTOP By: gaupa on Mon, 02 January 2006 01:26
		Re: ORACLE TUNING PROBLEM ON LAPTOP By: smartin on Tue, 10 January 2006 10:56

		Plan-table By: IA on Sun, 08 January 2006 23:18
		Re: Plan-table By: smartin on Tue, 10 January 2006 10:50

		Poor performance database.. pls help me By: genialsenthil on Thu, 24 November 2005 01:35
		Re: Poor performance database.. pls help me By: Mahesh Rajendran on Thu, 24 November 2005 04:36
		Re: Poor performance database.. pls help me By: Mahesh Rajendran on Thu, 24 November 2005 04:45
		Re: Poor performance database.. pls help me By: genialsenthil on Fri, 25 November 2005 06:24
		Re: Poor performance database.. pls help me By: Mahesh Rajendran on Fri, 25 November 2005 08:42
		Re: Poor performance database.. pls help me By: sunil_v_mishra on Fri, 25 November 2005 13:39
		Error in Clob Retrival .. Pls help me [Urgent] By: genialsenthil on Mon, 05 December 2005 05:41
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: Mahesh Rajendran on Mon, 05 December 2005 09:00
		Re: Poor performance database.. pls help me By: smartin on Mon, 05 December 2005 12:10
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: genialsenthil on Mon, 05 December 2005 23:25
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: goryunov on Wed, 07 December 2005 16:58
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: genialsenthil on Mon, 19 December 2005 02:47
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: goryunov on Mon, 19 December 2005 17:38
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: goryunov on Mon, 19 December 2005 18:05
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: genialsenthil on Wed, 21 December 2005 02:43
		Re: Error in Clob Retrival .. Pls help me [Urgent] By: SQLAREA on Sun, 08 January 2006 10:26
		Re: Poor performance database.. pls help me By: goryunov on Wed, 07 December 2005 17:21

		shared pool doubt..? By: balavignesh on Wed, 04 January 2006 15:03
		Re: shared pool doubt..? By: mchadder on Wed, 04 January 2006 15:42
		Re: shared pool doubt..? By: JSI2001 on Thu, 05 January 2006 09:50
		Re: shared pool doubt..? By: SQLAREA on Sun, 08 January 2006 06:32

		COMPLEX SQL,NESTED By: feroze on Fri, 06 January 2006 09:41
		Re: COMPLEX SQL,NESTED By: Frank on Fri, 06 January 2006 11:36
		Re: COMPLEX SQL,NESTED By: feroze on Fri, 06 January 2006 13:02
		Re: COMPLEX SQL,NESTED By: mchadder on Fri, 06 January 2006 13:40
		Re: COMPLEX SQL,NESTED By: mchadder on Fri, 06 January 2006 13:59
		Re: COMPLEX SQL,NESTED By: feroze on Fri, 06 January 2006 15:11
		Re: COMPLEX SQL,NESTED By: mchadder on Fri, 06 January 2006 16:50
		Re: COMPLEX SQL,NESTED By: feroze on Fri, 06 January 2006 17:30
		Re: COMPLEX SQL,NESTED By: rleishman on Fri, 06 January 2006 20:27
		Re: COMPLEX SQL,NESTED By: Frank on Sat, 07 January 2006 00:02

		perfstat report - explanation please By: alanm on Wed, 04 January 2006 09:19
		Re: perfstat report - explanation please By: goryunov on Wed, 04 January 2006 15:01
		Re: perfstat report - explanation please By: alanm on Thu, 05 January 2006 03:11

		Improve performance with MV By: AlinaC on Tue, 03 January 2006 22:19
		Re: Improve performance with MV By: wpaillan on Wed, 04 January 2006 06:21
		Re: Improve performance with MV By: wpaillan on Wed, 04 January 2006 06:27

		long and short table scans By: alanm on Tue, 03 January 2006 07:54
		Re: long and short table scans By: Art Metzer on Tue, 03 January 2006 08:26
		Re: long and short table scans By: alanm on Tue, 03 January 2006 08:36

		Inlist operator performance By: mjschwenger on Wed, 28 December 2005 14:19
		Re: Inlist operator performance By: mchadder on Wed, 28 December 2005 16:30
		Re: Inlist operator performance By: mjschwenger on Wed, 28 December 2005 17:09
		Re: Inlist operator performance By: mchadder on Wed, 28 December 2005 17:44
		Re: Inlist operator performance By: mjschwenger on Thu, 29 December 2005 12:10
		Re: Inlist operator performance By: mchadder on Thu, 29 December 2005 17:09
		Re: Inlist operator performance By: mjschwenger on Fri, 30 December 2005 16:23
		Re: Inlist operator performance By: mchadder on Sun, 01 January 2006 15:31

		Shrinking Index tablespace By: toshidas2000 on Wed, 28 December 2005 13:40
		Re: Shrinking Index tablespace By: mjschwenger on Wed, 28 December 2005 15:02
		Re: Shrinking Index tablespace By: toshidas2000 on Thu, 29 December 2005 09:43
		Re: Shrinking Index tablespace By: waseem_aijaz on Sat, 31 December 2005 23:34

		Turn Logging on, on Index By: toshidas2000 on Wed, 28 December 2005 12:15
		Re: Turn Logging on, on Index By: waseem_aijaz on Sat, 31 December 2005 23:26

		Error In Analyzing Table (Ora-03114 & ORA-00603) By: weekend79 on Sat, 31 December 2005 00:18
		Re: Error In Analyzing Table (Ora-03114 & ORA-00603) By: waseem_aijaz on Sat, 31 December 2005 23:11

help calculating freelist groups

By: mjschwenger on Fri, 30 December 2005 20:31

		Show remain cpu time to end Query in OEM By: luchino75 on Thu, 29 December 2005 07:39
		Re: Show remain cpu time to end Query in OEM By: vjeedigunta on Thu, 29 December 2005 11:30
		Re: Show remain cpu time to end Query in OEM By: luchino75 on Fri, 30 December 2005 04:06

		ORA-12015: cannot create a fast refresh snapshot from a complex query By: sgv_0226 on Wed, 28 December 2005 09:11
		Re: ORA-12015: cannot create a fast refresh snapshot from a complex query By: wpaillan on Wed, 28 December 2005 09:46

		query waits By: mjschwenger on Wed, 21 December 2005 14:06
		Re: query waits By: rleishman on Thu, 22 December 2005 01:45
		Re: query waits By: mjschwenger on Sat, 24 December 2005 10:53
		Re: query waits By: Frank on Sun, 25 December 2005 01:35
		Re: query waits By: mjschwenger on Mon, 26 December 2005 23:22
		Re: query waits By: smartin on Tue, 27 December 2005 07:52
		Re: query waits By: mjschwenger on Tue, 27 December 2005 09:57
		Re: query waits By: smartin on Tue, 27 December 2005 12:24

		Diff Between Utlxplp.sql and Utlxpls.sql Scripts By: krajkumar on Sat, 24 December 2005 08:55
		Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts By: Mahesh Rajendran on Sat, 24 December 2005 09:06
		Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts By: krajkumar on Sun, 25 December 2005 10:37
		Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts By: smartin on Tue, 27 December 2005 08:07

		spfile tunning help!!! By: 760613 on Sun, 25 December 2005 20:28
		Re: spfile tunning help!!! By: smartin on Tue, 27 December 2005 08:01

Interview Qstns

By: toughguy786 on Mon, 26 December 2005 14:36

		how to change snapshot timings By: ravivkumar on Sun, 25 December 2005 08:09
		Re: how to change snapshot timings By: vjeedigunta on Mon, 26 December 2005 11:11

		Tuning of Select for a View in Report By: feroze on Mon, 12 December 2005 13:19
		Re: Tuning of Select for a View in Report By: smartin on Mon, 12 December 2005 14:16
		Re: Tuning of Select for a View in Report By: feroze on Mon, 12 December 2005 14:45
		Re: Tuning of Select for a View in Report By: feroze on Tue, 13 December 2005 10:26
		Re: Tuning of Select for a View in Report By: smartin on Tue, 13 December 2005 10:53
		Re: Tuning of Select for a View in Report By: feroze on Tue, 13 December 2005 12:43
		Re: Tuning of Select for a View in Report By: smartin on Tue, 13 December 2005 14:15
		Re: Tuning of Select for a View in Report By: feroze on Thu, 22 December 2005 09:14
		Re: Tuning of Select for a View in Report By: smartin on Thu, 22 December 2005 12:24
		Re: Tuning of Select for a View in Report By: feroze on Thu, 22 December 2005 13:27
		Re: Tuning of Select for a View in Report By: smartin on Thu, 22 December 2005 14:34

suggest

By: sethybibeka on Thu, 22 December 2005 07:31

		Analyzing indexes... By: kinjal on Wed, 21 December 2005 02:33
		Re: Analyzing indexes... By: Mahesh Rajendran on Wed, 21 December 2005 05:32
		Re: Analyzing indexes... By: smartin on Wed, 21 December 2005 11:58

		ORA-00604: error occurred at recursive SQL level 1 ORA-04031 By: janeshb on Wed, 21 December 2005 06:50
		Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 By: Mahesh Rajendran on Wed, 21 December 2005 07:06
		Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 By: janeshb on Wed, 21 December 2005 07:12
		Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 By: Mahesh Rajendran on Wed, 21 December 2005 07:30
		Re: ORA-00604: error occurred at recursive SQL level 1 ORA-04031 By: janeshb on Wed, 21 December 2005 07:58

		Finding it impossible to tune this query By: hututu on Tue, 20 December 2005 14:09
		Re: Finding it impossible to tune this query By: smartin on Tue, 20 December 2005 14:22
		Re: Finding it impossible to tune this query By: hututu on Tue, 20 December 2005 14:37
		Re: Finding it impossible to tune this query By: ChrisJr on Wed, 21 December 2005 02:05

		Solaris vs. Windows performance difference By: jeffeben on Mon, 19 December 2005 11:45
		Re: Solaris vs. Windows performance difference By: smartin on Mon, 19 December 2005 14:12

		correlated subquery taking a long time to execute By: vgs2005 on Wed, 14 December 2005 08:30
		Re: correlated subquery taking a long time to execute By: Art Metzer on Wed, 14 December 2005 08:43
		Re: correlated subquery taking a long time to execute By: vgs2005 on Fri, 16 December 2005 03:32
		Re: correlated subquery taking a long time to execute By: rleishman on Mon, 19 December 2005 02:05
		Re: correlated subquery taking a long time to execute By: smartin on Mon, 19 December 2005 09:44

		Query using bind variable is slower?? By: claymentlim on Mon, 19 December 2005 00:16
		Re: Query using bind variable is slower?? By: rleishman on Mon, 19 December 2005 02:14

		full table scan By: alka205 on Thu, 17 November 2005 10:31
		Re: full table scan By: JSI2001 on Thu, 17 November 2005 10:48
		Re: full table scan By: alka205 on Thu, 17 November 2005 11:03
		Re: full table scan By: JSI2001 on Thu, 17 November 2005 11:31
		Re: full table scan By: smartin on Thu, 17 November 2005 11:47
		Re: full table scan By: JSI2001 on Thu, 17 November 2005 11:50
		Re: full table scan By: rleishman on Thu, 17 November 2005 18:00
		Re: full table scan By: JSI2001 on Fri, 18 November 2005 04:18
		Re: full table scan By: rleishman on Sun, 20 November 2005 16:12
		Re: full table scan By: JSI2001 on Mon, 21 November 2005 03:23
		Re: full table scan By: rleishman on Mon, 21 November 2005 18:06
		Re: full table scan By: JSI2001 on Tue, 22 November 2005 03:49
		Re: full table scan By: smartin on Fri, 18 November 2005 11:26
		Re: full table scan By: smartin on Tue, 29 November 2005 12:40
		Re: full table scan By: smartin on Tue, 29 November 2005 12:46
		Re: full table scan By: humair77 on Thu, 15 December 2005 19:49

		when do I need to create an indexes. By: cuisia on Thu, 15 December 2005 03:54
		Re: when do I need to create an indexes. By: Mahesh Rajendran on Thu, 15 December 2005 06:46
		Re: when do I need to create an indexes. By: Mahesh Rajendran on Thu, 15 December 2005 07:12
		Re: when do I need to create an indexes. By: smartin on Thu, 15 December 2005 09:55
		Re: when do I need to create an indexes. By: cuisia on Thu, 15 December 2005 19:20

		query optimization By: Rajesh Joshi on Thu, 15 December 2005 08:01
		Re: query optimization By: Art Metzer on Thu, 15 December 2005 09:04
		Re: query optimization By: Rajesh Joshi on Thu, 15 December 2005 09:26
		Re: query optimization By: Art Metzer on Thu, 15 December 2005 09:52

		my application is too slow. By: cuisia on Wed, 14 December 2005 21:06
		Re: my application is too slow. By: Mahesh Rajendran on Thu, 15 December 2005 02:16
		Re: my application is too slow. By: smartin on Thu, 15 December 2005 09:43

		oracle 10g cbo slower than rbo By: lazycat on Tue, 13 December 2005 19:22
		Re: oracle 10g cbo slower than rbo By: Frank on Wed, 14 December 2005 00:38
		Re: oracle 10g cbo slower than rbo By: tarundua on Wed, 14 December 2005 00:53
		Re: oracle 10g cbo slower than rbo By: lazycat on Wed, 14 December 2005 02:29
		Re: oracle 10g cbo slower than rbo By: vjeedigunta on Wed, 14 December 2005 07:11
		Re: oracle 10g cbo slower than rbo By: Mahesh Rajendran on Wed, 14 December 2005 07:49
		Re: oracle 10g cbo slower than rbo By: smartin on Thu, 15 December 2005 09:38

		SQL - very slow response By: avi123india on Sat, 10 December 2005 05:34
		Re: SQL - very slow response By: BlackSwan on Sat, 10 December 2005 15:27
		Re: SQL - very slow response By: avi123india on Mon, 12 December 2005 22:31
		Re: SQL - very slow response By: smartin on Tue, 13 December 2005 08:20
		Re: SQL - very slow response By: rleishman on Wed, 14 December 2005 02:08

		Interesting predicate found in explain plan By: smartin on Wed, 07 December 2005 09:34
		Re: Interesting predicate found in explain plan By: Frank on Thu, 08 December 2005 00:31
		Re: Interesting predicate found in explain plan By: smartin on Thu, 08 December 2005 08:35
		Re: Interesting predicate found in explain plan By: smartin on Thu, 08 December 2005 08:41
		Re: Interesting predicate found in explain plan By: Frank on Fri, 09 December 2005 00:56
		Re: Interesting predicate found in explain plan By: smartin on Fri, 09 December 2005 07:40
		Re: Interesting predicate found in explain plan By: rleishman on Mon, 12 December 2005 01:20
		Re: Interesting predicate found in explain plan By: Frank on Mon, 12 December 2005 01:36
		Re: Interesting predicate found in explain plan By: smartin on Mon, 12 December 2005 10:23

		How to tune a sql query to make it run faster ... By: amankhan on Sat, 10 December 2005 15:54
		Re: How to tune a sql query to make it run faster ... By: BlackSwan on Sat, 10 December 2005 16:43
		Re: How to tune a sql query to make it run faster ... By: Art Metzer on Sun, 11 December 2005 14:55
		Re: How to tune a sql query to make it run faster ... By: rleishman on Mon, 12 December 2005 01:25

		Tablespace increase - Which is Optimum Method. By: Jegathees on Thu, 08 December 2005 23:07
		Re: Tablespace increase - Which is Optimum Method. By: Mahesh Rajendran on Fri, 09 December 2005 06:50

		Performance of the sql due to group by By: raghuraja_r on Wed, 07 December 2005 23:18
		Re: Performance of the sql due to group by By: Frank on Thu, 08 December 2005 00:20

		Explain Plan (Query Transformation) By: dhar_kiran on Mon, 05 December 2005 03:39
		Re: Explain Plan (Query Transformation) By: smartin on Mon, 05 December 2005 12:07
		Re: Explain Plan (Query Transformation) By: dhar_kiran on Tue, 06 December 2005 01:20
		Re: Explain Plan (Query Transformation) By: Mahesh Rajendran on Tue, 06 December 2005 01:34
		Re: Explain Plan (Query Transformation) By: mchadder on Tue, 06 December 2005 15:03
		Re: Explain Plan (Query Transformation) By: smartin on Tue, 06 December 2005 15:38
		Re: Explain Plan (Query Transformation) By: mchadder on Tue, 06 December 2005 16:42
		Re: Explain Plan (Query Transformation) By: smartin on Wed, 07 December 2005 08:20
		Re: Explain Plan (Query Transformation) By: mchadder on Wed, 07 December 2005 11:16

		Database Performance Tuning By: chenchireddy on Wed, 07 December 2005 06:54
		Re: Database Performance Tuning By: Art Metzer on Wed, 07 December 2005 06:58

Pages (119): [ « ‹ 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sat May 18 17:08:08 CDT 2024