Monday, September 13, 2010

How to findout users on quota tablespace?

select username,TABLESPACE_NAME,round(bytes/1024/1024/1024,2) Used_GB ,round(max_bytes/1024/1024/1024,2) Max_GB from dba_ts_quotas;

No comments:

Post a Comment