반응형
USER_TAB_HISTOGRAMS |
These views describe histograms on tables and views. |
DBA_TAB_STATISTICS
ALL_TAB_STATISTICS USER_TAB_STATISTICS |
These views contain optimizer statistics for tables. |
DBA_TAB_COL_STATISTICS
ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS |
These views provide column statistics and histogram information extracted from the related TAB_COLUMNS views. |
DBA_TAB_MODIFICATIONS
ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS |
These views describe tables that have been modified since the last time table statistics were gathered on them. They are not populated immediately, but after a time lapse (usually 3 hours). |
DBA_ENCRYPTED_COLUMNS
USER_ENCRYPTED_COLUMNS ALL_ENCRYPTED_COLUMNS |
These views list table columns that are encrypted, and for each column, lists the encryption algorithm in use. |
DBA_UNUSED_COL_TABS
ALL_UNUSED_COL_TABS USER_UNUSED_COL_TABS |
These views list tables with unused columns, as marked by the ALTER TABLE ... SET UNUSEDstatement. |
DBA_PARTIAL_DROP_TABS
ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS |
These views list tables that have partially completed DROP COLUMN operations. These operations could be incomplete because the operation was interrupted by the user or a system failure. |
반응형
'개발정보' 카테고리의 다른 글
MySQL, 시간 차 , 시간 간격 구하는 방법, 업무수행 시간 구하기 (0) | 2019.06.22 |
---|---|
반정규화 (성능 향상을 위한 데이터 중복 허용) (0) | 2019.06.22 |
넥사크로 기술지원 및 라이센스 받을 수 있는 사이트 URL (0) | 2019.06.22 |
데이터 모델링 (0) | 2019.06.22 |
데이터베이스 카디널리티(Database Cardinality) (0) | 2019.06.22 |