sql command to check the complete details of oracle database

spool D:\central\configuration.txt select name,log_mode,open_mode from v$database; select name from v$controlfile; select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET'; select * from v$tablespace; select BLOCK_SIZE from dba_tablespaces where tablespace_name in ('SYSTEM','UNDOTBS1','SYSAUX','TEMP','USERS','USER_DATA',INDEX_DATA'); select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'UNDOTBS1'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'SYSAUX'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'TEMP'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'USERS'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'USER_DATA'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'INDEX_DATA'; select PROPERTY_VALUE from database_properties where property_name = 'DEFAULT_PERMANENT_TABLESPACE'; select value from v$parameter where name = 'db_block_size'; select value from v$parameter where name = 'undo_management'; select value from v$parameter where name = 'undo_tablespace'; select BLOCK_SIZE from dba_tablespaces where tablespace_name = 'UNDOTBS1'; select FILE_NAME, BYTES/1024/1024, AUTOEXTENSIBLE, MAXBYTES,INCREMENT_BY from dba_data_files where tablespace_name='UNDOTBS1'; select TABLESPACE_NAME, INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE, MIN_EXTLEN, STATUS, CONTENTS, LOGGING, EXTENT_MANAGEMENT, ALLOCATION_TYPE, BLOCK_SIZE, FORCE_LOGGING, SEGMENT_SPACE_MANAGEMENT from dba_tablespaces; select USERNAME, USER_ID, PASSWORD, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, CREATED, PROFILE, INITIAL_RSRC_CONSUMER_GROUP, EXTERNAL_NAME INITIAL_RSRC_CONSUMER_GROUP from dba_users; select PROFILE from dba_profiles group by profile; select RESOURCE_NAME, RESOURCE_TYPE, LIMIT from dba_profiles where profile=’DEFAULT';