Querying V$sql_monitor Slow (Doc ID 2731020.1)

Last updated on JULY 20, 2024

Applies to:

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 1

  Misses in library cache during parse: 1
  Optimizer mode: ALL_ROWS
  Parsing user id: SYS
  Number of plan statistics captured: 1

  Rows (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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.