Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.
icon6.gif Performances and tuning (sticky)
By: Michel Cadot on Fri, 22 June 2007 11:19
  How to Identify Performance Problem and Bottleneck
By: Frank Naude on Mon, 25 June 2007 01:18
  Performance Monitoring
By: Michel Cadot on Fri, 28 September 2007 14:11
  SQL statement tuning
By: BlackSwan on Fri, 04 December 2009 19:18
  Re: SQL statement tuning
By: BlackSwan on Mon, 09 May 2011 08:44
  Re: SQL statement tuning
By: LNossov on Tue, 05 July 2011 07:40
  Re: SQL statement tuning
By: Michel Cadot on Thu, 22 August 2013 04:09
  Re: SQL statement tuning
By: Kevin Meade on Sat, 07 March 2015 12:25
  Re: SQL statement tuning
By: dragam on Wed, 11 August 2021 03:35
  Re: Performances and tuning
By: dragam on Wed, 11 August 2021 03:54
  Re: Performances and tuning
By: Michel Cadot on Wed, 11 August 2021 08:31
  query output speed very slow
By: hissam78 on Sun, 31 December 2023 02:14
  Re: query output speed very slow
By: Michel Cadot on Sun, 31 December 2023 02:46
  SQL Profiles after upgrade from 11g to 19c
By: wtolentino on Tue, 07 November 2023 09:05
  Re: SQL Profiles after upgrade from 11g to 19c
By: John Watson on Tue, 07 November 2023 09:35
  Re: SQL Profiles after upgrade from 11g to 19c
By: wtolentino on Tue, 07 November 2023 10:30
  Regarding dba_scheduler_windows
By: shipon_97 on Thu, 21 September 2023 04:17
  Re: Regarding dba_scheduler_windows
By: John Watson on Thu, 21 September 2023 05:58
  How to reduce query Cost
By: chat2raj.s on Tue, 08 August 2023 00:03
  Re: How to reduce query Cost
By: Barbara Boehmer on Tue, 08 August 2023 00:27
  Re: How to reduce query Cost
By: John Watson on Tue, 08 August 2023 01:12
  Re: How to reduce query Cost
By: chat2raj.s on Tue, 08 August 2023 07:28
  Re: How to reduce query Cost
By: chat2raj.s on Tue, 08 August 2023 07:44
  Re: How to reduce query Cost
By: John Watson on Tue, 08 August 2023 07:45
  Bind by position
By: Andrey_R on Sun, 14 May 2023 14:37
  Re: Bind by position
By: Michel Cadot on Sun, 14 May 2023 14:53
  Re: Bind by position
By: Barbara Boehmer on Sun, 14 May 2023 15:10
  Re: Bind by position
By: Andrey_R on Fri, 02 June 2023 15:02
  Re: Bind by position
By: Barbara Boehmer on Sat, 03 June 2023 03:30
  Re: Bind by position
By: Andrey_R on Fri, 28 July 2023 06:14
  Cannot force indexing on alert log query
By: Andrey_R on Sun, 28 May 2023 05:13
  Re: Cannot force indexing on alert log query
By: Michel Cadot on Sun, 28 May 2023 06:24
  Re: Cannot force indexing on alert log query
By: Andrey_R on Sun, 28 May 2023 07:03
  Re: Cannot force indexing on alert log query
By: Andrey_R on Wed, 07 June 2023 08:42
  Re: Cannot force indexing on alert log query
By: Michel Cadot on Wed, 07 June 2023 10:22
  rdbms 12.2C performance issues sometimes
By: evoradba on Fri, 05 May 2023 10:49
  Re: rdbms 12.2C performance issues sometimes
By: John Watson on Fri, 05 May 2023 12:16
  Re: rdbms 12.2C performance issues sometimes
By: evoradba on Fri, 05 May 2023 12:20
  Re: rdbms 12.2C performance issues sometimes
By: John Watson on Fri, 05 May 2023 12:26
  Re: rdbms 12.2C performance issues sometimes
By: evoradba on Thu, 11 May 2023 08:58
  Sql having performance issue
