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 sequence By: belboey on Sun, 12 June 2005 22:43
		Re: Oracle sequence By: d.dineshkumar on Mon, 13 June 2005 06:04
		Re: Oracle sequence By: smartin on Mon, 13 June 2005 09:36

		When to use index By: d.dineshkumar on Fri, 03 June 2005 07:13
		Re: When to use index By: Mahesh Rajendran on Fri, 03 June 2005 08:07
		Re: When to use index By: nabeelkhan on Thu, 09 June 2005 04:11
		Re: When to use index By: Art Metzer on Thu, 09 June 2005 08:47
		Re: When to use index By: sunil_v_mishra on Thu, 09 June 2005 21:02
		Re: When to use index By: nabeelkhan on Sun, 12 June 2005 00:56
		Re: When to use index By: d.dineshkumar on Mon, 13 June 2005 05:53

Constraint state in DWH environment (rely disable novalidate)

By: henning.schroer on Sun, 12 June 2005 04:30

		Explain Plan - number of rows returned. By: Lee Sutton on Wed, 08 June 2005 08:13
		Re: Explain Plan - number of rows returned. By: nabeelkhan on Thu, 09 June 2005 04:09
		Re: Explain Plan - number of rows returned. By: smartin on Thu, 09 June 2005 09:18
		Re: Explain Plan - number of rows returned. By: Lee Sutton on Thu, 09 June 2005 09:42
		Re: Explain Plan - number of rows returned. By: Lee Sutton on Thu, 09 June 2005 09:41
		Re: Explain Plan - number of rows returned. By: Lee Sutton on Fri, 10 June 2005 08:08

		Index Question By: j_potucek on Tue, 03 May 2005 14:34
		Re: Index Question By: Mahesh Rajendran on Tue, 03 May 2005 15:04
		Re: Index Question By: nabeelkhan on Thu, 09 June 2005 04:15

		What is happening with this sql? By: rramanat on Fri, 27 May 2005 02:11
		Re: What is happening with this sql? By: rramanat on Fri, 27 May 2005 02:16
		Re: What is happening with this sql? By: dmitry.nikiforov on Fri, 27 May 2005 04:04
		Re: What is happening with this sql? By: rramanat on Fri, 27 May 2005 04:15
		Re: What is happening with this sql? By: dmitry.nikiforov on Fri, 27 May 2005 04:51
		Re: What is happening with this sql? By: smartin on Fri, 27 May 2005 08:58
		Re: What is happening with this sql? By: pscjhe on Fri, 27 May 2005 14:17
		Re: What is happening with this sql? By: rramanat on Tue, 31 May 2005 22:05
		Re: What is happening with this sql? By: dmitry.nikiforov on Wed, 01 June 2005 02:20
		Re: What is happening with this sql? By: smartin on Wed, 01 June 2005 09:02
		Re: What is happening with this sql? By: Frank on Wed, 01 June 2005 11:07
		Re: What is happening with this sql? By: rramanat on Sun, 05 June 2005 21:41
		Re: What is happening with this sql? By: rramanat on Wed, 08 June 2005 02:48
		Re: What is happening with this sql? By: smartin on Wed, 08 June 2005 09:33
		Re: What is happening with this sql? By: smartin on Wed, 08 June 2005 09:39
		Re: What is happening with this sql? By: rramanat on Wed, 08 June 2005 20:10

		select large amount of data By: r2d2dev on Wed, 08 June 2005 14:45
		Re: select large amount of data By: Art Metzer on Wed, 08 June 2005 15:47

		forced view By: ramvenky on Tue, 07 June 2005 03:49
		Re: forced view By: girish.rohini on Tue, 07 June 2005 03:59
		Re: forced view By: Frank on Tue, 07 June 2005 12:15
		Re: forced view By: smartin on Tue, 07 June 2005 12:24
		Re: forced view By: nabeelkhan on Wed, 08 June 2005 00:20

		URGENT:-Performance Tuning. By: milind_sri on Wed, 18 May 2005 03:40
		Re: URGENT:-Performance Tuning. By: smartin on Wed, 18 May 2005 09:36
		Re: URGENT:-Performance Tuning. By: milind_sri on Wed, 18 May 2005 09:54
		Re: URGENT:-Performance Tuning. By: smartin on Wed, 18 May 2005 11:03
		Re: URGENT:-Performance Tuning. By: milind_sri on Thu, 19 May 2005 03:39
		Re: URGENT:-Performance Tuning. By: smartin on Thu, 19 May 2005 08:25
		Re: URGENT:-Performance Tuning. By: nabeelkhan on Tue, 07 June 2005 00:49
		Re: URGENT:-Performance Tuning. By: smartin on Tue, 07 June 2005 12:15
		Re: URGENT:-Performance Tuning. By: skempins on Tue, 07 June 2005 15:28

		Stubborn Query By: tansdot on Thu, 02 June 2005 21:46
		Re: Stubborn Query By: Art Metzer on Thu, 02 June 2005 23:07
		Re: Stubborn Query By: girish.rohini on Tue, 07 June 2005 04:43
		Re: Stubborn Query By: nabeelkhan on Tue, 07 June 2005 04:57
		Re: Stubborn Query By: nabeelkhan on Tue, 07 June 2005 06:35

		How to read the execution plan By: shibu on Wed, 01 June 2005 02:54
		Re: How to read the execution plan By: nabeelkhan on Thu, 02 June 2005 03:59
		Re: How to read the execution plan By: shibu on Fri, 03 June 2005 00:28
		Re: How to read the execution plan By: nabeelkhan on Sun, 05 June 2005 02:55
		Re: How to read the execution plan By: shibu on Mon, 06 June 2005 08:11
		Re: How to read the execution plan By: joeancell on Fri, 03 June 2005 18:00
		Re: How to read the execution plan By: smartin on Mon, 06 June 2005 09:06

		Composite bitmap indexes By: tansdot on Fri, 03 June 2005 03:23
		Re: Composite bitmap indexes By: dmitry.nikiforov on Fri, 03 June 2005 07:46
		Re: Composite bitmap indexes By: smartin on Mon, 06 June 2005 08:49

		can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: reyazan on Sat, 07 May 2005 02:16
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: girish.rohini on Sat, 07 May 2005 14:58
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: sunil_v_mishra on Tue, 10 May 2005 09:28
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: aviananta on Wed, 01 June 2005 00:37
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: girish.rohini on Wed, 01 June 2005 01:50
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: sunil_v_mishra on Wed, 01 June 2005 02:43
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: nabeelkhan on Thu, 02 June 2005 04:41
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: nabeelkhan on Thu, 02 June 2005 07:55
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: nabeelkhan on Thu, 02 June 2005 08:03
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: girish.rohini on Thu, 02 June 2005 13:15
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: nabeelkhan on Sun, 05 June 2005 01:15
		Re: can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: girish.rohini on Sun, 05 June 2005 09:00

		Reg. out put of DBMS_XPLAN.DISPLAY By: d.dineshkumar on Fri, 03 June 2005 07:00
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: Mahesh Rajendran on Fri, 03 June 2005 07:58
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: d.dineshkumar on Fri, 03 June 2005 08:09
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: Mahesh Rajendran on Fri, 03 June 2005 08:35
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: d.dineshkumar on Fri, 03 June 2005 09:17
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: Mahesh Rajendran on Fri, 03 June 2005 09:30
		Re: Reg. out put of DBMS_XPLAN.DISPLAY By: nabeelkhan on Sun, 05 June 2005 07:23

		Select on same table gives poor performace. By: abc123 on Sat, 04 June 2005 08:36
		Re: Select on same table gives poor performace. By: nabeelkhan on Sun, 05 June 2005 02:24

		Index Partition rebuild Query By: bhagwan on Fri, 03 June 2005 03:16
		Re: Index Partition rebuild Query By: carsten.jorgensen on Fri, 03 June 2005 08:16

		The same sql runs very slowly in jboss-cmp,very quickly in native jdbc. By: peixubin on Wed, 01 June 2005 04:09
		Re: The same sql runs very slowly in jboss-cmp,very quickly in native jdbc. By: peixubin on Thu, 02 June 2005 21:01

		Oracle Server Information By: well_rbs on Tue, 31 May 2005 05:45
		Re: Oracle Server Information By: smartin on Tue, 31 May 2005 09:07

		What are the steps to tune a query By: d.dineshkumar on Mon, 30 May 2005 02:03
		Re: What are the steps to tune a query By: d.dineshkumar on Mon, 30 May 2005 03:30
		Re: What are the steps to tune a query By: girish.rohini on Mon, 30 May 2005 03:58
		Re: What are the steps to tune a query By: d.dineshkumar on Mon, 30 May 2005 09:08

		Datawarehouse query By: well_rbs on Thu, 26 May 2005 02:15
		Re: Datawarehouse query By: Art Metzer on Thu, 26 May 2005 10:15
		Re: Datawarehouse query By: DMcG on Thu, 26 May 2005 17:37
		Re: Datawarehouse query By: well_rbs on Thu, 26 May 2005 20:41

		All "Rows" equal 0 in TKPROF. Is this a setting? By: scottwmackey on Wed, 25 May 2005 17:54
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: Frank Naude on Thu, 26 May 2005 01:07
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: scottwmackey on Thu, 26 May 2005 02:05
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: Frank Naude on Thu, 26 May 2005 05:55
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: scottwmackey on Thu, 26 May 2005 14:15
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: Art Metzer on Thu, 26 May 2005 10:32
		Re: All "Rows" equal 0 in TKPROF. Is this a setting? By: scottwmackey on Thu, 26 May 2005 14:27

		Batch Tuning By: kanth33 on Mon, 23 May 2005 15:16
		Re: Batch Tuning By: Mahesh Rajendran on Mon, 23 May 2005 15:39
		Re: Batch Tuning By: kanth33 on Mon, 23 May 2005 15:43
		Re: Batch Tuning By: Mahesh Rajendran on Mon, 23 May 2005 15:49

		Performance problem!! By: kinjal on Mon, 23 May 2005 00:34
		Re: Performance problem!! By: smartin on Mon, 23 May 2005 09:22
		Re: Performance problem!! By: Mahesh Rajendran on Mon, 23 May 2005 09:44

		activating Online Index Build By: mbexel on Wed, 18 May 2005 09:50
		Re: activating Online Index Build By: smartin on Thu, 19 May 2005 08:27
		Re: activating Online Index Build By: mbexel on Fri, 20 May 2005 04:45
		Re: activating Online Index Build By: smartin on Fri, 20 May 2005 08:58

		Statspack for 9i on 8.1.6 By: _simma_dba on Fri, 13 May 2005 07:00
		Re: Statspack for 9i on 8.1.6 By: Frank Naude on Fri, 20 May 2005 06:07

		Ploblem connect oracle by Vb application By: chara on Tue, 17 May 2005 04:36
		Re: Ploblem connect oracle by Vb application By: girish.rohini on Tue, 17 May 2005 06:01
		Re: Ploblem connect oracle by Vb application By: chara on Wed, 18 May 2005 07:02
		Re: Ploblem connect oracle by Vb application By: girish.rohini on Wed, 18 May 2005 10:44

		Prameters For Improving DB Perfomance By: ksst on Fri, 13 May 2005 12:44
		Re: Prameters For Improving DB Perfomance By: smartin on Fri, 13 May 2005 15:10
		Re: Prameters For Improving DB Perfomance By: andrew again on Fri, 13 May 2005 19:05
		Re: Prameters For Improving DB Perfomance By: smartin on Fri, 13 May 2005 22:33

		statspack top 5 wait event By: confident on Thu, 12 May 2005 10:52
		Re: statspack top 5 wait event By: confident on Thu, 12 May 2005 19:28
		Re: statspack top 5 wait event By: Frank on Fri, 13 May 2005 07:24

		Comparision of Two Execution Plan By: sujit_ocp on Tue, 10 May 2005 06:10
		Re: Comparision of Two Execution Plan By: Mahesh Rajendran on Tue, 10 May 2005 08:07
		Re: Comparision of Two Execution Plan By: sujit_ocp on Tue, 10 May 2005 08:14
		Re: Comparision of Two Execution Plan By: Mahesh Rajendran on Tue, 10 May 2005 08:29
		Re: Comparision of Two Execution Plan By: smartin on Wed, 11 May 2005 09:07

		ARCHIVELOG GETTING FILLED By: nitin_228 on Mon, 09 May 2005 12:35
		Re: ARCHIVELOG GETTING FILLED By: mihelic on Tue, 10 May 2005 02:16

		Cursor Performance Issue By: sujit_ocp on Tue, 10 May 2005 01:47
		Re: Cursor Performance Issue By: Barbara Boehmer on Tue, 10 May 2005 02:07

		Oracle Schema slowing performance By: ravin on Wed, 04 May 2005 13:41
		Re: Oracle Schema slowing performance By: smartin on Wed, 04 May 2005 15:17
		Re: Oracle Schema slowing performance By: ravin on Thu, 05 May 2005 02:07
		Re: Oracle Schema slowing performance By: Frank on Thu, 05 May 2005 04:05
		Re: Oracle Schema slowing performance By: ravin on Thu, 05 May 2005 04:40
		Re: Oracle Schema slowing performance By: Mahesh Rajendran on Mon, 09 May 2005 08:35
		Re: Oracle Schema slowing performance By: tycoonajayverma on Thu, 05 May 2005 07:31
		Re: Oracle Schema slowing performance By: tycoonajayverma on Thu, 05 May 2005 07:32
		Re: Oracle Schema slowing performance By: Satheesh Babu.S on Mon, 09 May 2005 08:06
		Re: Oracle Schema slowing performance By: Frank on Mon, 09 May 2005 12:23

		Query takes long time -need help to improve Performance By: pzlj6x on Fri, 06 May 2005 13:20
		Re: Query takes long time -need help to improve Performance By: Mahesh Rajendran on Fri, 06 May 2005 13:33
		Re: Query takes long time -need help to improve Performance By: pzlj6x on Sat, 07 May 2005 08:18
		Re: Query takes long time -need help to improve Performance By: Frank on Fri, 06 May 2005 14:11
		Re: Query takes long time -need help to improve Performance By: pzlj6x on Sat, 07 May 2005 08:14

		Why does checkpoint only happen at log switch? :( By: Jadie on Thu, 05 May 2005 16:02
		Re: Why does checkpoint only happen at log switch? :( By: girish.rohini on Fri, 06 May 2005 04:08
		Re: Why does checkpoint only happen at log switch? :( By: Jadie on Fri, 06 May 2005 13:48

		max size of sga in oracle 81 windows 2000 server By: reyazan on Thu, 05 May 2005 08:36
		Re: max size of sga in oracle 81 windows 2000 server By: girish.rohini on Thu, 05 May 2005 11:47

		dbms_stats By: balavignesh on Mon, 02 May 2005 13:47
		Re: dbms_stats By: Barbara Boehmer on Mon, 02 May 2005 22:57
		Re: dbms_stats By: balavignesh on Tue, 03 May 2005 08:40

		Explain Plan Doubt By: sujit_ocp on Mon, 02 May 2005 05:32
		Re: Explain Plan Doubt By: Mahesh Rajendran on Mon, 02 May 2005 08:19
		Re: Explain Plan Doubt By: sujit_ocp on Mon, 02 May 2005 09:22
		Re: Explain Plan Doubt By: Mahesh Rajendran on Mon, 02 May 2005 09:31
		Re: Explain Plan Doubt By: smartin on Mon, 02 May 2005 09:47
		Re: Explain Plan Doubt By: sujit_ocp on Mon, 02 May 2005 10:11

		what should be approximate Size of SGA ? By: sunil_v_mishra on Sun, 24 April 2005 03:04
		Re: what should be approximate Size of SGA ? By: chunyuh on Sun, 01 May 2005 21:08

		Deleting from Huge table By: abc123 on Thu, 28 April 2005 02:22
		Re: Deleting from Huge table By: Mahesh Rajendran on Thu, 28 April 2005 06:11
		Re: Deleting from Huge table By: girish.rohini on Thu, 28 April 2005 06:11
		Re: Deleting from Huge table By: smartin on Thu, 28 April 2005 08:53
		Re: Deleting from Huge table By: pscjhe on Fri, 29 April 2005 11:48

		V$SYSSTAT By: milind_sri on Fri, 29 April 2005 08:31
		Re: V$SYSSTAT By: Frank Naude on Fri, 29 April 2005 08:44

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

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 May 06 00:08:45 CDT 2024