This content has been marked as final. Show 2 replies
989013 wrote:"V$METRIC displays the most recent statistic values for the complete set of metrics captured by the AWR infrastructure."
I know I have seen and used this before, but for the life of me I cannot work out how to get this view into my client's 9i installation.
As I say, I have seen it before in 9i so hopefully someone out there can tell me what I need to do; the 10g and forward manuals are full of information - sadly the 9i ones are not so. I therefore presume it was unsupported (but obviously worked).
Many thanks to anyone with any advice.
given that AWR did not exist in V9, I suspect that you are mistaken.
It may have been an undocumented feature in later versions of 9i (220.127.116.11).
Oracle is notorious for doing that. AWR may have been in there, but they wouldn't not tell anyone.