To list the users and the tablespace being used in database

To check the users using which tablespace in the database;

select username,default_tablespace from dba_users ;

 TO list  all the users and the tablespace being used in database


set pages 999 lines 100
col username    format a20
col status    format a8
col tablespace    format a20
col temp_ts    format a20
select    username
,    account_status status
,    created
,    default_tablespace tablespace
,    temporary_tablespace temp_ts
from    dba_users
order    by username
/