oracle查询表和数据字典（国外英文资料）.doc

oracle查询表和数据字典（国外英文资料） Oracle checks the number of user tables, the size of the table, the number of views (2012-08-03 17:08:22) Label: talk View the default table space for the current user SQL select username, default_tablespace from user_users; View the current users role SQL select * from user_role_privs; View the current users system permissions and table level permissions SQL select * from user_sys_privs; SQL select * from user_tab_privs; View all the tables under the user SQL select * from user_tables 1, the user View the default table space for the current user SQL select username, default_tablespace from user_users; View the current users role SQL select * from user_role_privs; View the current users system permissions and table level permissions SQL select * from user_sys_privs; SQL select * from user_tab_privs; Displays the permissions that the current session has SQL select * from session_privs; Displays the system permissions that the user has SQL select * from dba_sys_privs where grantee = GAME; 2, table, View all the tables under the user SQL select * from user_tables See the table with the log character SQL select object_name, object_id from user_objects Where instr (object_name, LOG) 0; View the creation time of a table SQL select object_name, created from user_objects where object_name = upper ( table_name ); Look at the size of a table SQL select sum (bytes)/(1024 * 1024) as size (M) from user_segments Where segment_name = upper ( table_name ); View the table in the memory area of ORACLE SQL select table_name, cache from user_tables where instr (cache, Y) 0; 3, index, View index Numbers and categories SQL select index_name, index_type, table_name from user_indexes order by table_name; See the fields where the index is indexed SQL select * from user_ind_columns where index_name = upper ( index_name ); Look at the size of the index SQL select sum (bytes)/(1024 * 1024) as size (M) from user_segments Where segment_name = upper