¡¡¡¡¶þ¡¢±í

¡¡¡¡²é¿´Óû§ÏÂËùÓеıí4%_=L}A )5QT€8Pa`"[ ´ËÎÄתÌùÓÚÎÒµÄѧϰÍøITÈÏÖ¤ORACLE/CIWÈÏÖ¤ http://www.Gzu521.com]4%_=L}A )5QT€8Pa`"

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('%26amp;table_name');

¡¡¡¡²é¿´Ä³±íµÄ´óС

sql>select sum(bytes)/(1024*1024) as "size(m)" from user_segments where segment_name=upper('%26amp;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('%26amp;index_name');

¡¡¡¡²é¿´Ë÷ÒýµÄ´óС

sql>select sum(bytes)/(1024*1024) as "size(m)" from user_segments where segment_name=upper('%26amp;index_name');

±¾ÎĹ²4Ò³: µÚ [1] [2] [3] [4] Ò³