29 lines
625 B
SQL
29 lines
625 B
SQL
@@header
|
|
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display system statistics information
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 29-Dec-14 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
COLUMN sname HEADING "Stat Type" FORMAT a15
|
|
COLUMN pname HEADING "Stat Name" FORMAT a15
|
|
COLUMN value HEADING "Value" FORMAT a30
|
|
|
|
SELECT sname
|
|
, pname
|
|
, TRIM(NVL(TO_CHAR(pval1,'999,999,999'),pval2)) value
|
|
FROM sys.aux_stats$
|
|
;
|
|
|
|
|
|
@@footer |