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.

		UTLBSTAT UTLESTAT By: Alps on Fri, 22 December 2006 08:21
		Re: UTLBSTAT UTLESTAT By: Frank Naude on Tue, 02 January 2007 06:31

		Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Tue, 19 December 2006 15:33
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Wed, 20 December 2006 01:18
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Thu, 21 December 2006 08:36
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Thu, 21 December 2006 09:53
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Thu, 21 December 2006 13:48
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Thu, 21 December 2006 10:11
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Thu, 21 December 2006 16:48
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Thu, 21 December 2006 17:41
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Fri, 22 December 2006 10:27
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Fri, 22 December 2006 11:24
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Wed, 27 December 2006 17:36
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: michael_bialik on Fri, 29 December 2006 17:11
		Re: Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Mon, 01 January 2007 14:36

		Tablespace for table with 1,000,000 rows By: emilSverige on Sat, 30 December 2006 08:00
		Re: Tablespace for table with 1,000,000 rows By: BlackSwan on Sat, 30 December 2006 09:08
		Re: Tablespace for table with 1,000,000 rows By: emilSverige on Sat, 30 December 2006 14:06
		Re: Tablespace for table with 1,000,000 rows By: BlackSwan on Sat, 30 December 2006 16:45
		Re: Tablespace for table with 1,000,000 rows By: emilSverige on Mon, 01 January 2007 09:42
		Re: Tablespace for table with 1,000,000 rows By: BlackSwan on Mon, 01 January 2007 10:26
		Re: Tablespace for table with 1,000,000 rows By: emilSverige on Mon, 01 January 2007 10:37

		Tune the Update Process By: yerics on Thu, 28 December 2006 15:18
		Re: Tune the Update Process By: BlackSwan on Thu, 28 December 2006 17:41
		Re: Tune the Update Process By: rleishman on Thu, 28 December 2006 19:42
		Re: Tune the Update Process By: yerics on Fri, 29 December 2006 09:53
		Re: Tune the Update Process By: rleishman on Sat, 30 December 2006 20:21

		too many views By: mjschwenger on Wed, 27 December 2006 10:53
		Re: too many views By: Mahesh Rajendran on Wed, 27 December 2006 11:18
		Re: too many views By: Littlefoot on Wed, 27 December 2006 15:22
		Re: too many views By: Mahesh Rajendran on Wed, 27 December 2006 16:32
		Re: too many views By: Littlefoot on Thu, 28 December 2006 00:35

		how to use dbms_system.set_sql_trace_in_session with 10046 level 12 By: kumarsz on Wed, 27 December 2006 19:47
		Re: how to use dbms_system.set_sql_trace_in_session with 10046 level 12 By: BlackSwan on Wed, 27 December 2006 19:59
		Re: how to use dbms_system.set_sql_trace_in_session with 10046 level 12 By: kumarsz on Wed, 27 December 2006 20:18

		TPC testing By: it_me24 on Wed, 27 December 2006 08:29
		Re: TPC testing By: Mahesh Rajendran on Wed, 27 December 2006 08:36
		Re: TPC testing By: it_me24 on Wed, 27 December 2006 10:36
		Re: TPC testing By: Mahesh Rajendran on Wed, 27 December 2006 10:55
		Re: TPC testing By: it_me24 on Wed, 27 December 2006 11:36

		tkprof fetch count By: sourajit_seth on Wed, 27 December 2006 01:34
		Re: tkprof fetch count By: Frank Naude on Wed, 27 December 2006 02:47
		Re: tkprof fetch count By: sourajit_seth on Wed, 27 December 2006 03:09
		Re: tkprof fetch count By: rleishman on Wed, 27 December 2006 05:44

		does it cause any negative impact on performance By: sreehari on Wed, 27 December 2006 00:44
		Re: does it cause any negative impact on performance By: seema.taunk on Wed, 27 December 2006 01:44
		Re: does it cause any negative impact on performance By: Mahesh Rajendran on Wed, 27 December 2006 04:12

		about sql tuning By: SRIVASUWIN on Fri, 22 December 2006 11:24
		Re: about sql tuning By: BlackSwan on Fri, 22 December 2006 13:08
		Re: about sql tuning By: michael_bialik on Sat, 23 December 2006 10:02

		Table Stats running By: toshidas2000 on Wed, 20 December 2006 07:58
		Re: Table Stats running By: Mahesh Rajendran on Thu, 21 December 2006 05:55
		Re: Table Stats running By: michael_bialik on Fri, 22 December 2006 11:47

		Oracle Database Slow By: hemanthkumar.t on Fri, 22 December 2006 02:22
		Re: Oracle Database Slow By: michael_bialik on Fri, 22 December 2006 03:04

		Avoiding FTS, Any better Way to write this By: faiz_hyd on Wed, 20 December 2006 10:54
		Re: Avoiding FTS, Any better Way to write this By: rleishman on Wed, 20 December 2006 19:51
		Re: Avoiding FTS, Any better Way to write this By: faiz_hyd on Thu, 21 December 2006 10:47
		Re: Avoiding FTS, Any better Way to write this By: rleishman on Thu, 21 December 2006 20:18

		Which One is better... VARCHAR or Number By: amit_nanote on Wed, 20 December 2006 06:38
		Re: Which One is better... VARCHAR or Number By: JRowbottom on Wed, 20 December 2006 06:53
		Re: Which One is better... VARCHAR or Number By: amit_nanote on Wed, 20 December 2006 07:03
		Re: Which One is better... VARCHAR or Number By: JRowbottom on Wed, 20 December 2006 07:09

		High activity of "delete from smon_scn_time" in statspack report By: Peter Babka on Wed, 20 December 2006 04:33
		Re: High activity of "delete from smon_scn_time" in statspack rep... By: Mahesh Rajendran on Wed, 20 December 2006 06:14

		Process tuning By: SSALEMY2K on Sun, 17 December 2006 04:23
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 05:08
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 05:15
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 05:38
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 06:20
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 06:50
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 06:56
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 07:10
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 07:43
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 07:46
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 05:36
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 06:12
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 06:34
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 07:02
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 07:16
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 07:46
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 07:51
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:00
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:07
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:23
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:34
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:46
		Re: Process tuning By: SSALEMY2K on Sun, 17 December 2006 08:56
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 07:50
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 07:57
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 08:04
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 08:17
		Re: Process tuning By: dba_blr on Sun, 17 December 2006 08:18
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 08:26
		Re: Process tuning By: michael_bialik on Sun, 17 December 2006 08:37
		Re: Process tuning By: michael_bialik on Mon, 18 December 2006 11:38
		Re: Process tuning By: SSALEMY2K on Mon, 18 December 2006 13:27
		Re: Process tuning By: michael_bialik on Mon, 18 December 2006 15:04
		Re: Process tuning By: business1 on Tue, 19 December 2006 17:21
		Re: Process tuning By: BlackSwan on Tue, 19 December 2006 17:25
		Re: Process tuning By: ebrian on Tue, 19 December 2006 20:43

		Introduce a good book for oracle performance tuning! By: wxfjordan on Tue, 19 December 2006 02:53
		Re: Introduce a good book for oracle performance tuning! By: Littlefoot on Tue, 19 December 2006 03:32
		Re: Introduce a good book for oracle performance tuning! By: rleishman on Tue, 19 December 2006 20:14

		Help - Performance Issue - statspack report attached By: orasaket on Mon, 18 December 2006 10:11
		Re: Help - Performance Issue - statspack report attached By: michael_bialik on Mon, 18 December 2006 13:10
		Re: Help - Performance Issue - statspack report attached By: orasaket on Mon, 18 December 2006 18:33
		Re: Help - Performance Issue - statspack report attached By: michael_bialik on Tue, 19 December 2006 00:36
		Re: Help - Performance Issue - statspack report attached By: JRowbottom on Tue, 19 December 2006 02:52

		how to handle this wait event: "control file sequential read"? By: wxfjordan on Mon, 18 December 2006 21:06
		Re: how to handle this wait event: "control file sequential read"... By: Mohammad Taj on Mon, 18 December 2006 22:27

		Performance tuning By: misha603 on Mon, 18 December 2006 10:20
		Re: Performance tuning By: michael_bialik on Mon, 18 December 2006 13:08

		LATCH FREE - HIGH DURING MID NIGHT By: cresento on Mon, 18 December 2006 08:38
		Re: LATCH FREE - HIGH DURING MID NIGHT By: dba_blr on Mon, 18 December 2006 12:12

