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.

		Performance tuning for a simple table with 2million records By: santhoshmohan on Wed, 12 November 2008 18:49
		Re: Performance tuning for a simple table with 2million records By: rleishman on Wed, 12 November 2008 20:17
		Re: Performance tuning for a simple table with 2million records By: Oyunbold on Mon, 17 November 2008 21:51

		Query optimization By: prem18 on Mon, 17 November 2008 09:57
		Re: Query optimization By: Michel Cadot on Mon, 17 November 2008 10:07
		Re: Query optimization By: rleishman on Mon, 17 November 2008 19:44

		Wait events By: vinniora on Mon, 17 November 2008 04:39
		Re: Wait events By: Michel Cadot on Mon, 17 November 2008 04:51

		Error in Materialized view refresh By: mac4rfree on Fri, 14 November 2008 07:36
		Re: Error in Materialized view refresh By: Littlefoot on Fri, 14 November 2008 07:50
		Re: Error in Materialized view refresh By: mac4rfree on Fri, 14 November 2008 07:58
		Re: Error in Materialized view refresh By: Littlefoot on Sat, 15 November 2008 14:04

		package performance By: skumar.dba on Thu, 13 November 2008 14:37
		Re: package performance By: rleishman on Thu, 13 November 2008 19:26
		Re: package performance By: skumar.dba on Fri, 14 November 2008 14:10
		Re: package performance By: rleishman on Fri, 14 November 2008 23:10

		Interpreting "Row Source Operation" Output of TKPROF By: tsteinmaurer on Wed, 12 November 2008 09:19
		Re: Interpreting "Row Source Operation" Output of TKPROF By: cookiemonster on Wed, 12 November 2008 10:58
		Re: Interpreting "Row Source Operation" Output of TKPROF By: rleishman on Wed, 12 November 2008 20:26
		Re: Interpreting "Row Source Operation" Output of TKPROF By: tsteinmaurer on Thu, 13 November 2008 02:23
		Re: Interpreting "Row Source Operation" Output of TKPROF By: cookiemonster on Thu, 13 November 2008 05:05
		Re: Interpreting "Row Source Operation" Output of TKPROF By: tsteinmaurer on Thu, 13 November 2008 06:05
		Re: Interpreting "Row Source Operation" Output of TKPROF By: rleishman on Thu, 13 November 2008 19:24

		High Logical Reads By: kummi_gh on Wed, 12 November 2008 07:50
		Re: High Logical Reads By: rleishman on Wed, 12 November 2008 20:30
		Re: High Logical Reads By: kummi_gh on Wed, 12 November 2008 22:58

		Find speed By: pointers on Wed, 12 November 2008 07:17
		Re: Find speed By: tahpush on Wed, 12 November 2008 08:09
		Re: Find speed By: pointers on Wed, 12 November 2008 08:19
		Re: Find speed By: pointers on Wed, 12 November 2008 09:44
		Re: Find speed By: Michel Cadot on Wed, 12 November 2008 10:16
		Re: Find speed By: pointers on Wed, 12 November 2008 10:46
		Re: Find speed By: Michel Cadot on Wed, 12 November 2008 10:55

		Query taking very long time By: virmahi on Fri, 07 November 2008 01:32
		Re: Query taking very long time By: Olivia on Fri, 07 November 2008 04:49
		Re: Query taking very long time By: rleishman on Fri, 07 November 2008 14:40
		Re: Query taking very long time By: virmahi on Tue, 11 November 2008 05:49
		Re: Query taking very long time By: rleishman on Tue, 11 November 2008 20:44

		Dunsel Joins By: Kevin Meade on Mon, 10 November 2008 21:00
		Re: Dunsel Joins By: JRowbottom on Tue, 11 November 2008 04:41
		Re: Dunsel Joins By: cookiemonster on Tue, 11 November 2008 06:20
		Re: Dunsel Joins By: Kevin Meade on Tue, 11 November 2008 08:56
		Re: Dunsel Joins By: rleishman on Tue, 11 November 2008 20:39

		Wait events By: marcossantos on Tue, 11 November 2008 11:53
		Re: Wait events By: Michel Cadot on Tue, 11 November 2008 12:32

		gets,pins and reloads in v$library Cache By: ankush_chawla on Mon, 10 November 2008 09:55
		Re: gets,pins and reloads in v$library Cache By: ankush_chawla on Tue, 11 November 2008 01:43
		Re: gets,pins and reloads in v$library Cache By: Littlefoot on Tue, 11 November 2008 02:07

		SESSION CPU By: lioracle on Mon, 10 November 2008 09:54
		Re: SESSION CPU By: Michel Cadot on Mon, 10 November 2008 10:07
		Re: SESSION CPU By: lioracle on Mon, 10 November 2008 10:11
		Re: SESSION CPU By: Michel Cadot on Mon, 10 November 2008 11:19
		Re: SESSION CPU By: lioracle on Mon, 10 November 2008 11:21
		Re: SESSION CPU By: Michel Cadot on Mon, 10 November 2008 11:27

		Query Tuning By: manoj12 on Mon, 10 November 2008 00:59
		Re: Query Tuning By: rleishman on Mon, 10 November 2008 01:36

		Performance Issue: Steps that need to take care of By: Olivia on Wed, 05 November 2008 07:05
		Re: Performance Issue: Steps that need to take care of By: JRowbottom on Wed, 05 November 2008 10:07
		Re: Performance Issue: Steps that need to take care of By: virmahi on Fri, 07 November 2008 01:06

		Performance: partition/index not used By: wakula on Wed, 05 November 2008 04:26
		Re: Performance: partition/index not used By: rleishman on Thu, 06 November 2008 01:28

		Index a system view By: serkzc on Wed, 05 November 2008 22:36
		Re: Index a system view By: Michel Cadot on Wed, 05 November 2008 23:29

		Dirty database_Performance issues By: neena_forum on Tue, 04 November 2008 00:03
		Re: Dirty database_Performance issues By: Michel Cadot on Tue, 04 November 2008 01:13
		Re: Dirty database_Performance issues By: rleishman on Tue, 04 November 2008 19:36

		Purgeing data By: jack00423 on Tue, 04 November 2008 14:18
		Re: Purgeing data By: Michel Cadot on Tue, 04 November 2008 14:24
		Re: Purgeing data By: jack00423 on Tue, 04 November 2008 14:30
		Re: Purgeing data By: rleishman on Tue, 04 November 2008 19:26
		Re: Purgeing data By: Kevin Meade on Tue, 04 November 2008 19:35

		Query Tuning By: rsoma on Fri, 31 October 2008 07:30
		Re: Query Tuning By: coleing on Fri, 31 October 2008 12:55
		Re: Query Tuning By: michael_bialik on Tue, 04 November 2008 05:26
		Re: Query Tuning By: coleing on Tue, 04 November 2008 13:52

		Gather statistics for scale up / down decision process By: tsteinmaurer on Tue, 28 October 2008 08:09
		Re: Gather statistics for scale up / down decision process By: JRowbottom on Tue, 04 November 2008 07:03
		Re: Gather statistics for scale up / down decision process By: tsteinmaurer on Tue, 04 November 2008 08:34
		Re: Gather statistics for scale up / down decision process By: JRowbottom on Tue, 04 November 2008 08:41

		gather stats how? By: ArvindBhope on Thu, 23 October 2008 15:35
		Re: gather stats how? By: Michel Cadot on Thu, 23 October 2008 15:38
		Re: gather stats how? By: ArvindBhope on Thu, 23 October 2008 15:40
		Re: gather stats how? By: Michel Cadot on Thu, 23 October 2008 15:52
		Re: gather stats how? By: JRowbottom on Fri, 24 October 2008 09:19
		Re: gather stats how? By: Kevin Meade on Mon, 27 October 2008 16:28
		Re: gather stats how? By: ArvindBhope on Wed, 29 October 2008 07:13
		Re: gather stats how? By: Kevin Meade on Wed, 29 October 2008 09:02
		Re: gather stats how? By: Kevin Meade on Wed, 29 October 2008 09:02
		Re: gather stats how? By: JRowbottom on Tue, 04 November 2008 06:51
		Re: gather stats how? By: JRowbottom on Tue, 04 November 2008 07:04
		Re: gather stats how? By: ArvindBhope on Wed, 29 October 2008 09:12
		Re: gather stats how? By: efachim on Wed, 29 October 2008 10:14
		Re: gather stats how? By: ArvindBhope on Wed, 29 October 2008 10:20

		select does a full table scan. 130.000.000 rows By: mclu on Fri, 31 October 2008 00:21
		Re: select does a full table scan. 130.000.000 rows By: mclu on Fri, 31 October 2008 02:25
		Re: select does a full table scan. 130.000.000 rows By: rleishman on Sat, 01 November 2008 00:23
		Re: select does a full table scan. 130.000.000 rows By: mclu on Mon, 03 November 2008 04:20
		Re: select does a full table scan. 130.000.000 rows By: JRowbottom on Tue, 04 November 2008 05:33
		Re: select does a full table scan. 130.000.000 rows By: michael_bialik on Tue, 04 November 2008 05:34

		Whether Statistics upto date or not By: Olivia on Tue, 04 November 2008 03:48
		Re: Whether Statistics upto date or not By: Michel Cadot on Tue, 04 November 2008 04:41
		Re: Whether Statistics upto date or not By: Olivia on Tue, 04 November 2008 04:58

		Packaged procedure tuning By: getritesh on Sun, 02 November 2008 01:19
		Re: Packaged procedure tuning By: rleishman on Sun, 02 November 2008 22:25

		alter system set events By: sasnrock on Sun, 02 November 2008 03:45
		Re: alter system set events By: sasnrock on Sun, 02 November 2008 04:00
		Re: alter system set events By: ebrian on Sun, 02 November 2008 08:22
		Re: alter system set events By: sasnrock on Sun, 02 November 2008 10:15

		Insert Oddly Alters Explain Plan By: annagel on Tue, 28 October 2008 12:13
		Re: Insert Oddly Alters Explain Plan By: S.Rajaram on Tue, 28 October 2008 12:33
		Re: Insert Oddly Alters Explain Plan By: annagel on Tue, 28 October 2008 13:32
		Re: Insert Oddly Alters Explain Plan By: annagel on Tue, 28 October 2008 15:45
		Re: Insert Oddly Alters Explain Plan By: annagel on Thu, 30 October 2008 09:43

		Performance issues between Databases By: eigeneachse on Mon, 27 October 2008 04:52
		Re: Performance issues between Databases By: Mohammad Taj on Mon, 27 October 2008 07:12
		Re: Performance issues between Databases By: eigeneachse on Mon, 27 October 2008 08:20
		Re: Performance issues between Databases By: Mahesh Rajendran on Mon, 27 October 2008 09:29
		Re: Performance issues between Databases By: eigeneachse on Mon, 27 October 2008 09:53
		Re: Performance issues between Databases By: Mahesh Rajendran on Mon, 27 October 2008 10:18
		Re: Performance issues between Databases By: eigeneachse on Tue, 28 October 2008 02:37
		Re: Performance issues between Databases By: Kevin Meade on Mon, 27 October 2008 16:14
		Re: Performance issues between Databases By: rleishman on Tue, 28 October 2008 01:18
		Re: Performance issues between Databases By: eigeneachse on Tue, 28 October 2008 03:42
		Re: Performance issues between Databases By: rleishman on Tue, 28 October 2008 07:10
		Re: Performance issues between Databases By: eigeneachse on Thu, 30 October 2008 05:26
		Re: Performance issues between Databases By: Kevin Meade on Thu, 30 October 2008 08:06

		Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complete By: youngb912 on Wed, 22 October 2008 14:50
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: ebrian on Wed, 22 October 2008 20:42
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: youngb912 on Thu, 23 October 2008 13:11
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: ebrian on Thu, 23 October 2008 20:09
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: youngb912 on Thu, 23 October 2008 21:45
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: youngb912 on Wed, 29 October 2008 14:59
		Re: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complet... By: ebrian on Wed, 29 October 2008 20:56

		Do you know how to find out the underlying tables for a dynamic view? By: efachim on Fri, 24 October 2008 11:58
		Re: Do you know how to find out the underlying tables for a dynamic view? By: Michel Cadot on Fri, 24 October 2008 12:14
		Re: Do you know how to find out the underlying tables for a dynamic view? By: efachim on Fri, 24 October 2008 16:50

		High CPU Utilizaion By: varunvir on Wed, 22 October 2008 14:06
		Re: High CPU Utilizaion By: Michel Cadot on Wed, 22 October 2008 14:10
		Re: High CPU Utilizaion By: varunvir on Thu, 23 October 2008 16:18
		Re: High CPU Utilizaion By: Michel Cadot on Thu, 23 October 2008 23:21
		Re: High CPU Utilizaion By: varunvir on Thu, 23 October 2008 16:23

		oracle volume By: deepshikhahcl on Thu, 23 October 2008 05:27
		Re: oracle volume By: Michel Cadot on Thu, 23 October 2008 05:35

		What is the significance of this data dictionary column? By: efachim on Wed, 22 October 2008 13:05
		Re: What is the significance of this data dictionary column? By: Michel Cadot on Wed, 22 October 2008 14:00
		Re: What is the significance of this data dictionary column? By: efachim on Wed, 22 October 2008 17:55
		Re: What is the significance of this data dictionary column? By: Michel Cadot on Wed, 22 October 2008 23:08

		Looking for a better access method By: annagel on Tue, 21 October 2008 10:12
		Re: Looking for a better access method By: Kevin Meade on Tue, 21 October 2008 21:38
		Re: Looking for a better access method By: rleishman on Wed, 22 October 2008 03:11
		Re: Looking for a better access method By: annagel on Wed, 22 October 2008 07:13
		Re: Looking for a better access method By: Kevin Meade on Wed, 22 October 2008 08:32
		Re: Looking for a better access method By: coleing on Wed, 22 October 2008 16:07
		Re: Looking for a better access method By: Kevin Meade on Wed, 22 October 2008 16:24
		Re: Looking for a better access method By: annagel on Wed, 22 October 2008 19:39

