<div>
You can also use dba_ts_quotas, which among others, has two columns<br />
MAX_BYTES - gives the allocated quota (or -1 for unlimited)<br />
BYTES - the actual usage.<br />
<br />
These will have one row per tablespace per user.<br />
<br />
Bob
</div>


You can also use dba_ts_quotas, which among others, has two columns
MAX_BYTES - gives the allocated quota (or -1 for unlimited)
BYTES - the actual usage.

These will have one row per tablespace per user.

Bob

<div>
Thanks for your help, it works
</div>


<div>
<div class="content wysiwyg-content">
I am new to Oracle, hope that you will help me to answer this easy question. Thanks.<br />
<br />
I would like to check the usage of an oracle account. I know i can use &quot;select * from user_ts_quotas&quot; to check space allocated for an account, but don't know how to check how much space has already used for an oracle account. What i want is something like &quot;quota -v&quot; for an unix account or a file that can show the usage situation for an account.<br />
<br />
<br />
<br />

</div>
</div>


I am new to Oracle, hope that you will help me to answer this easy question. Thanks.

I would like to check the usage of an oracle account. I know i can use "select * from user_ts_quotas" to check space allocated for an account, but don't know how to check how much space has already used for an oracle account. What i want is something like "quota -v" for an unix account or a file that can show the usage situation for an account.





** Simple Question, pls help ** : Check Quota Usage for an account

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.