Thursday, January 18, 2018

TEMP Tablespace Users Usage

select username,sum(blocks*16384)/1048576 MB from gv$sort_usage group by username;

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

OCI Operations Insights: Stop Paying for Capacity You Don't Use: Right-Size Your Exadata with OCI Ops Insights

For many enterprises, Oracle Exadata represents one of the largest and most strategic infrastructure investments in their data center portfo...