oracleÊý¾Ý×ÖµäС½á

ÏÂÃæ°´Àà±ðÁгöһЩORACLEÓû§³£ÓÃÊý¾Ý×ÖµäµÄ²éѯʹÓ÷½·¨¡£
   
    Ò»¡¢Óû§
    ²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
    SQL>select username,default_tablespace from user_users;
    ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
    SQL>select * from user_role_privs;
 
    ²é¿´µ±Ç°Óû§µÄϵͳȨÏÞºÍ±í¼¶È¨ÏÞ
    SQL>select * from user_sys_privs;
    SQL>select * from user_tab_privs;
    ¶þ¡¢±í
     
    ²é¿´Óû§ÏÂËùÓеıí
    SQL>select * from user_tables;
         
    ²é¿´Ãû³Æ°üº¬log×Ö·ûµÄ±í
    SQL>select object_name,object_id from user_objects where instr(object_name,'LOG')>0;
     
    ²é¿´Ä³±íµÄ´´½¨Ê±¼ä 
    SQL>select object_name,created from user_objects where object_name=upper('&table_name');
     
    ²é¿´Ä³±íµÄ´óС
    SQL>select sum(bytes)/(1024*1024) as size(M) from user_segments where segment_name=upper('&table_name');
     
    ²é¿´·ÅÔÚORACLEµÄÄÚ´æÇøÀïµÄ±í  
    SQL>select table_name,cache from user_tables where instr(cache,'Y')>0;
   
    Èý¡¢Ë÷Òý
    
    ²é¿´Ë÷Òý¸öÊýºÍÀà±ð
    SQL>select index_name,index_type,table_name from user_indexes order by table_name;
 ²é¿´Ë÷Òý±»Ë÷ÒýµÄ×Ö¶Î
    SQL>select * from user_ind_columns where index_name=upper('&index_name');
     
    ²é¿´Ë÷ÒýµÄ´óС
    SQL>select sum(bytes)/(1024*1024) as size(M) from user_segments where segment_name=up