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.

		Pls help in reducing the buffer gets for the query below By: aarti.mishra on Fri, 08 September 2006 01:29
		Re: Pls help in reducing the buffer gets for the query below By: kimant on Sat, 09 September 2006 14:28
		Re: Pls help in reducing the buffer gets for the query below By: kimant on Fri, 29 September 2006 16:05
		Re: Pls help in reducing the buffer gets for the query below By: ebrian on Fri, 29 September 2006 17:44
		Re: Pls help in reducing the buffer gets for the query below By: rleishman on Fri, 29 September 2006 18:44
		Re: Pls help in reducing the buffer gets for the query below By: JRowbottom on Mon, 02 October 2006 08:14
		Re: Pls help in reducing the buffer gets for the query below By: Mahesh Rajendran on Mon, 02 October 2006 11:31
		Re: Pls help in reducing the buffer gets for the query below By: skn on Wed, 15 November 2006 10:11

		I need a listing of Oracle indexes and how often they are used, how? By: aidi-h on Fri, 10 November 2006 11:01
		Re: I need a listing of Oracle indexes and how often they are used, how? By: ebrian on Fri, 10 November 2006 11:23
		Re: I need a listing of Oracle indexes and how often they are used, how? By: JRowbottom on Fri, 10 November 2006 15:29
		Re: I need a listing of Oracle indexes and how often they are used, how? By: aidi-h on Tue, 14 November 2006 07:54
		Re: I need a listing of Oracle indexes and how often they are used, how? By: JRowbottom on Tue, 14 November 2006 09:18
		Re: I need a listing of Oracle indexes and how often they are used, how? By: ebrian on Tue, 14 November 2006 15:53
		Re: I need a listing of Oracle indexes and how often they are used, how? By: aidi-h on Tue, 14 November 2006 11:08
		Re: I need a listing of Oracle indexes and how often they are used, how? By: JRowbottom on Wed, 15 November 2006 07:52

		Analyze tables By: seema.taunk on Mon, 13 November 2006 05:26
		Re: Analyze tables By: Mohammad Taj on Mon, 13 November 2006 07:17
		Re: Analyze tables By: seema.taunk on Mon, 13 November 2006 22:45
		Re: Analyze tables By: seema.taunk on Tue, 14 November 2006 01:50
		Re: Analyze tables By: Mohammad Taj on Tue, 14 November 2006 02:23
		Re: Analyze tables By: seema.taunk on Tue, 14 November 2006 03:24
		Re: Analyze tables By: Mahesh Rajendran on Tue, 14 November 2006 06:40
		Re: Analyze tables By: seema.taunk on Tue, 14 November 2006 22:52

		Regarding Autotrace execution Plan By: reena_ch30 on Mon, 13 November 2006 22:38
		Re: Regarding Autotrace execution Plan By: Mohammad Taj on Mon, 13 November 2006 23:16
		Re: Regarding Autotrace execution Plan By: reena_ch30 on Mon, 13 November 2006 23:25
		Re: Regarding Autotrace execution Plan By: Mohammad Taj on Tue, 14 November 2006 00:49

		Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT By: reena_ch30 on Sun, 12 November 2006 23:53
		Re: Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_CO... By: Mohammad Taj on Mon, 13 November 2006 00:06
		Re: Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_CO... By: reena_ch30 on Mon, 13 November 2006 00:30
		Re: Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_CO... By: Mohammad Taj on Mon, 13 November 2006 22:40

		Query Optimization problem... By: deepayan on Tue, 07 November 2006 03:56
		Re: Query Optimization problem... By: skooman on Mon, 13 November 2006 10:05
		Re: Query Optimization problem... By: rleishman on Mon, 13 November 2006 19:50

		Analyze SYS_IL0000 LOB Indexes By: venkatp6 on Mon, 13 November 2006 10:56
		Re: Analyze SYS_IL0000 LOB Indexes By: Mahesh Rajendran on Mon, 13 November 2006 12:18

		Index not used in outer join query By: lars3006 on Wed, 08 November 2006 07:44
		Re: Index not used in outer join query By: Mahesh Rajendran on Wed, 08 November 2006 07:52
		Re: Index not used in outer join query By: lars3006 on Wed, 08 November 2006 08:27
		Re: Index not used in outer join query By: lars3006 on Wed, 08 November 2006 10:36
		Re: Index not used in outer join query By: Mahesh Rajendran on Wed, 08 November 2006 10:43
		Re: Index not used in outer join query By: Mahesh Rajendran on Wed, 08 November 2006 15:07
		Re: Index not used in outer join query By: rleishman on Wed, 08 November 2006 20:12
		Re: Index not used in outer join query By: lars3006 on Thu, 09 November 2006 03:53
		Re: Index not used in outer join query By: rleishman on Fri, 10 November 2006 01:05
		Re: Index not used in outer join query By: lars3006 on Fri, 10 November 2006 05:04
		Re: Index not used in outer join query By: rleishman on Fri, 10 November 2006 18:51

