# HG changeset patch # User Oleksandr Gavenko # Date 1412093381 -10800 # Node ID 4496f9e49b7b1389c03683327e2317d96f972b24 # Parent dec1fd4222e89480813198d48b3febea631605f5 Reformat code. diff -r dec1fd4222e8 -r 4496f9e49b7b oracle.rst --- a/oracle.rst Tue Sep 30 19:05:49 2014 +0300 +++ b/oracle.rst Tue Sep 30 19:09:41 2014 +0300 @@ -41,42 +41,42 @@ end; / -Информация о таблицах в БД Oracle. -================================== +Database info. +============== -Список таблиц:: +List of current user owned tables:: - select * from user_tables; + select * from USER_TABLES; -Занимаемый размер таблиц и индексов:: +List of current user table sizes:: - select segment_name, segment_type, sum(bytes) from user_extents - group by segment_name, segment_type order by sum(bytes); + select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS + group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); - select sum(bytes) from user_extents; + select sum(BYTES) from USER_EXTENTS; -Список индексов по таблицам:: +Tables indexes:: - select * from user_indexes order by table_name; + select * from USER_INDEXES order by TABLE_NAME; -Список размеров индексов по таблицам:: +List of index sizes:: select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes left outer join user_extents on user_extents.segment_name = table_name group by index_name, table_name order by table_name; -Список ограничений:: +List of currenct user constraints:: - select * from user_constraints; + select * from USER_CONSTRAINTS; -Используемое пространство таблиц:: +List of tablespaces:: - select distinct tablespace_name from user_tables; + select distinct TABLESPACE_NAME from USER_TABLES; List of current user permissions:: - select * from session_privs; + select * from SESSION_PRIVS; List of user permissions to tables::