By: nishant87 on Sun, 27 November 2022 02:53
  Re: Sql having performance issue
By: nishant87 on Sun, 27 November 2022 02:58
  Re: Sql having performance issue
By: John Watson on Sun, 27 November 2022 03:27
  Re: Sql having performance issue
By: nishant87 on Sun, 27 November 2022 03:56
  Re: Sql having performance issue
By: nishant87 on Sun, 27 November 2022 03:57
  Re: Sql having performance issue
By: nishant87 on Sun, 27 November 2022 03:58
  Re: Sql having performance issue
By: John Watson on Mon, 28 November 2022 12:28
  Why *is* my index used?
By: Andrey_R on Sun, 23 October 2022 06:29
  Re: Why *is* my index used?
By: John Watson on Mon, 24 October 2022 07:16
  Re: Why *is* my index used?
By: Andrey_R on Tue, 25 October 2022 03:44
  Re: Why *is* my index used?
By: Andrey_R on Sat, 29 October 2022 08:37
  Re: Why *is* my index used?
By: John Watson on Sat, 29 October 2022 10:51
  Understanding UNDO 11g
By: esirenko on Thu, 27 October 2022 03:32
  Re: Understanding UNDO 11g
By: John Watson on Thu, 27 October 2022 05:48
  gather statistics on partition table
By: wtolentino on Wed, 19 October 2022 14:46
  Re: gather statistics on partition table
By: John Watson on Fri, 21 October 2022 02:07
  Re: gather statistics on partition table
By: wtolentino on Fri, 21 October 2022 04:49
  Sql behaving badly after upgrade (merged)
By: nishant1987 on Tue, 18 October 2022 10:48
  Re: Sql is causing performance issue
By: nishant1987 on Tue, 18 October 2022 10:51
  Re: Sql is causing performance issue
By: nishant1987 on Tue, 18 October 2022 10:55
  Sql behaving badly after upgrade
By: nishant1987 on Tue, 18 October 2022 10:54
  Re: Sql behaving badly after upgrade
By: nishant1987 on Tue, 18 October 2022 11:05
  Re: Sql behaving badly after upgrade
By: nishant1987 on Tue, 18 October 2022 11:07
  any option for this query
By: rnemkul on Thu, 28 July 2022 22:55
  Re: any option for this query
By: Michel Cadot on Fri, 29 July 2022 00:25
  Time metrics in V$SQL don't add up
By: Andrey_R on Wed, 20 July 2022 18:35
  Re: Time metrics in V$SQL don't add up
By: John Watson on Thu, 21 July 2022 01:54
  Re: Time metrics in V$SQL don't add up
By: Andrey_R on Thu, 21 July 2022 10:14
  Re: Time metrics in V$SQL don't add up
By: Andrey_R on Thu, 21 July 2022 10:52
  Re: Time metrics in V$SQL don't add up
By: John Watson on Fri, 22 July 2022 01:15
  Re: Time metrics in V$SQL don't add up
By: Andrey_R on Fri, 22 July 2022 16:35
  Re: Time metrics in V$SQL don't add up
By: John Watson on Sat, 23 July 2022 07:39
  Re: Time metrics in V$SQL don't add up
By: Andrey_R on Sat, 23 July 2022 07:52
  Percentage of CPU utilization per instance
By: db_senior on Thu, 05 August 2021 08:38
  Re: Percentage of CPU utilization per instance
By: John Watson on Thu, 05 August 2021 12:25
  Re: Percentage of CPU utilization per instance
By: db_senior on Thu, 05 August 2021 12:36
  Re: Percentage of CPU utilization per instance
By: John Watson on Fri, 06 August 2021 01:00
  Re: Percentage of CPU utilization per instance
By: db_senior on Fri, 06 August 2021 01:12
  Re: Percentage of CPU utilization per instance
By: Andrey_R on Sat, 23 July 2022 07:14
  query tunning
By: arun888 on Wed, 11 May 2022 06:53
  query tunning
By: arun888 on Wed, 11 May 2022 06:53
  Re: query tunning
By: John Watson on Wed, 11 May 2022 07:04
  Re: query tunning