Bitmap conversion

By: ArvindBhope on Wed, 22 October 2008 14:06

		response time By: ArvindBhope on Wed, 22 October 2008 06:28
		Re: response time By: Michel Cadot on Wed, 22 October 2008 07:30
		Re: response time By: ArvindBhope on Wed, 22 October 2008 07:33
		Re: response time By: Michel Cadot on Wed, 22 October 2008 07:58

		Need help in tuning this query By: apps_user on Mon, 20 October 2008 21:59
		Re: Need help in tuning this query By: Alessandro Rossi on Tue, 21 October 2008 07:36
		Re: Need help in tuning this query By: michael_bialik on Tue, 21 October 2008 16:14
		Re: Need help in tuning this query By: apps_user on Wed, 22 October 2008 01:41
		Re: Need help in tuning this query By: Alessandro Rossi on Wed, 22 October 2008 03:20
		Re: Need help in tuning this query By: michael_bialik on Wed, 22 October 2008 03:17

		Query Rewrite in Materialised Views (merged) By: hexmanju on Wed, 22 October 2008 01:37
		Query Rewrite in Materialised Views By: hexmanju on Wed, 22 October 2008 01:38
		Re: Query Rewrite in Materialised Views By: rleishman on Wed, 22 October 2008 02:36
		Re: Query Rewrite in Materialised Views By: hexmanju on Wed, 22 October 2008 03:00

		Performance Query Tuning help By: rsoma on Fri, 17 October 2008 04:37
		Re: Performance Query Tuning help By: ora_2007 on Fri, 17 October 2008 05:17
		Re: Performance Query Tuning help By: rsoma on Fri, 17 October 2008 05:39
		Re: Performance Query Tuning help By: Michel Cadot on Fri, 17 October 2008 06:27
		Re: Performance Query Tuning help By: rleishman on Sat, 18 October 2008 22:04
		Re: Performance Query Tuning help By: michael_bialik on Tue, 21 October 2008 16:23
		Re: Performance Query Tuning help By: rsoma on Tue, 21 October 2008 22:27

		Please help me Tune this query By: rak007 on Thu, 16 October 2008 16:25
		Re: Please help me Tune this query By: rleishman on Sat, 18 October 2008 22:20
		Re: Please help me Tune this query By: Kevin Meade on Sun, 19 October 2008 22:34
		Re: Please help me Tune this query By: rleishman on Mon, 20 October 2008 02:10
		Re: Please help me Tune this query By: michael_bialik on Tue, 21 October 2008 16:36

Pages (119): [ « ‹ 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 › »]

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 14:57:34 CDT 2024