Blog
Search
Help
Members
Register
Login
Home
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
.
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
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
›
»
]
Goto Forum:
- SQL & PL/SQL
SQL & PL/SQL
- RDBMS Server
Server Administration
Backup & Recovery
Performance Tuning
Security
Networking and Gateways
Enterprise Manager
Server Utilities
- Server Options
RAC & Failsafe
Data Guard
Replication
Streams & AQ
Spatial
Text & interMedia
Multitenant
- Developer & Programmer
Application Express, ORDS & MOD_PLSQL
Forms
Reports & Discoverer
Designer
JDeveloper, Java & XML
Data Integration
Precompilers, OCI & OCCI
- Fusion Middleware & Colab Suite
Weblogic & Application Server
Business Intelligence
WebCenter Suite & Portal
Collaboration & Content Management
SOA Suite, BPEL and OWSM
- Applications
Oracle Fusion Apps & E-Business Suite
PeopleSoft, JD Edwards & Siebel
Primavera
Other Application Suites
- Infrastructure
Cloud and Hosting
Hardware
Linux
Unix
Windows
Other Operating Systems
- Open Source
Programming Interfaces
MySQL
NoSQL
- Other
General
Training & Certification
Client Tools
Marketplace
Community Hangout
News & Blogs
Suggestions & Feedback
Test
- Non-English Forums
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish
[
Syndicate this forum (XML)
] [
]
Legend
New Messages
No New messages
Locked (w/ unread messages)
Locked
Moved to another forum
Current Time:
Fri Mar 29 10:22:32 CDT 2024