Database Tuning (MOSC)

MOSC Banner

query to find all sql statements taking more than a certain amount of time

edited May 18, 2023 2:33PM in Database Tuning (MOSC) 2 commentsAnswered ✓

Oracle Database 19c Enterprise Edition Version 19.18.0.0.0

Hi,

Please I would like the following Information as output from the query

SID,

SERIAL#,

USERNAME,

STARTTIME,

SQLSTATEMENT the client is executing

for all queries that are taking more than a certain amount of time, say around 4 hours of execution time.

For queries taking more then 4hours, I want the SqlStatement and other details like who is executing this statement, and what time the query started.

Thanks in advance for your help.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center