Post fast/complete refresh COMPILE_STATE=NEEDS_COMPILE

By: blazingrock4u on Mon, 18 December 2006 03:29

		Cost is high By: subhajit on Tue, 12 December 2006 00:39
		Re: Cost is high By: Frank Naude on Tue, 12 December 2006 02:55
		Re: Cost is high By: dba_blr on Tue, 12 December 2006 11:24
		Re: Cost is high By: michael_bialik on Wed, 13 December 2006 01:00
		Re: Cost is high By: subhajit on Mon, 18 December 2006 00:03

		how to increase the speed of a MView Refresh By: krishnahere on Sat, 16 December 2006 03:07
		Re: how to increase the speed of a MView Refresh By: michael_bialik on Sun, 17 December 2006 06:14

		Shared Pool Advisory for Shared Pool Size By: orasaket on Thu, 14 December 2006 20:55
		Re: Shared Pool Advisory for Shared Pool Size By: ebrian on Fri, 15 December 2006 05:15
		Re: Shared Pool Advisory for Shared Pool Size By: orasaket on Sat, 16 December 2006 07:39
		Re: Shared Pool Advisory for Shared Pool Size By: ebrian on Sat, 16 December 2006 08:44

		Trace Oracle Job Session using tkprof By: orasaket on Thu, 14 December 2006 21:07
		Re: Trace Oracle Job Session using tkprof By: rleishman on Fri, 15 December 2006 00:37
		Re: Trace Oracle Job Session using tkprof By: orasaket on Sat, 16 December 2006 07:45
		Re: Trace Oracle Job Session using tkprof By: Mahesh Rajendran on Sat, 16 December 2006 08:35

		Windows vs Linux By: dfmflinn on Fri, 15 December 2006 10:21
		Re: Windows vs Linux By: rleishman on Fri, 15 December 2006 21:37

		Looking for a guru By: rvgriff on Thu, 14 December 2006 14:46
		Re: Looking for a guru By: Mahesh Rajendran on Thu, 14 December 2006 15:04
		Re: Looking for a guru By: rvgriff on Thu, 14 December 2006 15:15
		Re: Looking for a guru By: BlackSwan on Thu, 14 December 2006 15:20
		Re: Looking for a guru By: rvgriff on Thu, 14 December 2006 15:21
		Re: Looking for a guru By: BlackSwan on Thu, 14 December 2006 15:43

		DBF files By: srinivas.k2005 on Tue, 05 December 2006 11:16
		Re: DBF files By: Mahesh Rajendran on Tue, 05 December 2006 11:22
		Re: DBF files By: srinivas.k2005 on Tue, 05 December 2006 11:48
		Re: DBF files By: HibsMax on Tue, 05 December 2006 11:52
		Re: DBF files By: kudur_kv on Thu, 14 December 2006 05:45

		session cached cursors By: seema.taunk on Thu, 14 December 2006 02:55
		Re: session cached cursors By: Mohammad Taj on Thu, 14 December 2006 03:31
		Re: session cached cursors By: seema.taunk on Thu, 14 December 2006 03:43

		Find - Database growth monthwise By: orasaket on Sat, 09 December 2006 20:02
		Re: Find - Database growth monthwise By: BlackSwan on Sat, 09 December 2006 20:49
		Re: Find - Database growth monthwise By: Mahesh Rajendran on Sun, 10 December 2006 07:51
		Re: Find - Database growth monthwise By: orasaket on Mon, 11 December 2006 09:25
		Re: Find - Database growth monthwise By: Mahesh Rajendran on Mon, 11 December 2006 09:57
		Re: Find - Database growth monthwise By: orasaket on Wed, 13 December 2006 15:41

		Performance Issue By: Alps on Tue, 12 December 2006 11:34
		Re: Performance Issue By: Mahesh Rajendran on Tue, 12 December 2006 11:37
		Re: Performance Issue By: dba_blr on Tue, 12 December 2006 11:48
		Re: Performance Issue By: Alps on Tue, 12 December 2006 12:12
		Re: Performance Issue By: Mahesh Rajendran on Tue, 12 December 2006 12:15
		Re: Performance Issue By: Mahesh Rajendran on Tue, 12 December 2006 12:18
		Re: Performance Issue By: dba_blr on Tue, 12 December 2006 12:33
		Re: Performance Issue By: Alps on Tue, 12 December 2006 12:42
		Re: Performance Issue By: Mahesh Rajendran on Tue, 12 December 2006 12:48

		Timed out trying to start process J002 massage By: shilpa.rajput on Tue, 12 December 2006 01:49
		Re: Timed out trying to start process J002 massage By: Frank Naude on Tue, 12 December 2006 03:01

		nothing in trace-file By: AndreyPozhidaev on Fri, 08 December 2006 01:12
		Re: nothing in trace-file By: Littlefoot on Fri, 08 December 2006 04:52
		Re: nothing in trace-file By: Mohammad Taj on Fri, 08 December 2006 23:27

		query tunning By: baskarb_2006 on Thu, 07 December 2006 05:50
		Re: query tunning By: baskarb_2006 on Thu, 07 December 2006 05:51
		Re: query tunning By: Admin@Lightsql.Com on Thu, 07 December 2006 16:19

		DB tuning By: ataufique on Tue, 21 November 2006 02:59
		Re: DB tuning By: BlackSwan on Tue, 21 November 2006 18:55
		Re: DB tuning By: ataufique on Thu, 07 December 2006 04:59

