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.

		How to remove left join and ON JOIN from query and use better things in pla... By: nishantranjan00787 on Mon, 21 July 2014 01:15
		Re: How to remove left join and ON JOIN from query and use better things in... By: tarundua on Mon, 21 July 2014 01:30
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 01:45
		Re: How to remove left join and ON JOIN from query and use better things in... By: John Watson on Mon, 21 July 2014 01:59
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 02:03
		Re: How to remove left join and ON JOIN from query and use better things in... By: John Watson on Mon, 21 July 2014 02:06
		Re: How to remove left join and ON JOIN from query and use better things in... By: cookiemonster on Mon, 21 July 2014 03:09
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 03:34
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 03:39
		Re: How to remove left join and ON JOIN from query and use better things in... By: cookiemonster on Mon, 21 July 2014 03:43
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 03:54
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 03:55
		Re: How to remove left join and ON JOIN from query and use better things in... By: cookiemonster on Mon, 21 July 2014 04:00
		Re: How to remove left join and ON JOIN from query and use better things in... By: cookiemonster on Mon, 21 July 2014 04:19
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 21 July 2014 04:19
		Re: How to remove left join and ON JOIN from query and use better things in... By: cookiemonster on Mon, 21 July 2014 04:20
		<more>
		Re: How to remove left join and ON JOIN from query and use better things in... By: John Watson on Mon, 21 July 2014 04:49
		<more>
		Re: How to remove left join and ON JOIN from query and use better things in... By: michael_bialik on Tue, 22 July 2014 07:58
		Re: How to remove left join and ON JOIN from query and use better things in... By: nishantranjan00787 on Mon, 28 July 2014 10:55
		Error while running script By: nishantranjan00787 on Mon, 28 July 2014 12:47
		Re: Error while running script By: John Watson on Mon, 28 July 2014 12:51
		Re: Error while running script By: John Watson on Mon, 28 July 2014 12:54
		Re: Error while running script By: nishantranjan00787 on Mon, 28 July 2014 12:58
		Re: Error while running script By: John Watson on Mon, 28 July 2014 13:01
		Re: Error while running script By: nishantranjan00787 on Mon, 28 July 2014 13:02
		Re: Error while running script By: BlackSwan on Mon, 28 July 2014 13:07
		Re: Error while running script By: John Watson on Mon, 28 July 2014 13:09
		Re: Error while running script By: nishantranjan00787 on Mon, 28 July 2014 13:16
		Re: Error while running script By: John Watson on Mon, 28 July 2014 13:23
		Re: Error while running script By: nishantranjan00787 on Mon, 28 July 2014 13:57
		Re: Error while running script By: John Watson on Mon, 28 July 2014 14:26
		Re: Error while running script By: nishantranjan00787 on Tue, 29 July 2014 05:49
		Re: Error while running script By: Roachcoach on Tue, 29 July 2014 05:54
		Re: Error while running script By: nishantranjan00787 on Tue, 29 July 2014 06:28
		Re: Error while running script By: cookiemonster on Tue, 29 July 2014 08:04
		Re: Error while running script By: cookiemonster on Tue, 29 July 2014 08:08
		<more>

		After Table analyze, the number of blocks goes Down By: hitesh.bhatt on Thu, 24 July 2014 23:35
		Re: After Table analyze, the number of blocks goes Down By: Michel Cadot on Fri, 25 July 2014 00:28
		Re: After Table analyze, the number of blocks goes Down By: hitesh.bhatt on Fri, 25 July 2014 00:30
		Re: After Table analyze, the number of blocks goes Down By: Michel Cadot on Fri, 25 July 2014 00:44
		Re: After Table analyze, the number of blocks goes Down By: hitesh.bhatt on Fri, 25 July 2014 01:02
		Re: After Table analyze, the number of blocks goes Down By: Michel Cadot on Fri, 25 July 2014 01:50
		Re: After Table analyze, the number of blocks goes Down By: John Watson on Fri, 25 July 2014 02:19
		Re: After Table analyze, the number of blocks goes Down By: hitesh.bhatt on Wed, 30 July 2014 04:14

		Partitioning on a VARCHAR2 column By: mafoe on Mon, 28 July 2014 10:19
		Re: Partitioning on a VARCHAR2 column By: John Watson on Mon, 28 July 2014 10:27
		Re: Partitioning on a VARCHAR2 column By: mafoe on Mon, 28 July 2014 10:47
		Re: Partitioning on a VARCHAR2 column By: rleishman on Mon, 28 July 2014 19:32
		Re: Partitioning on a VARCHAR2 column By: mafoe on Tue, 29 July 2014 04:21
		Re: Partitioning on a VARCHAR2 column By: Roachcoach on Tue, 29 July 2014 04:29
		Re: Partitioning on a VARCHAR2 column By: Lalit Kumar B on Tue, 29 July 2014 00:57

		Performance issue By: ramanaapps on Fri, 25 July 2014 00:25
		Re: Performance issue By: Michel Cadot on Fri, 25 July 2014 00:30
		Re: Performance issue By: ramanaapps on Fri, 25 July 2014 00:37
		Re: Performance issue By: Michel Cadot on Fri, 25 July 2014 00:44
		Re: Performance issue By: ramanaapps on Fri, 25 July 2014 00:46
		Re: Performance issue By: rleishman on Fri, 25 July 2014 01:13
		Re: Performance issue By: ramanaapps on Fri, 25 July 2014 01:43
		Re: Performance issue By: Michel Cadot on Fri, 25 July 2014 01:53
		Re: Performance issue By: Lalit Kumar B on Fri, 25 July 2014 00:30
		Re: Performance issue By: John Watson on Fri, 25 July 2014 02:25
		Re: Performance issue By: ramanaapps on Fri, 25 July 2014 03:36
		Re: Performance issue By: Lalit Kumar B on Fri, 25 July 2014 05:32
		Re: Performance issue By: Kevin Meade on Sat, 26 July 2014 02:31
		Re: Performance issue By: Lalit Kumar B on Sat, 26 July 2014 05:46
		Re: Performance issue By: Lalit Kumar B on Sat, 26 July 2014 07:10
		Re: Performance issue By: Kevin Meade on Sat, 26 July 2014 08:44
		Re: Performance issue By: Kevin Meade on Sat, 26 July 2014 08:55

		A question about SPM By: orausern on Thu, 24 July 2014 11:49
		Re: A question about SPM By: Lalit Kumar B on Thu, 24 July 2014 12:47
		Re: A question about SPM By: orausern on Thu, 24 July 2014 12:48

		performance lag of the quey By: andrewscharles89 on Tue, 01 July 2014 07:34
		Re: performance lag of the quey By: cookiemonster on Tue, 01 July 2014 07:45
		Re: performance lag of the quey By: Michel Cadot on Tue, 01 July 2014 07:46
		Re: performance lag of the quey By: andrewscharles89 on Tue, 01 July 2014 08:23
		Re: performance lag of the quey By: Lalit Kumar B on Tue, 01 July 2014 08:27
		Re: performance lag of the quey By: andrewscharles89 on Tue, 01 July 2014 08:30
		Re: performance lag of the quey By: Lalit Kumar B on Tue, 01 July 2014 08:32
		Re: performance lag of the quey By: BlackSwan on Tue, 01 July 2014 08:36
		Re: performance lag of the quey By: andrewscharles89 on Tue, 01 July 2014 09:11
		Re: performance lag of the quey By: BlackSwan on Tue, 01 July 2014 09:16
		Re: performance lag of the quey By: cookiemonster on Wed, 02 July 2014 02:41
		Re: performance lag of the quey By: Lalit Kumar B on Tue, 01 July 2014 07:48
		Re: performance lag of the quey By: John Watson on Wed, 02 July 2014 02:52
		Re: performance lag of the quey By: Lalit Kumar B on Wed, 02 July 2014 03:18
		Re: performance lag of the quey By: andrewscharles89 on Wed, 02 July 2014 07:58
		Re: performance lag of the quey By: John Watson on Wed, 02 July 2014 08:09
		Re: performance lag of the quey By: michael_bialik on Thu, 03 July 2014 00:28
		Re: performance lag of the quey By: LNossov on Thu, 24 July 2014 11:36

		Performance Tuning By: andrewscharles89 on Thu, 10 July 2014 11:47
		Re: Performance Tuning By: Lalit Kumar B on Thu, 10 July 2014 11:56
		Re: Performance Tuning By: BlackSwan on Thu, 10 July 2014 11:59
		Re: Performance Tuning By: Lalit Kumar B on Thu, 10 July 2014 12:12
		Re: Performance Tuning By: andrewscharles89 on Thu, 10 July 2014 12:28
		Re: Performance Tuning By: BlackSwan on Thu, 10 July 2014 12:30
		Re: Performance Tuning By: Lalit Kumar B on Thu, 10 July 2014 12:33
		Re: Performance Tuning By: BlackSwan on Thu, 10 July 2014 12:40
		Re: Performance Tuning By: andrewscharles89 on Fri, 11 July 2014 09:31
		Re: Performance Tuning By: cookiemonster on Fri, 11 July 2014 09:37
		Re: Performance Tuning By: Kevin Meade on Sat, 12 July 2014 01:54
		Re: Performance Tuning By: michael_bialik on Tue, 22 July 2014 08:20

		How to revert the work done by accept_sql_profile procedure & Issues to... By: orausern on Mon, 14 July 2014 13:25
		Re: How to revert the work done by accept_sql_profile procedure By: BlackSwan on Mon, 14 July 2014 13:31
		Re: How to revert the work done by accept_sql_profile procedure By: John Watson on Mon, 14 July 2014 13:35
		Re: How to revert the work done by accept_sql_profile procedure By: orausern on Mon, 14 July 2014 13:41
		Re: How to revert the work done by accept_sql_profile procedure By: BlackSwan on Mon, 14 July 2014 13:45
		Re: How to revert the work done by accept_sql_profile procedure By: John Watson on Mon, 14 July 2014 13:46
		Re: How to revert the work done by accept_sql_profile procedure By: orausern on Mon, 14 July 2014 13:54
		Re: How to revert the work done by accept_sql_profile procedure By: John Watson on Mon, 14 July 2014 13:57
		Re: How to revert the work done by accept_sql_profile procedure By: Michel Cadot on Mon, 14 July 2014 14:33
		Re: How to revert the work done by accept_sql_profile procedure By: orausern on Mon, 14 July 2014 14:48
		Re: How to revert the work done by accept_sql_profile procedure By: BlackSwan on Mon, 14 July 2014 14:49
		Re: How to revert the work done by accept_sql_profile procedure By: Lalit Kumar B on Mon, 14 July 2014 15:01
		Re: How to revert the work done by accept_sql_profile procedure By: Michel Cadot on Tue, 15 July 2014 00:15
		Re: How to revert the work done by accept_sql_profile procedure By: John Watson on Tue, 15 July 2014 02:33
		Re: How to revert the work done by accept_sql_profile procedure By: orausern on Tue, 15 July 2014 14:42
		Re: How to revert the work done by accept_sql_profile procedure By: Lalit Kumar B on Mon, 14 July 2014 13:59
		Issues to watch out with SPM By: orausern on Wed, 16 July 2014 10:02
		Re: Issues to watch out with SPM By: Lalit Kumar B on Wed, 16 July 2014 10:11
		Re: Issues to watch out with SPM By: orausern on Wed, 16 July 2014 10:48
		Re: Issues to watch out with SPM By: Lalit Kumar B on Wed, 16 July 2014 11:08
		Re: Issues to watch out with SPM By: orausern on Wed, 16 July 2014 11:16

		Oracle 11g on VMWARE By: josephmaan on Wed, 16 July 2014 05:30
		Re: Oracle 11g on VMWARE By: John Watson on Wed, 16 July 2014 06:54
		Re: Oracle 11g on VMWARE By: josephmaan on Wed, 16 July 2014 07:03
		Re: Oracle 11g on VMWARE By: Michel Cadot on Wed, 16 July 2014 07:18

		Query Performance By: rohan10k on Tue, 17 June 2014 04:37
		Re: Query Performance By: Lalit Kumar B on Tue, 17 June 2014 04:54
		Re: Query Performance By: Roachcoach on Tue, 17 June 2014 05:01
		Re: Query Performance By: Kevin Meade on Sat, 12 July 2014 02:09

		How about performance using index on the column which is using in WHERE and... By: ramya_162 on Wed, 18 June 2014 04:38
		Re: How about performance using index on the column which is using in WHERE... By: cookiemonster on Wed, 18 June 2014 05:06
		Re: How about performance using index on the column which is using in WHERE... By: Lalit Kumar B on Wed, 18 June 2014 06:51
		Re: How about performance using index on the column which is using in WHERE... By: Kevin Meade on Sat, 12 July 2014 02:03

		AWR and ASH report analyze By: Database admin on Mon, 07 July 2014 08:44
		Re: AWR and ASH report analyze By: Michel Cadot on Mon, 07 July 2014 08:51
		Re: AWR and ASH report analyze By: Lalit Kumar B on Mon, 07 July 2014 08:51
		Re: AWR and ASH report analyze By: BlackSwan on Mon, 07 July 2014 08:54
		Re: AWR and ASH report analyze By: Roachcoach on Mon, 07 July 2014 08:56
		Re: AWR and ASH report analyze By: Database admin on Mon, 07 July 2014 09:38
		Re: AWR and ASH report analyze By: BlackSwan on Mon, 07 July 2014 09:42
		Re: AWR and ASH report analyze By: Database admin on Mon, 07 July 2014 09:47
		Re: AWR and ASH report analyze By: BlackSwan on Mon, 07 July 2014 09:51
		Re: AWR and ASH report analyze By: Database admin on Mon, 07 July 2014 09:55
		Re: AWR and ASH report analyze By: Roachcoach on Mon, 07 July 2014 10:00
		Re: AWR and ASH report analyze By: Database admin on Mon, 07 July 2014 10:21
		Re: AWR and ASH report analyze By: Roachcoach on Mon, 07 July 2014 10:24
		Re: AWR and ASH report analyze By: Lalit Kumar B on Mon, 07 July 2014 10:46

		Shameless plug By: rleishman on Sat, 05 July 2014 00:38
		Re: Shameless plug By: John Watson on Sat, 05 July 2014 05:25
		Re: Shameless plug By: rleishman on Sat, 05 July 2014 05:40
		Re: Shameless plug By: rleishman on Sat, 05 July 2014 17:46
		Re: Shameless plug By: John Watson on Sun, 06 July 2014 06:07
		Re: Shameless plug By: rleishman on Sun, 06 July 2014 07:48

		I/O calibration By: John Watson on Wed, 02 July 2014 12:23
		Re: I/O calibration By: John Watson on Thu, 03 July 2014 09:53
		Re: I/O calibration By: Michel Cadot on Thu, 03 July 2014 10:31
		Re: I/O calibration By: John Watson on Fri, 04 July 2014 01:38
		Re: I/O calibration By: Michel Cadot on Fri, 04 July 2014 01:46
		Re: I/O calibration By: Roachcoach on Fri, 04 July 2014 03:19
		Re: I/O calibration By: John Watson on Fri, 04 July 2014 04:57
		Re: I/O calibration By: Roachcoach on Fri, 04 July 2014 05:14
		Re: I/O calibration By: John Watson on Fri, 04 July 2014 05:51
		Re: I/O calibration By: Roachcoach on Fri, 04 July 2014 06:34

		Table Shrink Space and Performance By: preet_kumar on Mon, 16 June 2014 08:37
		Re: Table Shrink Space and Performance By: BlackSwan on Mon, 16 June 2014 08:44
		Re: Table Shrink Space and Performance By: pvsarat on Mon, 16 June 2014 08:55
		Re: Table Shrink Space and Performance By: preet_kumar on Mon, 16 June 2014 08:56
		Re: Table Shrink Space and Performance By: Michel Cadot on Mon, 16 June 2014 08:59
		Re: Table Shrink Space and Performance By: BlackSwan on Mon, 16 June 2014 09:01
		Re: Table Shrink Space and Performance By: preet_kumar on Mon, 16 June 2014 09:16
		Re: Table Shrink Space and Performance By: BlackSwan on Mon, 16 June 2014 09:21
		Re: Table Shrink Space and Performance By: Michel Cadot on Mon, 16 June 2014 10:12
		Re: Table Shrink Space and Performance By: preet_kumar on Mon, 16 June 2014 10:34
		Re: Table Shrink Space and Performance By: BlackSwan on Mon, 16 June 2014 10:56
		Re: Table Shrink Space and Performance By: martens_b2014 on Tue, 01 July 2014 08:10

		UNDO Setup Issue By: VIP2013 on Sat, 21 June 2014 05:28
		Re: UNDO Setup Issue By: BlackSwan on Sat, 21 June 2014 08:00
		Re: UNDO Setup Issue By: VIP2013 on Sun, 22 June 2014 08:02
		Re: UNDO Setup Issue By: BlackSwan on Sun, 22 June 2014 08:54
		Re: UNDO Setup Issue By: VIP2013 on Sun, 22 June 2014 13:46
		Re: UNDO Setup Issue By: BlackSwan on Sun, 22 June 2014 15:03
		Re: UNDO Setup Issue By: John Watson on Mon, 23 June 2014 00:55
		Re: UNDO Setup Issue By: VIP2013 on Mon, 23 June 2014 10:03
		Re: UNDO Setup Issue By: BlackSwan on Mon, 23 June 2014 10:17
		Re: UNDO Setup Issue By: Flyby on Sun, 29 June 2014 04:32

		Debug Procedure By: Xandot on Thu, 26 June 2014 05:55
		Re: Debug Procedure By: ThomasG on Thu, 26 June 2014 06:01
		Re: Debug Procedure By: Lalit Kumar B on Thu, 26 June 2014 06:05
		Re: Debug Procedure By: Xandot on Thu, 26 June 2014 06:40
		Re: Debug Procedure By: Lalit Kumar B on Thu, 26 June 2014 06:42
		Re: Debug Procedure By: Xandot on Thu, 26 June 2014 09:10
		Re: Debug Procedure By: Xandot on Thu, 26 June 2014 06:39
		Re: Debug Procedure By: Lalit Kumar B on Thu, 26 June 2014 06:41

		Materialized View- Delay refresh By: preethi_s0 on Tue, 24 June 2014 05:14
		Re: Materialized View- Delay refresh By: Lalit Kumar B on Tue, 24 June 2014 05:17
		Re: Materialized View- Delay refresh By: preethi_s0 on Tue, 24 June 2014 05:25
		Re: Materialized View- Delay refresh By: John Watson on Tue, 24 June 2014 05:27
		Re: Materialized View- Delay refresh By: preethi_s0 on Tue, 24 June 2014 05:35
		Re: Materialized View- Delay refresh By: John Watson on Tue, 24 June 2014 05:41
		Re: Materialized View- Delay refresh By: pvsarat on Tue, 24 June 2014 07:29
		Re: Materialized View- Delay refresh By: Michel Cadot on Tue, 24 June 2014 07:44

		Calculating schema statistics during a huge 10 hour batch job By: orausern on Thu, 19 June 2014 06:11
		Re: Calculating schema statistics during a huge 10 hour batch job By: BlackSwan on Thu, 19 June 2014 08:44
		Re: Calculating schema statistics during a huge 10 hour batch job By: orausern on Thu, 19 June 2014 13:27
		Re: Calculating schema statistics during a huge 10 hour batch job By: BlackSwan on Thu, 19 June 2014 13:45
		Re: Calculating schema statistics during a huge 10 hour batch job By: orausern on Thu, 19 June 2014 13:49
		Re: Calculating schema statistics during a huge 10 hour batch job By: BlackSwan on Thu, 19 June 2014 14:04
		Re: Calculating schema statistics during a huge 10 hour batch job By: Littlefoot on Fri, 20 June 2014 01:03
		Re: Calculating schema statistics during a huge 10 hour batch job By: Michel Cadot on Fri, 20 June 2014 01:13

		DBA_HIST_SEG_STAT view By: rishwinger on Mon, 06 January 2014 03:22
		Re: DBA_HIST_SEG_STAT view By: John Watson on Mon, 06 January 2014 03:41
		Re: DBA_HIST_SEG_STAT view By: Michel Cadot on Mon, 06 January 2014 04:01
		Re: DBA_HIST_SEG_STAT view By: rishwinger on Mon, 06 January 2014 04:22
		Re: DBA_HIST_SEG_STAT view By: Michel Cadot on Mon, 06 January 2014 04:30
		Re: DBA_HIST_SEG_STAT view By: Michel Cadot on Tue, 07 January 2014 03:18
		Re: DBA_HIST_SEG_STAT view By: rmadabhushanam on Thu, 19 June 2014 20:49
		Re: DBA_HIST_SEG_STAT view By: Michel Cadot on Fri, 20 June 2014 00:50

		SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Thu, 12 June 2014 02:13
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: John Watson on Thu, 12 June 2014 02:18
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Thu, 12 June 2014 02:47
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: John Watson on Thu, 12 June 2014 03:11
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Thu, 12 June 2014 04:15
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: John Watson on Thu, 12 June 2014 04:19
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Thu, 12 June 2014 04:55
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: John Watson on Thu, 12 June 2014 05:29
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Fri, 13 June 2014 06:16
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: BlackSwan on Fri, 13 June 2014 08:41
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Fri, 13 June 2014 10:26
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: Michel Cadot on Fri, 13 June 2014 10:38
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Fri, 13 June 2014 11:43
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: Michel Cadot on Fri, 13 June 2014 11:48
		<more>
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: Michel Cadot on Thu, 12 June 2014 02:43
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: msinha8 on Thu, 12 June 2014 02:49
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: Lalit Kumar B on Fri, 13 June 2014 15:48
		Re: SQL performance tunning :- DBMS_STATS procedure errored out By: Michel Cadot on Sat, 14 June 2014 00:37

		General question on dbms_stats By: kiranrathodkr916 on Sat, 14 June 2014 08:00
		Re: General question on dbms_stats By: Michel Cadot on Sat, 14 June 2014 09:45
		Re: General question on dbms_stats By: Lalit Kumar B on Sat, 14 June 2014 10:43

		how to troubleshoot slow running queries? By: kiranrathodkr916 on Thu, 12 June 2014 04:25
		Re: how to troubleshoot slow running queries? By: John Watson on Thu, 12 June 2014 04:30
		Re: how to troubleshoot slow running queries? By: kiranrathodkr916 on Thu, 12 June 2014 05:58
		Re: how to troubleshoot slow running queries? By: John Watson on Thu, 12 June 2014 06:05
		Re: how to troubleshoot slow running queries? By: kiranrathodkr916 on Thu, 12 June 2014 07:36
		Re: how to troubleshoot slow running queries? By: BlackSwan on Thu, 12 June 2014 08:02
		Re: how to troubleshoot slow running queries? By: kiranrathodkr916 on Thu, 12 June 2014 09:37
		Re: how to troubleshoot slow running queries? By: cookiemonster on Thu, 12 June 2014 09:55
		Re: how to troubleshoot slow running queries? By: kiranrathodkr916 on Fri, 13 June 2014 02:18
		Re: how to troubleshoot slow running queries? By: kiranrathodkr916 on Fri, 13 June 2014 11:45
		Re: how to troubleshoot slow running queries? By: BlackSwan on Fri, 13 June 2014 11:56
		Re: how to troubleshoot slow running queries? By: John Watson on Sat, 14 June 2014 02:04

		Indexing and Tuning By: m.abdulhaq on Thu, 29 May 2014 20:47
		Re: Indexing and Tuning By: BlackSwan on Thu, 29 May 2014 21:03
		Re: Indexing and Tuning By: John Watson on Fri, 30 May 2014 01:36
		Re: Indexing and Tuning By: michael_bialik on Tue, 03 June 2014 00:23
		Re: Indexing and Tuning By: Lalit Kumar B on Tue, 03 June 2014 01:13
		Re: Indexing and Tuning By: Kevin Meade on Tue, 10 June 2014 20:33

		Table with 40 million records problem By: viba1987 on Fri, 30 May 2014 05:35
		Re: Table with 40 million records problem By: Lalit Kumar B on Fri, 30 May 2014 06:02
		Re: Table with 40 million records problem By: viba1987 on Fri, 30 May 2014 06:03
		Re: Table with 40 million records problem By: Lalit Kumar B on Fri, 30 May 2014 06:04
		Re: Table with 40 million records problem By: Kevin Meade on Tue, 10 June 2014 20:21

		Staging table without indexes, slow queries By: rkhatiwala on Wed, 04 June 2014 11:10
		Re: Staging table without indexes, slow queries By: BlackSwan on Wed, 04 June 2014 11:31
		Re: Staging table without indexes, slow queries By: Lalit Kumar B on Wed, 04 June 2014 12:21
		Re: Staging table without indexes, slow queries By: rkhatiwala on Thu, 05 June 2014 14:39
		Re: Staging table without indexes, slow queries By: BlackSwan on Thu, 05 June 2014 15:05

		SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:16
		SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:16
		Re: SQL performance tunning By: BlackSwan on Thu, 29 May 2014 09:23
		Re: SQL performance tunning By: John Watson on Thu, 29 May 2014 09:25
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:30
		Re: SQL performance tunning By: Lalit Kumar B on Thu, 29 May 2014 09:20
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:26
		Re: SQL performance tunning By: Lalit Kumar B on Thu, 29 May 2014 09:29
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:33
		Re: SQL performance tunning By: BlackSwan on Thu, 29 May 2014 09:47
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 09:56
		Re: SQL performance tunning By: BlackSwan on Thu, 29 May 2014 09:59
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 10:02
		Re: SQL performance tunning By: John Watson on Thu, 29 May 2014 10:12
		Re: SQL performance tunning By: msinha8 on Thu, 29 May 2014 11:09
		Re: SQL performance tunning By: John Watson on Thu, 29 May 2014 11:25
		Re: SQL performance tunning By: Lalit Kumar B on Thu, 29 May 2014 11:36
		Re: SQL performance tunning By: rleishman on Thu, 29 May 2014 20:20
		Re: SQL performance tunning By: John Watson on Fri, 30 May 2014 01:31
		Re: SQL performance tunning By: rleishman on Fri, 30 May 2014 02:23
		Re: SQL performance tunning By: John Watson on Fri, 30 May 2014 02:57
		<more>

		SQL id shows multiple plan table By: ashishkumarmahanta80 on Tue, 27 May 2014 00:25
		Re: SQL id shows multiple plan table By: Michel Cadot on Tue, 27 May 2014 01:15
		Re: SQL id shows multiple plan table By: ashishkumarmahanta80 on Tue, 27 May 2014 01:37
		Re: SQL id shows multiple plan table By: Michel Cadot on Tue, 27 May 2014 01:55
		Re: SQL id shows multiple plan table By: Lalit Kumar B on Tue, 27 May 2014 02:24
		Re: SQL id shows multiple plan table By: Roachcoach on Tue, 27 May 2014 02:47

		monitoring By: guru_karnam on Thu, 22 May 2014 08:22
		Re: monitoring By: BlackSwan on Thu, 22 May 2014 09:02
		Re: monitoring By: Kevin Meade on Fri, 23 May 2014 20:28
		Re: monitoring By: Michel Cadot on Fri, 23 May 2014 23:56

		Direct Path Wait event By: guru_karnam on Thu, 22 May 2014 13:28
		Re: Drect Path Wait event By: BlackSwan on Thu, 22 May 2014 13:38
		Re: Drect Path Wait event By: John Watson on Thu, 22 May 2014 13:52
		Re: Drect Path Wait event By: guru_karnam on Thu, 22 May 2014 16:13
		Re: Drect Path Wait event By: BlackSwan on Thu, 22 May 2014 17:16
		Re: Drect Path Wait event By: Roachcoach on Fri, 23 May 2014 02:37
		Re: Drect Path Wait event By: Kevin Meade on Fri, 23 May 2014 20:27

		what are the disadvan of using incremental stats in oracle 11g? By: ashwanth77 on Fri, 09 May 2014 07:02
		Re: what are the disadvan of using incremental stats in oracle 11g? By: Lalit Kumar B on Fri, 09 May 2014 07:34
		Re: what are the disadvan of using incremental stats in oracle 11g? By: ashwanth77 on Fri, 09 May 2014 08:04
		Re: what are the disadvan of using incremental stats in oracle 11g? By: Lalit Kumar B on Fri, 09 May 2014 13:10
		Re: what are the disadvan of using incremental stats in oracle 11g? By: pointers on Wed, 21 May 2014 03:40
		Re: what are the disadvan of using incremental stats in oracle 11g? By: ashwanth77 on Thu, 22 May 2014 05:26

		dba_hist_snapshot vs dba_hist_active_sess_history By: ind9 on Tue, 20 May 2014 02:31
		Re: dba_hist_snapshot vs dba_hist_active_sess_history By: BlackSwan on Tue, 20 May 2014 07:30

		% cpu used by a session By: Malakay79 on Sat, 17 May 2014 09:59
		Re: % cpu used by a session By: John Watson on Sat, 17 May 2014 10:11
		Re: % cpu used by a session By: Michel Cadot on Sat, 17 May 2014 11:00

		Procedure runs slow whereas By: guru_karnam on Wed, 14 May 2014 10:21
		Re: Procedure runs slow whereas By: Roachcoach on Wed, 14 May 2014 10:24
		Re: Procedure runs slow whereas By: Lalit Kumar B on Wed, 14 May 2014 10:28
		Re: Procedure runs slow whereas By: BlackSwan on Wed, 14 May 2014 11:02
		Re: Procedure runs slow whereas By: guru_karnam on Wed, 14 May 2014 14:33
		Re: Procedure runs slow whereas By: BlackSwan on Wed, 14 May 2014 18:38
		Re: Procedure runs slow whereas By: guru_karnam on Thu, 15 May 2014 09:36
		Re: Procedure runs slow whereas By: guru_karnam on Thu, 15 May 2014 09:43

		LOV taking long time By: mist598 on Wed, 14 May 2014 01:19
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 01:32
		Re: LOV taking long time By: Littlefoot on Wed, 14 May 2014 01:36
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 01:38
		Re: LOV taking long time By: Littlefoot on Wed, 14 May 2014 01:52
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 01:56
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 02:04
		Re: LOV taking long time By: Littlefoot on Wed, 14 May 2014 02:07
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 02:16
		Re: LOV taking long time By: Littlefoot on Wed, 14 May 2014 02:20
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 02:27
		Re: LOV taking long time By: Littlefoot on Wed, 14 May 2014 02:39
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 02:52
		Re: LOV taking long time By: cookiemonster on Wed, 14 May 2014 02:56
		Re: LOV taking long time By: cookiemonster on Wed, 14 May 2014 02:59
		<more>
		Re: LOV taking long time By: Lalit Kumar B on Wed, 14 May 2014 09:16
		Re: LOV taking long time By: mist598 on Wed, 14 May 2014 09:32
		Re: LOV taking long time By: Lalit Kumar B on Wed, 14 May 2014 10:04
		Re: LOV taking long time By: BlackSwan on Wed, 14 May 2014 10:05
		Re: LOV taking long time By: Lalit Kumar B on Wed, 14 May 2014 10:15
		Re: LOV taking long time By: BlackSwan on Wed, 14 May 2014 10:18
		Re: LOV taking long time By: mist598 on Thu, 15 May 2014 00:15

		database performance issue By: guddu_12 on Tue, 13 May 2014 13:59
		Re: database performance issue By: BlackSwan on Tue, 13 May 2014 14:07
		Re: database performance issue By: guddu_12 on Tue, 13 May 2014 15:13
		Re: database performance issue By: BlackSwan on Tue, 13 May 2014 21:40

		Please help me execution plan is looking bad By: ramya_162 on Mon, 12 May 2014 08:18
		Re: Please help me execution plan is looking bad By: Roachcoach on Mon, 12 May 2014 08:57
		Re: Please help me execution plan is looking bad By: Lalit Kumar B on Mon, 12 May 2014 10:50
		Re: Please help me execution plan is looking bad By: Solomon Yakobson on Mon, 12 May 2014 11:26
		Re: Please help me execution plan is looking bad By: Solomon Yakobson on Mon, 12 May 2014 11:35
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 01:47
		Re: Please help me execution plan is looking bad By: Lalit Kumar B on Tue, 13 May 2014 03:14
		Re: Please help me execution plan is looking bad By: John Watson on Tue, 13 May 2014 02:12
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 04:20
		Re: Please help me execution plan is looking bad By: Lalit Kumar B on Tue, 13 May 2014 04:45
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 05:26
		Re: Please help me execution plan is looking bad By: John Watson on Tue, 13 May 2014 06:09
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 06:45
		Re: Please help me execution plan is looking bad By: Roachcoach on Tue, 13 May 2014 06:47
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 06:50
		Re: Please help me execution plan is looking bad By: Roachcoach on Tue, 13 May 2014 06:57
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 07:07
		Re: Please help me execution plan is looking bad By: Roachcoach on Tue, 13 May 2014 07:21
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 08:00
		Re: Please help me execution plan is looking bad By: John Watson on Tue, 13 May 2014 08:14
		Re: Please help me execution plan is looking bad By: ramya_162 on Tue, 13 May 2014 08:35
		Re: Please help me execution plan is looking bad By: John Watson on Tue, 13 May 2014 08:42
		<more>

		SQL Query too slow By: aldy on Thu, 08 May 2014 08:17
		Re: SQL Query too slow By: Lalit Kumar B on Thu, 08 May 2014 08:22
		Re: SQL Query too slow By: rleishman on Thu, 08 May 2014 08:28
		Re: SQL Query too slow By: BlackSwan on Thu, 08 May 2014 08:37
		Re: SQL Query too slow By: aldy on Thu, 08 May 2014 08:46
		Re: SQL Query too slow By: BlackSwan on Thu, 08 May 2014 08:53
		Re: SQL Query too slow By: Lalit Kumar B on Thu, 08 May 2014 08:57
		Re: SQL Query too slow By: aldy on Thu, 08 May 2014 09:07
		Re: SQL Query too slow By: BlackSwan on Thu, 08 May 2014 09:11
		Re: SQL Query too slow By: aldy on Thu, 08 May 2014 09:34
		Re: SQL Query too slow By: BlackSwan on Thu, 08 May 2014 10:15
		Re: SQL Query too slow By: Lalit Kumar B on Thu, 08 May 2014 10:38
		Re: SQL Query too slow By: rleishman on Thu, 08 May 2014 16:51
		Re: SQL Query too slow By: Roachcoach on Fri, 09 May 2014 02:02
		Re: SQL Query too slow By: aldy on Fri, 09 May 2014 02:30
		Re: SQL Query too slow By: rleishman on Fri, 09 May 2014 02:45
		Re: SQL Query too slow By: Roachcoach on Fri, 09 May 2014 02:53
		Re: SQL Query too slow By: aldy on Fri, 09 May 2014 06:29
		Re: SQL Query too slow By: Kevin Meade on Fri, 09 May 2014 16:42
		Re: SQL Query too slow By: Lalit Kumar B on Sat, 10 May 2014 10:18
		Re: SQL Query too slow By: Kevin Meade on Sat, 10 May 2014 10:21

		High CPU Consuming Query By: nmoham on Wed, 07 May 2014 09:40
		Re: High CPU Consuming Query By: BlackSwan on Wed, 07 May 2014 09:42
		Re: High CPU Consuming Query By: nmoham on Wed, 07 May 2014 10:39
		Re: High CPU Consuming Query By: BlackSwan on Wed, 07 May 2014 10:41
		Re: High CPU Consuming Query By: nmoham on Wed, 07 May 2014 10:48
		Re: High CPU Consuming Query By: Michel Cadot on Wed, 07 May 2014 10:53
		Re: High CPU Consuming Query By: nmoham on Wed, 07 May 2014 13:09
		Re: High CPU Consuming Query By: Michel Cadot on Wed, 07 May 2014 13:33
		Re: High CPU Consuming Query By: Roachcoach on Thu, 08 May 2014 05:05
		Re: High CPU Consuming Query By: nmoham on Thu, 08 May 2014 07:47
		Re: High CPU Consuming Query By: Michel Cadot on Thu, 08 May 2014 09:09
		Re: High CPU Consuming Query By: Roachcoach on Fri, 09 May 2014 02:06
		Re: High CPU Consuming Query By: John Watson on Fri, 09 May 2014 02:19

		slow sql By: fenor on Tue, 06 May 2014 06:17
		Re: slow sql By: Lalit Kumar B on Tue, 06 May 2014 06:59
		Re: slow sql By: fenor on Tue, 06 May 2014 10:32
		Re: slow sql By: John Watson on Tue, 06 May 2014 08:04
		Re: slow sql By: fenor on Tue, 06 May 2014 10:40
		Re: slow sql By: fenor on Wed, 07 May 2014 10:18
		Re: slow sql By: BlackSwan on Wed, 07 May 2014 10:38

Pages (119): [ « ‹ 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Fri Apr 19 20:00:32 CDT 2024