SQL Performance (MOSC)

MOSC Banner

Auto-SQL monitoring is not triggered for a long running SQL ( Oracle DB 19c EE )

edited 8:34PM in SQL Performance (MOSC) 1 commentAnswered

Hi,

I'm executing a long running SELECT query. But I'm not seeing it in the Real-time SQL Monitor.

The query is really heavy. It has joins over large tables with millions of records.

The query has 20 rows and the plan is 15 rows.

The only suspicious part is that the plan expects only a few rows due to a specific optimizer statistics, whereas the actual number is large. However, I'm not looking for the optimization. I just want to see the query it in the SQL monitor.

The total duration of the query is 20 hours. It performs millions of buffer gets and 96% is I/O. Apparently, it's >5 sec of CPU or I/O used.

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