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.

		Query Performance By: jilpangs on Wed, 24 August 2005 13:23
		Re: Query Performance By: vjeedigunta on Thu, 25 August 2005 14:25

		how to figure out checkpoint running slow By: rkl1 on Mon, 22 August 2005 12:42
		Re: how to figure out checkpoint running slow By: deepa_balu on Wed, 24 August 2005 07:43

		Partitioning of tables need sugession By: ashishodia on Wed, 24 August 2005 03:34
		Re: Partitioning of tables need sugession By: girish.rohini on Wed, 24 August 2005 04:25

		Users and default optimizer_mode By: Scott Cowan on Tue, 23 August 2005 05:18
		Re: Users and default optimizer_mode By: mchadder on Tue, 23 August 2005 06:34
		Re: Users and default optimizer_mode By: Scott Cowan on Tue, 23 August 2005 07:57

		log file sync waits By: mjschwenger on Wed, 17 August 2005 23:45
		Re: log file sync waits By: kugenuma on Fri, 19 August 2005 02:11
		Re: log file sync waits By: Mahesh Rajendran on Fri, 19 August 2005 07:02
		Re: log file sync waits By: mjschwenger on Fri, 19 August 2005 08:28
		Re: log file sync waits By: kugenuma on Mon, 22 August 2005 01:00
		Re: log file sync waits By: smartin on Mon, 22 August 2005 08:37

		precise question: use a histogram here? By: sebastianR on Mon, 22 August 2005 07:19
		Re: precise question: use a histogram here? By: smartin on Mon, 22 August 2005 07:46

		How to rewrite a query By: mjschwenger on Sun, 21 August 2005 10:22
		Re: How to rewrite a query By: Barbara Boehmer on Sun, 21 August 2005 14:29
		Re: How to rewrite a query By: mjschwenger on Sun, 21 August 2005 16:05
		Re: How to rewrite a query By: Barbara Boehmer on Sun, 21 August 2005 16:54
		Re: How to rewrite a query By: Barbara Boehmer on Sun, 21 August 2005 17:10

		Hints on a poor performing view By: scottwmackey on Thu, 18 August 2005 15:25
		Re: Hints on a poor performing view By: smartin on Thu, 18 August 2005 16:39
		Re: Hints on a poor performing view By: scottwmackey on Thu, 18 August 2005 18:41
		Re: Hints on a poor performing view By: Barbara Boehmer on Fri, 19 August 2005 00:51
		Re: Hints on a poor performing view By: smartin on Fri, 19 August 2005 08:31
		Re: Hints on a poor performing view By: Art Metzer on Fri, 19 August 2005 10:12
		Re: Hints on a poor performing view By: smartin on Fri, 19 August 2005 10:31
		Re: Hints on a poor performing view By: scottwmackey on Fri, 19 August 2005 11:41

		index performing bad By: sebastianR on Fri, 19 August 2005 06:54
		Re: index performing bad By: sebastianR on Fri, 19 August 2005 07:26
		Re: index performing bad By: Mahesh Rajendran on Fri, 19 August 2005 07:31
		Re: index performing bad By: JSI2001 on Fri, 19 August 2005 07:37
		Re: index performing bad By: smartin on Fri, 19 August 2005 08:28
		Re: index performing bad By: sebastianR on Fri, 19 August 2005 09:16
		Re: index performing bad By: smartin on Fri, 19 August 2005 09:25

		Strange Database Shutdowns By: rkl1 on Tue, 16 August 2005 10:12
		Re: Strange Database Shutdowns By: kugenuma on Fri, 19 August 2005 02:24

		Drill to Evaluate By: rkl1 on Thu, 18 August 2005 17:03
		Re: Drill to Evaluate By: kugenuma on Fri, 19 August 2005 02:20

		tuning with statpack By: mjschwenger on Thu, 18 August 2005 17:27
		Re: tuning with statpack By: kugenuma on Fri, 19 August 2005 01:59

Selecivity on like in a query

