User objects and resources

In the following you will get an overview, how you can get information about your Oracle user environment. For the samples it is assumed, that you are already connected to the database via SQL*Plus.

Which tables do you have?

SQL> select table_name from user_tables;

How is my table defined, which columns has it?

SQL> describe table_name

Which database objects do I have currently?

SQL> select object_name, object_type from user_objects;

Which privileges has your Oracle account?

SQL> select * from session_privs;

Which quota do you actually have on which tablespace?

SQL> select tablespace_name, bytes, max_bytes from user_ts_quotas;

How big are your tables/objects for themselves?

SQL> select segment_name, tablespace_name, bytes from user_segments;

ref:

http://www-it.desy.de/systems/services/databases/oracle/at_desy/user_objects.html.en