HighLight in your life~

*테이블 정보 검색

1)DBA_OBJECTS

select owner, object_name, object_id, data_object_id from dba_objects;
select owner, object_name, object_id, data_object_id from dba_objects where rownum < 3;

2)DBA_SEGMENTS

select owner, segment_name, tablespace_name, header_file, header_block from dba_segments;
select owner, segment_name, tablespace_name, header_file, header_block from dba_segments where rownum < 3;

3)DBA_TABLES

select owner, table_name, pct_free, pct_used, initial_extent, next_extent, min_extents, max_extents, pct_increase, cache, blocks, empty_blocks, chain_cnt,

temporary, duration from dba_tables;

select owner, table_name, pct_free, pct_used, initial_extent, next_extent, min_extents, max_extents, pct_increase, cache, blocks, empty_blocks, chain_cnt,

temporary, duration from dba_tables where rownum < 3;

4)DBA_EXTENTS

select owner, segment_name, extent_id, file_id, block_id, blocks from dba_extents;
select owner, segment_name, extent_id, file_id, block_id, blocks from dba_extents where rownum < 3;