ITPub博客

create or replace procedure show_space( p_segname in varchar2,p_owner in varchar2 default user,p_type in varchar2 default 'TABLE',p_partition in varchar2 default NULL )-- This procedure uses AUTHID CURRENT USER so it can query DBA_*-- views using privileges from a ROLE and so it can be installed-- once per database, instead of once per user who wanted to use it.AUTHID CURRENT_USERasl_free_blks number;l_total_blocks number;l_total_bytes number;l_unused_blocks number;l_unused_bytes number;l_LastUs