By: arun888 on Wed, 11 May 2022 07:44
  Re: query tunning
By: arun888 on Wed, 11 May 2022 08:55
  Re: query tunning
By: John Watson on Thu, 12 May 2022 12:32
  Re: query tunning
By: arun888 on Fri, 20 May 2022 01:13
  Re: query tunning
By: John Watson on Fri, 20 May 2022 01:22
  Re: query tunning
By: arun888 on Fri, 20 May 2022 01:35
  Re: query tunning
By: John Watson on Fri, 20 May 2022 15:06
  Re: query tunning
By: arun888 on Mon, 23 May 2022 12:48
  Re: query tunning
By: John Watson on Tue, 24 May 2022 06:26
  excessive parsing ?
By: John Watson on Fri, 13 May 2022 05:17
  Re: excessive parsing ?
By: John Watson on Fri, 13 May 2022 06:16
  Re: excessive parsing ?
By: John Watson on Sun, 15 May 2022 05:33
  Re-Partitioning
By: deepakdot on Mon, 02 May 2022 04:25
  Re: Re-Partitioning
By: John Watson on Mon, 02 May 2022 11:35
  Re: Re-Partitioning
By: deepakdot on Wed, 04 May 2022 02:06
  Correlated subquery iteration
By: John Watson on Fri, 18 February 2022 10:20
  Re: Correlated subquery iteration
By: Michel Cadot on Fri, 18 February 2022 11:46
  Re: Correlated subquery iteration
By: John Watson on Sat, 19 February 2022 04:48
  Re: Correlated subquery iteration
By: Michel Cadot on Sat, 19 February 2022 05:46
  Long running queries
By: BalajiDBA on Mon, 04 October 2021 01:28
  Re: Long running queries
By: John Watson on Mon, 04 October 2021 01:41
  Re: Long running queries
By: BalajiDBA on Mon, 04 October 2021 02:16
  Re: Long running queries
By: John Watson on Mon, 04 October 2021 03:10
  Re: Long running queries
By: BalajiDBA on Mon, 04 October 2021 03:27
  Re: Long running queries
By: John Watson on Mon, 04 October 2021 04:23
  Re: Long running queries
By: BalajiDBA on Mon, 04 October 2021 06:29
  Re: Long running queries
By: John Watson on Mon, 04 October 2021 06:42
  Re: Long running queries
By: BalajiDBA on Mon, 04 October 2021 09:05
  Re: Long running queries
By: BalajiDBA on Tue, 05 October 2021 01:02
  Re: Long running queries
By: John Watson on Tue, 05 October 2021 01:25
  Re: Long running queries
By: BalajiDBA on Tue, 05 October 2021 02:15
  Re: Long running queries
By: John Watson on Tue, 05 October 2021 03:35
  Re: Long running queries
By: BalajiDBA on Tue, 05 October 2021 04:45
  <more>
  Slow Archive Apply in Physical Standby
By: Akmmhto on Tue, 07 September 2021 08:08
  Re: Slow Archive Apply in Physical Standby
By: John Watson on Tue, 07 September 2021 08:22
  Re: Slow Archive Apply in Physical Standby
By: Akmmhto on Tue, 07 September 2021 08:24
  Re: Slow Archive Apply in Physical Standby
By: John Watson on Thu, 09 September 2021 01:03
  Re: Slow Archive Apply in Physical Standby
By: Akmmhto on Thu, 09 September 2021 01:14
  Re: Slow Archive Apply in Physical Standby
By: John Watson on Thu, 09 September 2021 02:44
  The predicate prevents the optimizer from using indices efficiently
By: lisyloo12 on Fri, 23 July 2021 11:21
  Re: The predicate prevents the optimizer from using indices efficiently
By: John Watson on Fri, 23 July 2021 13:04
  SQL Access Advisor from SQL*Plus
By: db_senior on Sat, 03 July 2021 11:39
  Re: SQL Access Advisor from SQL*Plus
By: Michel Cadot on Sat, 03 July 2021 12:20
  Re: SQL Access Advisor from SQL*Plus