By: stsy on Thu, 18 August 2005 07:18

		How to make this query fast? By: oracle_user_2005 on Wed, 10 August 2005 18:19
		Re: How to make this query fast? By: Art Metzer on Wed, 10 August 2005 21:00
		Re: How to make this query fast? By: oracle_user_2005 on Thu, 11 August 2005 10:22
		Re: How to make this query fast? By: Mahesh Rajendran on Thu, 11 August 2005 10:42
		Re: How to make this query fast? By: oracle_user_2005 on Thu, 11 August 2005 11:35
		Re: How to make this query fast? By: oracle_user_2005 on Thu, 11 August 2005 12:55
		Re: How to make this query fast? By: Mahesh Rajendran on Thu, 11 August 2005 13:33
		Re: How to make this query fast? By: oracle_user_2005 on Thu, 11 August 2005 16:19
		Re: How to make this query fast? By: Mahesh Rajendran on Thu, 11 August 2005 19:50
		Re: How to make this query fast? By: Mahesh Rajendran on Fri, 12 August 2005 04:44
		Re: How to make this query fast? By: oracle_user_2005 on Wed, 17 August 2005 15:36

		slow server By: mjschwenger on Wed, 17 August 2005 10:19
		Re: slow server By: mjschwenger on Wed, 17 August 2005 11:34

		Move Production database to test environment for load tests By: HansHaeberle on Wed, 17 August 2005 08:05
		Re: Move Production database to test environment for load tests By: Mahesh Rajendran on Wed, 17 August 2005 08:11
		Re: Move Production database to test environment for load tests By: HansHaeberle on Wed, 17 August 2005 08:21

		Foreign Keys vs. custom scripts By: andogs on Tue, 16 August 2005 07:54
		Re: Foreign Keys vs. custom scripts By: Mahesh Rajendran on Tue, 16 August 2005 08:03
		Re: Foreign Keys vs. custom scripts By: Maaher on Wed, 17 August 2005 05:19

		Urgent reply needed By: RB on Mon, 15 August 2005 14:03
		Re: Urgent reply needed By: smartin on Mon, 15 August 2005 14:27
		Re: Urgent reply needed By: RB on Mon, 15 August 2005 14:30
		Re: Urgent reply needed By: smartin on Mon, 15 August 2005 14:40
		Re: Urgent reply needed By: RB on Mon, 15 August 2005 14:53

		Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? By: nmacdannald on Mon, 15 August 2005 13:46
		Re: Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? By: smartin on Mon, 15 August 2005 14:26

		Oracle 8.1.6 Solaris 7 - redo log group switch By: nmacdannald on Tue, 09 August 2005 15:38
		Re: Oracle 8.1.6 Solaris 7 - redo log group switch By: nmacdannald on Tue, 09 August 2005 16:42
		Re: Oracle 8.1.6 Solaris 7 - redo log group switch By: skempins on Sat, 13 August 2005 09:33
		Re: Oracle 8.1.6 Solaris 7 - redo log group switch By: JSI2001 on Mon, 15 August 2005 03:12
		Re: Oracle 8.1.6 Solaris 7 - redo log group switch By: alliejane on Mon, 15 August 2005 09:41
		Re: Oracle 8.1.6 Solaris 7 - redo log group switch By: nmacdannald on Mon, 15 August 2005 13:39

		Row chaining and Local Tablespace By: rkl1 on Wed, 10 August 2005 22:51
		Re: Row chaining and Local Tablespace By: Mahesh Rajendran on Thu, 11 August 2005 07:00
		Re: Row chaining and Local Tablespace By: smartin on Thu, 11 August 2005 13:39
		Re: Row chaining and Local Tablespace By: alliejane on Mon, 15 August 2005 09:14
		Re: Row chaining and Local Tablespace By: smartin on Mon, 15 August 2005 09:36
		Re: Row chaining and Local Tablespace By: alliejane on Mon, 15 August 2005 09:44
		Re: Row chaining and Local Tablespace By: smartin on Mon, 15 August 2005 10:21

		Performance problem By: Manav on Thu, 11 August 2005 06:23
		Re: Performance problem By: Art Metzer on Thu, 11 August 2005 07:27
		Re: Performance problem By: smartin on Thu, 11 August 2005 13:44
		Re: Performance problem By: Manav on Thu, 11 August 2005 22:44
		Re: Performance problem By: smartin on Fri, 12 August 2005 11:14
		Re: Performance problem By: Manav on Sun, 14 August 2005 02:03
		Re: Performance problem By: Barbara Boehmer on Sun, 14 August 2005 12:20

		open connection memory overhead By: mjschwenger on Wed, 10 August 2005 14:40
		Re: open connection memory overhead By: Art Metzer on Wed, 10 August 2005 16:21
		Re: open connection memory overhead By: skempins on Sat, 13 August 2005 10:01

		B*-tree or bitmap index? By: quetzalcoatl on Thu, 11 August 2005 16:45
		Re: B*-tree or bitmap index? By: Mahesh Rajendran on Thu, 11 August 2005 19:07

		How to make this query run faster using PL/SQL update and insert By: Rathor on Thu, 11 August 2005 09:46
		Re: How to make this query run faster using PL/SQL update and insert By: Mahesh Rajendran on Thu, 11 August 2005 13:58

		how to get full version of sql statement By: rgopani on Thu, 11 August 2005 02:13
		Re: how to get full version of sql statement By: Mahesh Rajendran on Thu, 11 August 2005 06:52

		Full Table Scan By: puneetsachar on Wed, 10 August 2005 09:02
		Re: Full Table Scan By: Mahesh Rajendran on Wed, 10 August 2005 10:21
		Re: Full Table Scan By: Art Metzer on Wed, 10 August 2005 14:20
		Re: Full Table Scan By: puneetsachar on Thu, 11 August 2005 03:35

		All sorting etc done on temp space By: djcot on Tue, 09 August 2005 19:58
		Re: All sorting etc done on temp space By: Art Metzer on Wed, 10 August 2005 14:25
		Re: All sorting etc done on temp space By: djcot on Wed, 10 August 2005 16:46

		I don't get Rows & Row Source Operation By: perfnewbee on Wed, 10 August 2005 15:13
		Re: I don't get Rows & Row Source Operation By: Mahesh Rajendran on Wed, 10 August 2005 15:40
		Re: I don't get Rows & Row Source Operation By: perfnewbee on Wed, 10 August 2005 15:44
		Re: I don't get Rows & Row Source Operation By: Mahesh Rajendran on Wed, 10 August 2005 15:49

		Solaris 7 Oracle 8.1.6 logfile switch takes 10 minutes By: nmacdannald on Mon, 08 August 2005 20:41
		Re: Solaris 7 Oracle 8.1.6 logfile switch takes 10 minutes By: Art Metzer on Wed, 10 August 2005 14:31

		Index & Performance Tuning By: csharpdev on Tue, 09 August 2005 06:33
		Re: Index & Performance Tuning By: JSI2001 on Tue, 09 August 2005 06:55
		Re: Index & Performance Tuning By: Art Metzer on Wed, 10 August 2005 14:27

		best strategy to gather statistics in a very dynamic By: peterzaweber on Wed, 10 August 2005 02:46
		Re: best strategy to gather statistics in a very dynamic By: Mahesh Rajendran on Wed, 10 August 2005 07:32
		Re: best strategy to gather statistics in a very dynamic By: peterzaweber on Wed, 10 August 2005 08:26
		Re: best strategy to gather statistics in a very dynamic By: Mahesh Rajendran on Wed, 10 August 2005 08:45

		How manage over 8GB memory By: enkhbold on Mon, 25 July 2005 00:02
		Re: How manage over 8GB memory By: girish.rohini on Mon, 25 July 2005 01:43
		Re: How manage over 8GB memory By: SoporteDBA on Mon, 25 July 2005 08:55
		Re: How manage over 8GB memory By: nmacdannald on Tue, 09 August 2005 15:53

		who reads the redo logs By: mjschwenger on Wed, 03 August 2005 18:03
		Re: who reads the redo logs By: girish.rohini on Wed, 03 August 2005 23:50
		Re: who reads the redo logs By: Mahesh Rajendran on Thu, 04 August 2005 08:35
		Re: who reads the redo logs By: mjschwenger on Thu, 04 August 2005 09:51
		Re: who reads the redo logs By: Mahesh Rajendran on Thu, 04 August 2005 10:21
		Re: who reads the redo logs By: nmacdannald on Tue, 09 August 2005 15:50