Parrallel Query Problem

By: rkl1 on Fri, 10 November 2006 15:10

		PB statistic CBO By: Haler on Fri, 10 November 2006 04:45
		Re: PB statistic CBO By: JRowbottom on Fri, 10 November 2006 05:09
		Re: PB statistic CBO By: Haler on Fri, 10 November 2006 07:26
		Re: PB statistic CBO By: JRowbottom on Fri, 10 November 2006 09:24
		Re: PB statistic CBO By: Haler on Fri, 10 November 2006 12:54

		Perfomace issues on complex query By: jaydba on Wed, 01 November 2006 05:55
		Re: Perfomace issues on complex query By: michael_bialik on Wed, 01 November 2006 06:38
		Re: Perfomace issues on complex query By: jaydba on Wed, 01 November 2006 08:29
		Re: Perfomace issues on complex query By: michael_bialik on Wed, 01 November 2006 08:55
		Re: Perfomace issues on complex query By: artmt on Wed, 01 November 2006 11:41
		Re: Perfomace issues on complex query By: jaydba on Wed, 01 November 2006 12:02
		Re: Perfomace issues on complex query By: michael_bialik on Wed, 01 November 2006 14:14
		Re: Perfomace issues on complex query By: jaydba on Wed, 08 November 2006 11:33
		Re: Perfomace issues on complex query By: michael_bialik on Thu, 09 November 2006 05:39
		Re: Perfomace issues on complex query By: jaydba on Thu, 09 November 2006 11:06

		Creating PK in Each table By: selvakumar_82 on Mon, 06 November 2006 08:28
		Re: Creating PK in Each table By: JRowbottom on Mon, 06 November 2006 09:11
		Re: Creating PK in Each table By: selvakumar_82 on Mon, 06 November 2006 22:10
		Re: Creating PK in Each table By: selvakumar_82 on Tue, 07 November 2006 22:39
		Re: Creating PK in Each table By: JRowbottom on Wed, 08 November 2006 06:04
		Re: Creating PK in Each table By: selvakumar_82 on Wed, 08 November 2006 06:31
		Re: Creating PK in Each table By: Littlefoot on Wed, 08 November 2006 14:58
		Re: Creating PK in Each table By: JRowbottom on Thu, 09 November 2006 02:38

help need in optimizing a query....

By: chandanbhamra on Tue, 07 November 2006 05:10

		Performance thumb-rules By: panda on Wed, 01 November 2006 08:58
		Re: Performance thumb-rules By: kimant on Sat, 04 November 2006 15:41
		Re: Performance thumb-rules By: panda on Sun, 05 November 2006 14:10
		Re: Performance thumb-rules By: kimant on Mon, 06 November 2006 01:52
		Re: Performance thumb-rules By: panda on Mon, 06 November 2006 11:24
		Re: Performance thumb-rules By: kimant on Tue, 07 November 2006 02:44

Library Cache OVERHEAD