Doubt on Oracle Post-Wait Extension in Semaphore allocation

By: girishta on Thu, 07 December 2006 00:22

		Alter Table parallel complexity By: rkl1 on Tue, 05 December 2006 16:01
		Re: Alter Table parallel complexity By: michael_bialik on Wed, 06 December 2006 02:23
		Re: Alter Table parallel complexity By: rkl1 on Wed, 06 December 2006 09:04

		more precise timing with TKPROF By: HibsMax on Tue, 05 December 2006 10:03
		Re: more precise timing with TKPROF By: BlackSwan on Tue, 05 December 2006 13:26
		Re: more precise timing with TKPROF By: HibsMax on Tue, 05 December 2006 13:44
		Re: more precise timing with TKPROF By: michael_bialik on Tue, 05 December 2006 14:55
		Re: more precise timing with TKPROF By: HibsMax on Tue, 05 December 2006 15:48

		PGA_AGGREGATE_TARGET & SORT_AREA_SIZE By: Anand Ramaswamy on Tue, 28 November 2006 07:43
		Re: PGA_AGGREGATE_TARGET & SORT_AREA_SIZE By: Mahesh Rajendran on Tue, 28 November 2006 07:59
		Re: PGA_AGGREGATE_TARGET & SORT_AREA_SIZE By: d0hboy on Tue, 05 December 2006 14:00

Pages (119): [ « ‹ 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 › »]

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 Jun 29 01:30:12 CDT 2024