DBA TABLES

select * from v$instance;

select name from v$datafile;

select * from v$database;

select * from v$parameter;  --user_dump_dest  --sql_trace

select * from all_tables;

select * from dba_tables;

select * from V$NLS_PARAMETERS;

SELECT object_name, original_name, createtime FROM recyclebin;

select * from PRODUCT_COMPONENT_VERSION;

select * from NLS_DATABASE_PARAMETERS;

select * from ALL_LOBS;

select * from DBA_DB_LINKS;

select * from ALL_TAB_COLUMNS;