Empty block count after delete using ASSM=MANUAL.

Hi Team,

I am running 64 bit oracle 11.2.0.3. Can anyone tell me free space in blocks after delete? Below procedure works only when tablespace is created with ASSM=AUTO. I need one for MSSM.

Any help will be greatly appreciated.

== For ASSM=AUTO

declare

v_unformatted_blocks number;

v_unformatted_bytes number;

v_fs1_blocks number;

v_fs1_bytes number;

v_fs2_blocks number;

v_fs2_bytes number;

v_fs3_blocks number;

v_fs3_bytes number;

v_fs4_blocks number;

v_fs4_bytes number;

v_full_blocks number;

v_full_bytes number;

begin

dbms_space.space_usage (

'TEST',

'TEST',

'TABLE',

v_unformatted_blocks,