IDENTIFYING the Activities done in the Tablespace

Find the creation dates of
datafiles for the reported tablespace

set
pagesize 100

select FILE#||’ ‘||CREATION_TIME||’ ‘||TS#||’
‘||BYTES||’ ‘||NAME from
v$datafile where TS# = (select TS# from v$tablespace where name = ‘&TS_name’);

To find which users are having this
tablespace as their default ts

Select
USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users
where DEFAULT_TABLESPACE=’&Ts_name’;

To find Which user using how many
segments from this ts

select
OWNER,SEGMENT_NAME,TABLESPACE_NAME,BYTES from dba_segments where
TABLESPACE_NAME=’&TS_name’ order by bytes;