Database Reference
In-Depth Information
$ sqlplus -s hr/hr
@
statistics.
sql
employees
Table Owner Number Empty Average Chain Average Global User Sample Last
and Name of Rows Blocks Blocks Space Count Row Len Stats Stats Size Analyze
------------------------------ ------------ ----------- -------- ------- ----- ------- ------ ----- ---------- ---------------
HR . EMPLOYEES 107 5 0 0 0 68 YES NO 2,000 01.Oct 07 18:09
Block- Moni- Buffer IOT
Tablespace size Size (MB) toring Pool Degree Cluster Type IOT Name
------------------------------ ------- --------- ------ ------- ------ ------- ------- ------------------------------
EXAMPLE 8 KB 0 YES DEFAULT 1
Column Column Distinct Number Number Global User Sample Last
Name Details Values Density Buckets Nulls Stats Stats Size Analyze
------------------------------ ------------------------ --------------- -------- ------- ---------- ------ ----- ---------- ------------
---
EMPLOYEE_ID NUMBER(6) NOT NULL 107 .0093 1 0 YES NO 01.Oct 07 18:09
FIRST_NAME VARCHAR2(20) 91 .0110 1 0 YES NO 01.Oct 07 18:09
LAST_NAME VARCHAR2(25) NOT NULL 102 .0098 1 0 YES NO 01.Oct 07 18:09
EMAIL VARCHAR2(25) NOT NULL 107 .0093 1 0 YES NO 01.Oct 07 18:09
PHONE_NUMBER VARCHAR2(20) 107 .0093 1 0 YES NO 01.Oct 07 18:09
HIRE_DATE DATE NOT NULL 98 .0102 1 0 YES NO 01.Oct 07 18:09
JOB_ID VARCHAR2(10) NOT NULL 19 .0047 19 0 YES NO 01.Oct 07 18:09
SALARY NUMBER(8,2) 57 .0175 1 0 YES NO 01.Oct 07 18:09
COMMISSION_PCT NUMBER(2,2) 7 .1429 1 72 YES NO 01.Oct 07 18:09
MANAGER_ID NUMBER(6) 18 .0047 18 1 YES NO 01.Oct 07 18:09
DEPARTMENT_ID NUMBER(4) 11 .0047 11 1 YES NO 01.Oct 07 18:09
Index Owner Last Sample Buffer
and Name Created Last DDL Analyze Size Pool Degree
------------------------------ --------------- --------------- --------------- ---------- ------- ------
HR . EMP_EMAIL_UK 01.Oct 07 18:09 05.Oct 07 09:08 01.Oct 07 18:09 2,500 DEFAULT 1
HR . EMP_EMP_ID_PK 01.Oct 07 18:09 05.Oct 07 00:42 01.Oct 07 18:09 2,500 DEFAULT 1
HR . EMP_DEPARTMENT_IX 01.Oct 07 18:09 05.Oct 07 00:42 01.Oct 07 18:09 2,500 DEFAULT 1
HR . EMP_JOB_IX 01.Oct 07 18:09 05.Oct 07 00:42 01.Oct 07 18:09 2,500 DEFAULT 1
HR . EMP_MANAGER_IX 01.Oct 07 18:09 05.Oct 07 00:42 01.Oct 07 18:09 2,500 DEFAULT 1
HR . EMP_NAME_IX 01.Oct 07 18:09 05.Oct 07 00:42 01.Oct 07 18:09 2,500 DEFAULT 1
Average Average
B Leaf Data
Index Owner Index Uni Tree Leaf Distinct Number Blocks Blocks Cluster Global User
and Name Type que Level Blks Keys of Rows Per Key Per Key Factor Stats Stats
------------------------------ -------- --- ----- ---------- --------------- ------------ ------- ------- ----------- ------ -----
HR . EMP_EMAIL_UK NORMAL YES 0 1 107 107 1 1 19 YES NO
HR . EMP_EMP_ID_PK NORMAL YES 0 1 107 107 1 1 2 YES NO
HR . EMP_DEPARTMENT_IX NORMAL NO 0 1 11 106 1 1 7 YES NO
HR . EMP_JOB_IX NORMAL NO 0 1 19 107 1 1 8 YES NO
HR . EMP_MANAGER_IX NORMAL NO 0 1 18 106 1 1 7 YES NO
HR . EMP_NAME_IX NORMAL NO 0 1 107 107 1 2 15 YES NO
Index Owner Column Col Column
and Name Name Pos Details
------------------------------ ------------------------------ ---- ------------------------
HR . EMP_DEPARTMENT_IX DEPARTMENT_ID 1 NUMBER(4)
HR . EMP_EMAIL_UK EMAIL 1 VARCHAR2(25) NOT NULL
HR . EMP_EMP_ID_PK EMPLOYEE_ID 1 NUMBER(6) NOT NULL
HR . EMP_JOB_IX JOB_ID 1 VARCHAR2(10) NOT NULL
HR . EMP_MANAGER_IX MANAGER_ID 1 NUMBER(6)
HR . EMP_NAME_IX LAST_NAME 1 VARCHAR2(25) NOT NULL
FIRST_NAME 2 VARCHAR2(20)