By: John Watson on Sat, 03 July 2021 12:26
  Re: SQL Access Advisor from SQL*Plus
By: Michel Cadot on Sat, 03 July 2021 13:18
  Re: SQL Access Advisor from SQL*Plus
By: db_senior on Sun, 04 July 2021 04:45
  Re: SQL Access Advisor from SQL*Plus
By: Michel Cadot on Sun, 04 July 2021 05:16
  Re: SQL Access Advisor from SQL*Plus
By: db_senior on Sun, 04 July 2021 16:11
  Re: SQL Access Advisor from SQL*Plus
By: John Watson on Mon, 05 July 2021 00:38
  Re: SQL Access Advisor from SQL*Plus
By: db_senior on Mon, 05 July 2021 12:35
  Function blocking itself
By: patdev on Wed, 09 June 2021 08:20
  Re: Function blocking itself
By: Michel Cadot on Wed, 09 June 2021 10:28
  Query running slow
By: JackBauer on Wed, 31 March 2021 18:02
  Re: Query running slow
By: BlackSwan on Thu, 01 April 2021 07:00
  Re: Query running slow
By: JackBauer on Thu, 01 April 2021 08:19
  Re: Query running slow
By: John Watson on Thu, 01 April 2021 09:14
  Re: Query running slow
By: BlackSwan on Thu, 01 April 2021 14:53
  Re: Query running slow
By: JackBauer on Thu, 01 April 2021 15:57
  Re: Query running slow
By: John Watson on Thu, 01 April 2021 16:02
  Re: Query running slow
By: JackBauer on Thu, 01 April 2021 16:06
  Re: Query running slow
By: John Watson on Fri, 02 April 2021 01:16
  Re: Query running slow
By: BlackSwan on Thu, 01 April 2021 20:06
  Re: Query running slow
By: JackBauer on Fri, 02 April 2021 05:09
  Re: Query running slow
By: Michel Cadot on Fri, 02 April 2021 05:30
  Re: Query running slow
By: JackBauer on Fri, 02 April 2021 14:03
  Re: Query running slow
By: JackBauer on Tue, 13 April 2021 05:17
  Cannot index temp table after inserting rows
By: Andrey_R on Wed, 03 March 2021 03:00
  Re: Cannot index temp table after inserting rows
By: John Watson on Wed, 03 March 2021 03:31
  Re: Cannot index temp table after inserting rows
By: Andrey_R on Wed, 03 March 2021 03:42
  SQL ID changes Plan hash value
By: JackBauer on Tue, 16 February 2021 07:38
  Re: SQL ID changes Plan hash value
By: JackBauer on Thu, 25 February 2021 00:49
  Re: SQL ID changes Plan hash value
By: John Watson on Thu, 25 February 2021 01:01
  Re: SQL ID changes Plan hash value
By: BlackSwan on Thu, 25 February 2021 09:22
  Re: SQL ID changes Plan hash value
By: JackBauer on Fri, 26 February 2021 05:02
  Re: SQL ID changes Plan hash value
By: BlackSwan on Fri, 26 February 2021 08:45
  I/O performance problem
By: JackBauer on Thu, 11 February 2021 15:04
  Re: I/O performance problem
By: John Watson on Fri, 12 February 2021 02:25
  Re: I/O performance problem
By: JackBauer on Fri, 12 February 2021 06:20
  Program is slower with Oracle12C compared to Oracle 11G
By: LiorI on Wed, 13 January 2021 04:06
  Re: Program is slower with Oracle12C compared to Oracle 11G
By: John Watson on Wed, 13 January 2021 06:10
  Re: Program is slower with Oracle12C compared to Oracle 11G
By: LiorI on Wed, 13 January 2021 06:30
  Re: Program is slower with Oracle12C compared to Oracle 11G
By: Andrey_R on Fri, 12 February 2021 06:15
  TKPROF showing wrong totals for non-recursive statements
By: Andrey_R on Thu, 11 February 2021 06:19
  ORA-12705: Cannot access NLS data files or invalid environment specified wi...
By: estonolose on Tue, 01 December 2020 13:02
  Re: ORA-12705: Cannot access NLS data files or invalid environment specifie...