By: orafaqdba on Mon, 06 November 2006 12:53

		insert statement runs very slow By: beastjj on Mon, 06 November 2006 02:21
		Re: insert statement runs very slow By: beastjj on Mon, 06 November 2006 02:28

		v$librarycache By: Anand Ramaswamy on Fri, 03 November 2006 08:34
		Re: v$librarycache By: kimant on Sat, 04 November 2006 15:46
		Re: v$librarycache By: Anand Ramaswamy on Sat, 04 November 2006 23:16
		Re: v$librarycache By: kimant on Sun, 05 November 2006 13:35

		Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006 11:00
		Re: Tuning SQL statement in PL/SQL By: scottwmackey on Mon, 30 October 2006 15:46
		Re: Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006 19:19
		Re: Tuning SQL statement in PL/SQL By: skooman on Tue, 31 October 2006 10:58
		Re: Tuning SQL statement in PL/SQL By: scottwmackey on Tue, 31 October 2006 11:50
		Re: Tuning SQL statement in PL/SQL By: Akshar on Tue, 31 October 2006 12:56
		Re: Tuning SQL statement in PL/SQL By: rleishman on Tue, 31 October 2006 19:25
		Re: Tuning SQL statement in PL/SQL By: scottwmackey on Wed, 01 November 2006 00:54
		Re: Tuning SQL statement in PL/SQL By: Akshar on Wed, 01 November 2006 14:11
		Re: Tuning SQL statement in PL/SQL By: Frank on Thu, 02 November 2006 00:49
		Re: Tuning SQL statement in PL/SQL By: scottwmackey on Thu, 02 November 2006 09:21
		Re: Tuning SQL statement in PL/SQL By: Akshar on Sat, 04 November 2006 15:20
		Re: Tuning SQL statement in PL/SQL By: michael_bialik on Thu, 02 November 2006 02:07

		Will Deleting rows from Table improve Performance? By: kumarsz on Sat, 04 November 2006 12:43
		Re: Will Deleting rows from Table improve Performance? By: Littlefoot on Sat, 04 November 2006 13:35
		Re: Will Deleting rows from Table improve Performance? By: kimant on Sat, 04 November 2006 14:12

		insert statement runs slow By: Akshar on Fri, 27 October 2006 13:56
		Re: insert statement runs slow By: andrew again on Fri, 27 October 2006 14:21
		Re: insert statement runs slow By: Akshar on Fri, 27 October 2006 15:29
		Re: insert statement runs slow By: andrew again on Fri, 27 October 2006 15:38
		Re: insert statement runs slow By: Akshar on Tue, 31 October 2006 10:01
		Re: insert statement runs slow By: scottwmackey on Wed, 01 November 2006 01:27
		Re: insert statement runs slow By: Akshar on Wed, 01 November 2006 13:42
		Re: insert statement runs slow By: Admin@Lightsql.Com on Sat, 04 November 2006 03:23

		Inserts, update are taking long to execute. How to tune it? By: jiltin on Wed, 27 September 2006 16:37
		Re: Inserts, update are taking long to execute. How to tune it? By: Mahesh Rajendran on Wed, 27 September 2006 16:59
		Re: Inserts, update are taking long to execute. How to tune it? By: michael_bialik on Mon, 02 October 2006 07:27
		Re: Inserts, update are taking long to execute. How to tune it? By: jiltin on Sat, 04 November 2006 03:08

		how to change this query, runs forever By: leahchow on Thu, 02 November 2006 11:16
		Re: how to change this query, runs forever By: rleishman on Fri, 03 November 2006 00:25

		Partition Criteria By: piyushbhatt on Thu, 19 October 2006 03:33
		Re: Partition Criteria By: Mahesh Rajendran on Thu, 19 October 2006 05:32
		Re: Partition Criteria By: michael_bialik on Thu, 02 November 2006 08:24

		Tuning the query - Outer join By: bagulia_pilla on Tue, 31 October 2006 00:21
		Re: Tuning the query - Outer join By: rleishman on Tue, 31 October 2006 00:50
		Re: Tuning the query - Outer join By: bagulia_pilla on Tue, 31 October 2006 20:06
		Re: Tuning the query - Outer join By: rleishman on Tue, 31 October 2006 20:49
		Re: Tuning the query - Outer join By: S.Rajaram on Thu, 02 November 2006 02:12

		Performance tuning a table By: ezhilv on Mon, 30 October 2006 09:44
		Re: Performance tuning a table By: Mohammad Taj on Mon, 30 October 2006 09:48
		Re: Performance tuning a table By: Mahesh Rajendran on Mon, 30 October 2006 09:49
		Re: Performance tuning a table By: michael_bialik on Wed, 01 November 2006 07:00

		Advice on Hints By: ravgopal on Thu, 26 October 2006 14:09
		Re: Advice on Hints By: BlackSwan on Thu, 26 October 2006 14:23
		Re: Advice on Hints By: ravgopal on Thu, 26 October 2006 14:55
		Re: Advice on Hints By: ravgopal on Thu, 26 October 2006 16:41
		Re: Advice on Hints By: rleishman on Thu, 26 October 2006 21:10
		Re: Advice on Hints By: ravgopal on Fri, 27 October 2006 10:07
		Re: Advice on Hints By: ravgopal on Mon, 30 October 2006 12:57
		Re: Advice on Hints By: rleishman on Mon, 30 October 2006 16:57

STATS and Last Analyzed Column

