Oracle USER DETAILS

prompt
prompt user details :

clear breaks
clear computes
clear columns

select username,profile,default_tablespace,temporary_tablespace from dba_users;

select * from nls_database_parameters;

select TABLESPACE_NAME,BLOCK_SIZE,EXTENT_MANAGEMENT,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;

select owner,object_type,count(1) from dba_objects group by owner,object_type
order by owner ;

SELECT file_name,tablespace_name,autoextensible,maxbytes/1048576 FROM dba_data_files;