46 lines
1.3 KiB
SQL
46 lines
1.3 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display Auto Task Windows
|
|
* Compatibility :
|
|
* Parameters : NONE
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 14-Dec-16 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
PROMPT **************************************************
|
|
PROMPT * DB Auto Task Windows
|
|
PROMPT **************************************************
|
|
|
|
COLUMN window_name HEADING "Window Name" FORMAT a35
|
|
COLUMN autotask_status HEADING "Status" FORMAT a8
|
|
COLUMN window_active HEADING "Window|Active" FORMAT a6
|
|
COLUMN optimizer_stats HEADING "Optimizer|Stats" FORMAT a8
|
|
COLUMN segment_advisor HEADING "Segment|Advisor" FORMAT a8
|
|
COLUMN sql_tune_advisor HEADING "SQL|Tune" FORMAT a8
|
|
COLUMN health_monitor HEADING "Health|Monitor" FORMAT a8
|
|
COLUMN window_next_time HEADING "Window|Next Time" FORMAT a40 TRUNC
|
|
|
|
SELECT a.window_name
|
|
, a.autotask_status
|
|
, a.window_active
|
|
, a.optimizer_stats
|
|
, a.segment_advisor
|
|
, a.sql_tune_advisor
|
|
, a.health_monitor
|
|
, a.window_next_time
|
|
FROM dba_autotask_window_clients a
|
|
order by a.window_next_time
|
|
;
|
|
|
|
@@footer
|
|
|