Oracle数据字典表-1

权限安全的数据字典表有:

ALL_TAB_PRIVS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

DBA_SYS_PRIVS

DBA_ROLES

DBA_ROLE_PRIVS

ROLE_ROLE_PRIVS

ROLE_SYS_PRIVS

ROLE_TAB_PRIVS

SESSION_PRIVS

SESSION_ROLES

USER_SYS_PRIVS

USER_TAB_PRIV

--check the number of index and type
select index_name,index_type,table_name from user_indexes where table_name=upper('&table_name');

--check the indexed column
select * from user_ind_columns where index_name=upper('&index_name');

-check the size of index
select sum(bytes)/(1024*1024) as "size(M)" from user_segments
where segment_name=upper('&index_name');