Querying V$sql_monitor Slow
(Doc ID 2731020.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- 12.2.0.1 database, querying v$sql_monitor slow
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 14.07 14.33 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 14.07 14.33 0 0 0 1Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Number of plan statistics captured: 1Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=14332069 us starts=1)
18005 18005 18005 FIXED TABLE FULL X$KESWXMON (cr=0 pr=0 pw=0 time=14328521 us starts=1 cost=0 size=0 card=3) - Shortstack shows that most of CPU spent on function call:
kghscSeek
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |