CODE DEPOT
This is the fourth of Kevin Loney's "10 Scripts Every DBA Should Have." Watch for a complete article on how to use these scripts in a future issue of Oracle Magazine. There are other valuable scripts as well, but these ten--covering backup/recovery, space management, account management, maintenance, and tuning--provide basic guideposts to start from during your administration activities.
Don't leave $ORACLE_HOME without them!
DBA_TS_QUOTAS displays the allocated space, by user, in each tablespace, along with the quota for each of those users. If a user has unlimited quota in a tablespace, the quota will be displayed as 0 or negative. Running this script is a great quick way to see which users own objects in which tablespaces, and how close they are to their quotas. You'll need to SET LINESIZE 132 before running this script.
APRIL 15, 1996
No. 4: Display Allocated Space & Quota by User
This "Code Depot" entry comes from Kevin Loney, the author of two of the first three books from Oracle Press: Oracle DBA Handbook and Oracle: The Complete Reference, Third Edition (with George Koch). See the Osborne/McGraw-Hill Web site at www.osborne.com. for sample chapters from these books and the scripts from the Oracle DBA Handbook.select * from DBA_TS_QUOTAS
order by Tablespace_Name, Username;
All specific technical questions from users of Oracle supported products should be directed to Oracle's Technical Support Department. Oracle does not provide any warranty as to the accuracy of any information provided through Oracle Magazine Interactive. Oracle shall not be liable for any damages incurred as a result of reliance on any information provided herein.
Copyright © 1994, 1995, 1996 & 1997 Oracle Corporation. All Rights Reserved.