By: faiz_hyd on Mon, 30 October 2006 11:01

		datafile random read average time By: seema.taunk on Fri, 27 October 2006 02:42
		Re: datafile random read average time By: Mahesh Rajendran on Fri, 27 October 2006 05:32
		Re: datafile random read average time By: seema.taunk on Mon, 30 October 2006 03:53

		Copying statistics of one table to another By: a_developer on Mon, 30 October 2006 02:34
		Re: Copying statistics of one table to another By: Mahesh Rajendran on Mon, 30 October 2006 03:06
		Re: Copying statistics of one table to another By: a_developer on Mon, 30 October 2006 03:16

		Find the Explain Plan from Trace File By: bellpk on Tue, 24 October 2006 08:34
		Re: Find the Explain Plan from Trace File By: kimant on Sun, 29 October 2006 13:10
		Re: Find the Explain Plan from Trace File By: bellpk on Sun, 29 October 2006 23:27

		move all objects from tbs to new tbs /rebuild all indexes to new tbs By: caraless on Fri, 27 October 2006 06:03
		Re: move all objects from tbs to new tbs /rebuild all indexes to new tbs By: Mohammad Taj on Sat, 28 October 2006 00:05

		problem when dropping table By: aline on Mon, 23 October 2006 16:16
		Re: problem when dropping table By: rleishman on Mon, 23 October 2006 21:08
		Re: problem when dropping table By: aline on Mon, 23 October 2006 23:19
		Re: problem when dropping table By: rleishman on Tue, 24 October 2006 00:03
		Re: problem when dropping table By: Mahesh Rajendran on Tue, 24 October 2006 05:07
		Re: problem when dropping table By: aline on Fri, 27 October 2006 02:49
		Re: problem when dropping table By: rleishman on Fri, 27 October 2006 19:02

		Reorganization of data/ Eliminate database fragmentation (export, drop and ... By: caraless on Thu, 26 October 2006 09:27
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: caraless on Thu, 26 October 2006 09:33
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: Mahesh Rajendran on Thu, 26 October 2006 09:41
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: caraless on Thu, 26 October 2006 10:06
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: Mahesh Rajendran on Thu, 26 October 2006 10:28
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: caraless on Thu, 26 October 2006 10:53
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: Mohammad Taj on Thu, 26 October 2006 10:56
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: caraless on Fri, 27 October 2006 03:39
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: Mahesh Rajendran on Fri, 27 October 2006 05:31
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: caraless on Fri, 27 October 2006 09:54
		Re: Reorganization of data/ Eliminate database fragmentation (export, drop ... By: Mahesh Rajendran on Thu, 26 October 2006 11:01

		Check v$sqlarea for shared cursors By: reena_ch30 on Thu, 26 October 2006 03:26
		Re: Check v$sqlarea for shared cursors By: Mohammad Taj on Thu, 26 October 2006 03:37
		Re: Check v$sqlarea for shared cursors By: reena_ch30 on Thu, 26 October 2006 03:59
		Re: Check v$sqlarea for shared cursors By: Mohammad Taj on Thu, 26 October 2006 04:12
		Re: Check v$sqlarea for shared cursors By: reena_ch30 on Thu, 26 October 2006 04:15
		Re: Check v$sqlarea for shared cursors By: reena_ch30 on Fri, 27 October 2006 00:58

		setting trace file name created using sql trace By: reena_ch30 on Thu, 26 October 2006 23:46
		Re: setting trace file name created using sql trace By: rleishman on Fri, 27 October 2006 00:04
		Re: setting trace file name created using sql trace By: reena_ch30 on Fri, 27 October 2006 00:33

		Update vs CTAS By: a_developer on Thu, 26 October 2006 08:31
		Re: Update vs CTAS By: Mahesh Rajendran on Thu, 26 October 2006 09:44
		Re: Update vs CTAS By: Kevin Meade on Thu, 26 October 2006 10:02

		Regarding v$librarycache By: reena_ch30 on Thu, 19 October 2006 01:47
		Re: Regarding v$librarycache By: Mahesh Rajendran on Thu, 19 October 2006 05:52
		Re: Regarding v$librarycache By: reena_ch30 on Thu, 19 October 2006 06:50
		Re: Regarding v$librarycache By: Mahesh Rajendran on Thu, 19 October 2006 07:04
		Re: Regarding v$librarycache By: reena_ch30 on Thu, 19 October 2006 08:14
		Re: Regarding v$librarycache By: reena_ch30 on Thu, 26 October 2006 05:34

		Help Deciding on Local or Global Index By: mdoakes42 on Wed, 25 October 2006 20:56
		Re: Help Deciding on Local or Global Index By: rleishman on Wed, 25 October 2006 21:36

Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME

By: beastjj on Wed, 25 October 2006 02:41

		Search option By: selvakumar_82 on Fri, 20 October 2006 00:20
		Re: Search option By: Littlefoot on Fri, 20 October 2006 02:21
		Re: Search option By: selvakumar_82 on Wed, 25 October 2006 00:10
		Re: Search option By: rleishman on Wed, 25 October 2006 00:29

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

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 08:51:05 CDT 2024