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

The Future of Oracle DBA in Kubernetes Era: OCI, OpenShift, and OSOK in Action

From DBA to Cloud-Native Engineer: Managing Databases on OCI with Kubernetes, OSOK & OpenShift A deep-dive for Oracle DBAs, Site Reliabi...