50 lines
1.2 KiB
SQL
50 lines
1.2 KiB
SQL
@@myheader.sql
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
UNDEFINE since
|
|
UNDEFINE until
|
|
UNDEFINE detail_level
|
|
UNDEFINE format
|
|
|
|
DEFINE since="&&1"
|
|
DEFINE until="&&2"
|
|
DEFINE detail_level="&&3"
|
|
DEFINE format="&&4"
|
|
|
|
COLUMN _detail_level NEW_VALUE detail_level NOPRINT
|
|
COLUMN _format NEW_VALUE format NOPRINT
|
|
|
|
set term off
|
|
SELECT
|
|
DECODE('&&detail_level','','BASIC',UPPER('&&detail_level')) "_detail_level"
|
|
, DECODE('&&format','','TEXT',UPPER('&&format')) "_format"
|
|
FROM DUAL;
|
|
set term on
|
|
|
|
|
|
PROMPT
|
|
PROMPT ***********************************************************************
|
|
PROMPT * STATS OPERATIONS
|
|
PROMPT *
|
|
PROMPT * Input Parameters
|
|
PROMPT * - since = '&&since'
|
|
PROMPT * - until = '&&until'
|
|
PROMPT * - detail_level = '&&detail_level'
|
|
PROMPT * - format = '&&format'
|
|
PROMPT ***********************************************************************
|
|
|
|
|
|
select
|
|
DBMS_STATS.REPORT_STATS_OPERATIONS (
|
|
since => &&since
|
|
,until => &&until
|
|
,detail_level => '&&detail_level'
|
|
,format => '&&format'
|
|
)
|
|
from dual;
|
|
|
|
|
|
@@myfooter.sql
|