39 begin |
39 begin |
40 null; |
40 null; |
41 end; |
41 end; |
42 / |
42 / |
43 |
43 |
44 Информация о таблицах в БД Oracle. |
44 Database info. |
45 ================================== |
45 ============== |
46 |
46 |
47 Список таблиц:: |
47 List of current user owned tables:: |
48 |
48 |
49 select * from user_tables; |
49 select * from USER_TABLES; |
50 |
50 |
51 Занимаемый размер таблиц и индексов:: |
51 List of current user table sizes:: |
52 |
52 |
53 select segment_name, segment_type, sum(bytes) from user_extents |
53 select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS |
54 group by segment_name, segment_type order by sum(bytes); |
54 group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); |
55 |
55 |
56 select sum(bytes) from user_extents; |
56 select sum(BYTES) from USER_EXTENTS; |
57 |
57 |
58 Список индексов по таблицам:: |
58 Tables indexes:: |
59 |
59 |
60 select * from user_indexes order by table_name; |
60 select * from USER_INDEXES order by TABLE_NAME; |
61 |
61 |
62 Список размеров индексов по таблицам:: |
62 List of index sizes:: |
63 |
63 |
64 select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes |
64 select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes |
65 left outer join user_extents on user_extents.segment_name = table_name |
65 left outer join user_extents on user_extents.segment_name = table_name |
66 group by index_name, table_name |
66 group by index_name, table_name |
67 order by table_name; |
67 order by table_name; |
68 |
68 |
69 Список ограничений:: |
69 List of currenct user constraints:: |
70 |
70 |
71 select * from user_constraints; |
71 select * from USER_CONSTRAINTS; |
72 |
72 |
73 Используемое пространство таблиц:: |
73 List of tablespaces:: |
74 |
74 |
75 select distinct tablespace_name from user_tables; |
75 select distinct TABLESPACE_NAME from USER_TABLES; |
76 |
76 |
77 List of current user permissions:: |
77 List of current user permissions:: |
78 |
78 |
79 select * from session_privs; |
79 select * from SESSION_PRIVS; |
80 |
80 |
81 List of user permissions to tables:: |
81 List of user permissions to tables:: |
82 |
82 |
83 select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%'; |
83 select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%'; |
84 |
84 |