Oracle DBA Admin SQLs to check tablespace sizes and table sizes (Untested)

select

   srt.tablespace,

   srt.segfile#,

   srt.segblk#,

   srt.blocks,

   a.sid,

   a.serial#,

   a.username,

   a.osuser,

   a.status

from   

   v$session    a,

   v$sort_usage srt

where

   a.saddr = srt.session_addr

   order by

srt.tablespace, srt.segfile#, srt.segblk#,

 srt.blocks;

 select * from v$sort_usage;

 select * from v$sort_segment;

SELECT

   A.tablespace_name tablespace,

   D.mb_total,

   SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,

   D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free

FROM

   v$sort_segment A,

(

SELECT

   B.name,

   C.block_size,

   SUM (C.bytes) / 1024 / 1024 mb_total

FROM

   v$tablespace B,

   v$tempfile C

WHERE

   B.ts#= C.ts#

GROUP BY

   B.name,

   C.block_size

) D

WHERE

   A.tablespace_name = D.name

GROUP by

   A.tablespace_name,

   D.mb_total

  

select * from v$tablespace;

select * from v$datafile;

select * from v$tempfile;

select * from v$sort_segment;

select * from dba_data_files where TABLESPACE_NAME like 'PULSE%';

select SEGMENT_NAME, bytes/(1024*1024) datasize from dba_segments where TABLESPACE_NAME ='PULSETABLESPACE' order by bytes desc;

select df.tablespace_name "Tablespace",

totalusedspace "Used MB",

(df.totalspace - tu.totalusedspace) "Free MB",

df.totalspace "Total MB",

round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))

"Pct. Free"

from

(select tablespace_name,

round(sum(bytes) / 1048576) TotalSpace

from dba_data_files

group by tablespace_name) df,

(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name

from dba_segments

group by tablespace_name) tu

where df.tablespace_name = tu.tablespace_name ;

Best  regards,

Kelvin Lo