Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEM query

Roshan BisnathApr 10 2025

OEM 13c

Dear team,

kindly advise why below query returns timestamp to sysdate-1 only. I changed collection metric on OEM to collect latest data but still it is showing sysdate-1

select
key_value,ROLLUP_TIMESTAMP, round(AVERAGE/1024/1024,3) "size"
from sysman.MGMT$METRIC_DAILY
where column_label='Tablespace Used Space (MB)' and TARGET_NAME='finprod'
order by round(AVERAGE/1024/1024,3) desc

Regards,

Roshan

This post has been answered by Paulzip on Apr 10 2025
Jump to Answer
Comments
Post Details
Added on Apr 10 2025
1 comment
168 views