SQL Analyze

By: quetzalcoatl on Tue, 09 August 2005 13:36

		indexes sql tunning By: quetzalcoatl on Mon, 08 August 2005 19:29
		Re: indexes sql tunning By: Mahesh Rajendran on Mon, 08 August 2005 20:46

		how to split the query using rowid By: confident on Thu, 28 July 2005 20:55
		Re: how to split the query using rowid By: nmacdannald on Mon, 08 August 2005 13:12

		user_segments and tablesize:some thing wrong By: rkl1 on Mon, 08 August 2005 10:32
		Re: user_segments and tablesize:some thing wrong By: JSI2001 on Mon, 08 August 2005 11:09
		Re: user_segments and tablesize:some thing wrong By: Mahesh Rajendran on Mon, 08 August 2005 11:57
		Re: user_segments and tablesize:some thing wrong By: rkl1 on Mon, 08 August 2005 12:03

8.1.6 control file too large, how to shrink?

By: nmacdannald on Mon, 08 August 2005 02:44

		What is the use of index By: vidya2005 on Tue, 02 August 2005 23:28
		Re: What is the use of index By: milind_sri on Tue, 02 August 2005 23:49
		Re: What is the use of index By: vidya2005 on Tue, 02 August 2005 23:56
		Re: What is the use of index By: tarundua on Wed, 03 August 2005 00:02
		Re: What is the use of index By: talvasson on Wed, 03 August 2005 08:40
		Re: What is the use of index By: sharan_it on Fri, 05 August 2005 01:42
		Re: What is the use of index By: vidya2005 on Fri, 05 August 2005 23:04

Pages (119): [ « ‹ 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 › »]

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 13:23:37 CDT 2024