By: BlackSwan on Tue, 01 December 2020 21:27
  SQL_Text on SQL Profile
By: wtolentino on Thu, 17 October 2019 08:40
  Re: SQL_Text on SQL Profile
By: Michel Cadot on Thu, 17 October 2019 09:01
  Re: SQL_Text on SQL Profile
By: LNossov on Sun, 22 November 2020 12:56
icon11.gif DBMS_SQLTUNE.REPORT_SQL_DETAIL: html report issue
By: piripicchio on Thu, 15 October 2020 09:08
  Application Performance Issue
By: BalajiDBA on Sat, 10 October 2020 02:49
  Re: Application Performance Issue
By: John Watson on Sat, 10 October 2020 03:08
  Re: Application Performance Issue
By: Michel Cadot on Sat, 10 October 2020 03:18
  Bitmap join index
By: John Watson on Thu, 08 October 2020 04:17
  Scalar subquery merging
By: John Watson on Tue, 29 September 2020 09:40
  Re: Scalar subquery merging
By: Michel Cadot on Tue, 29 September 2020 10:31
  Re: Scalar subquery merging
By: John Watson on Tue, 29 September 2020 13:03
  Re: Scalar subquery merging
By: Michel Cadot on Tue, 29 September 2020 13:43
  Different SQL ID for same SQL/HASH_VALUE
By: suddhasatwa_bhaumik on Fri, 02 November 2012 07:55
  Re: Different SQL ID for same SQL/HASH_VALUE
By: cookiemonster on Fri, 02 November 2012 08:00
  Re: Different SQL ID for same SQL/HASH_VALUE
By: suddhasatwa_bhaumik on Fri, 02 November 2012 08:02
  Re: Different SQL ID for same SQL/HASH_VALUE
By: cookiemonster on Fri, 02 November 2012 08:18
  Re: Different SQL ID for same SQL/HASH_VALUE
By: suddhasatwa_bhaumik on Fri, 02 November 2012 09:20
  Re: Different SQL ID for same SQL/HASH_VALUE
By: BlackSwan on Fri, 02 November 2012 09:31
  Re: Different SQL ID for same SQL/HASH_VALUE
By: LNossov on Fri, 02 November 2012 11:46
  Re: Different SQL ID for same SQL/HASH_VALUE
By: suddhasatwa_bhaumik on Sun, 04 November 2012 22:17
  Re: Different SQL ID for same SQL/HASH_VALUE
By: BlackSwan on Sun, 04 November 2012 22:28
  Re: Different SQL ID for same SQL/HASH_VALUE
By: LNossov on Mon, 05 November 2012 11:40
  Re: Different SQL ID for same SQL/HASH_VALUE
By: Roachcoach on Mon, 05 November 2012 04:02
  Re: Different SQL ID for same SQL/HASH_VALUE
By: amujawane on Mon, 28 September 2020 01:45
  Physical read IO requests higher than total
By: pallen38 on Tue, 22 September 2020 12:36
  Re: Physical read IO requests higher than total
By: Michel Cadot on Tue, 22 September 2020 13:01
  Re: Physical read IO requests higher than total
By: pallen38 on Tue, 22 September 2020 13:09
  Re: Physical read IO requests higher than total
By: Michel Cadot on Tue, 22 September 2020 14:05
  Re: Physical read IO requests higher than total
By: pallen38 on Tue, 22 September 2020 14:10
  Re: Physical read IO requests higher than total
By: Michel Cadot on Tue, 22 September 2020 14:32
  Re: Physical read IO requests higher than total
By: pallen38 on Tue, 22 September 2020 14:56
  New to tuning
By: mdarifdxb20 on Sun, 09 August 2020 05:07
  Re: New to tuning
By: Michel Cadot on Sun, 09 August 2020 05:19
Pages (119): [1  2  3  4  5  6  7  8  9  10  11  12  13  14  15    »]  Return to the default flat view Create a new topic
Goto Forum:
  
 [ Syndicate this forum (XML) ] [ RSS ]
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Fri Mar 29 10:22:32 CDT 2024