Oracle³£ÓÃÊý¾Ý×ÖµäµÄ²éѯʹÓ÷½·¨

²é¿´Óû§ÏÂËùÓеıí
SQL>select * from user_tables;
ÏÔʾÓû§ÐÅÏ¢(ËùÊô±í¿Õ¼ä)
select default_tablespace,temporary_tablespace
from dba_users where username='GAME'; É°ÂÖ
1¡¢Óû§
²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
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 session_privs;
ÏÔʾָ¶¨Óû§Ëù¾ßÓеÄϵͳȨÏÞ
SQL>select * from dba_sys_privs where grantee='GAME';
ÏÔʾÌØȨÓû§ É°ÂÖ
select * from v$pwfile_users;
ÏÔʾÓû§ÐÅÏ¢(ËùÊô±í¿Õ¼ä)
select default_tablespace,temporary_tablespace
from dba_users where username='GAME';
ÏÔʾÓû§µÄPROFILE É°ÂÖ
select profile from dba_users where username='GAME';
2¡¢±í
²é¿´Óû§ÏÂËùÓеıí
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;
3¡¢Ë÷Òý
²é¿´Ë÷Òý¸öÊýºÍÀà±ð É°ÂÖ
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=upper('&index_name');
4¡¢ÐòÁкÅ
²é¿´ÐòÁкţ¬last_numberÊǵ±Ç°Öµ
SQL>select * from user_sequences;
5¡¢ÊÓͼ É°ÂÖ
²é¿´ÊÓͼµÄÃû³Æ
SQL>select view_name from user_views;
²é¿´´´½¨ÊÓͼµÄselectÓï¾ä
SQL>set view_name,text_leng