Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
The parameters associated with this procedure and their usage are as
group_name - A name that
uniquely identifies the window group.
window_list - A comma
separated list of windows associated with the window group.
comments - Free text
allowing the user to record additional information.
The following code creates a window group and
assigns the two test windows defined in the previous section.
group_name => 'test_window_group',
window_list => 'test_window_1,
comments => 'A test window group');
Figure 2.15 shows the Create Window Group
screen in the OEM 10g DB Control.
Figure 2.15 – OEM 10g DB Control: Create
Information about window groups can be
displayed using the dba_scheduler_window_groups and
dba_scheduler_wingroup_members views. The following script uses
both views to display a summary of window group information.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA