Scribd
Upload
85 views1 page

Oracle Database Administrators

This SQL query selects the name and value columns from the v$sysstat view for any rows where the name contains the text "table" and orders the results by name. It will display statistics related to table usage from the database.

Uploaded by

hassanshoaib
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
85 views1 page

Oracle Database Administrators

This SQL query selects the name and value columns from the v$sysstat view for any rows where the name contains the text "table" and orders the results by name. It will display statistics related to table usage from the database.

Uploaded by

hassanshoaib
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SELECT name, value

FROM v$sysstat
WHERE name LIKE '%table %'
ORDER BY name;

You might also like