Oracle 视图 ALL_SCHEDULER_WINDOW_GROUPS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_SCHEDULER_WINDOW_GROUPS视图包含DBMS_SCHEDULER中定义的所有窗口组。此视图也显示了每个窗口组包含的窗口。
使用方法：
1.通过查询ALL_SCHEDULER_WINDOW_GROUPS以及它所关联的窗口视图来获取数据：SELECT * FROM ALL_SCHEDULER_WINDOW_GROUPS WG, ALL_SCHEDULER_WINDOWS W WHERE W.WINDOW_GROUP_ID = WG.WINDOW_GROUP_ID;
2.使用DBMS_SCHEDULER.DROP_WINDOW_GROUP 程序来删除窗口组：EXEC DBMS_SCHEDULER.DROP_WINDOW_GROUP(window_group_name => ‘mywindowgroup’);
3.使用DBMS_SCHEDULER.CREATE_WINDOW_GROUP程序来创建窗口组：EXEC DBMS_SCHEDULER.CREATE_WINDOW_GROUP( window_group_name => ‘mywindowgroup’);
官方英文解释
ALL_SCHEDULER_WINDOW_GROUPS displays information about the Scheduler window groups accessible to the current user.
Related View
DBA_SCHEDULER_WINDOW_GROUPS displays information about all Scheduler window groups in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the window group |
|
|
|
Indicates whether the window group is enabled ( |
|
|
|
|
Number of members in the window group |
|
|
|
|
If a window group is disabled, then this column will be NULL. Otherwise, it will be set to the earliest |
|
|
|
|
Optional comment about the window group |
See Also:
“DBA_SCHEDULER_WINDOW_GROUPS”
