Displays the table statistics belonging to the specified

-- Description : Displays the table statistics belonging to the specified schem


-- -----------------------------------------------------------------------------
------
-- Author : www.aws-senior.com
-- Description : Displays the table statistics belonging to the specified schem
a.
-- Requirements : Access to the DBA and v$ views.
-- Call Syntax : @table_stats (schema-name) (table-name)
-- -----------------------------------------------------------------------------
------
SET LINESIZE 300 VERIFY OFF

COLUMN owner FORMAT A20
COLUMN table_name FORMAT A30
COLUMN index_name FORMAT A30

SELECT owner,
table_name,
num_rows,
blocks,
empty_blocks,
avg_space
chain_cnt,
avg_row_len,
last_analyzed
FROM dba_tables
WHERE owner = UPPER('&1')
AND table_name = UPPER('&2');

SELECT index_name,
blevel,
leaf_blocks,
distinct_keys,
avg_leaf_blocks_per_key,
avg_data_blocks_per_key,
clustering_factor,
num_rows,
last_analyzed
FROM dba_indexes
WHERE table_owner = UPPER('&1')
AND table_name = UPPER('&2')
ORDER BY index_name;

COLUMN column_name FORMAT A30
COLUMN low_value FORMAT A40
COLUMN high_value FORMAT A40
COLUMN endpoint_actual_value FORMAT A30

SELECT column_id,
column_name,
num_distinct,
avg_col_len,
histogram,
low_value,
high_value
FROM dba_tab_columns
WHERE owner = UPPER('&1')
AND table_name = UPPER('&2')
ORDER BY column_id;

SET VERIFY ON


--------------------------------------------------------------------------------------
-- File Name : https://github.com/Zaalouni/OracleDba
-- Author : Zaalouni
-- website : http://www.aws-senior.com
-- Github : https://github.com/Zaalouni/OracleDba
--------------------------------------------------------------------------------------

aws-senior.com

www.aws-senior.com
Visite out website www.aws-senior.com
http://www.aws-senior.com
www.aws-senior.com