Search This Blog

Total Pageviews

Tuesday, 4 October 2011

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;

1 comment:

Anuj Singh said...

set pagesize 300 linesize 300
col VALUE for a50
select * from nls_database_parameters;

Oracle DBA

anuj blog Archive