Ask the Expert

See tablespace utilization/database size without DBA privileges

Greetings! I was just wondering, can I see the tablespace utilization and the current database size of my database even though the Oracle user account I'm using does not have DBA privileges? Thanks. By the way, I'm using Oracle 9i.

    Requires Free Membership to View

You can if your Oracle account has the Select Any Dictionary system privilege or the Select_Catalog_Role role granted to it. Either one of these privileges will allow you to query the DBA_DATA_FILES and DBA_FREE_SPACE system views so you can get that information. If not, you will need your DBA to grant one of those privileges to your account.

This was first published in May 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: