set_threshold(
metrics_id, warning_operator, new_warning_value,
critical_operator, critical_value,
observation_period, consecutive_occurrences,
instance_name, object_type, object_name);
end;
PL/SQL procedure successfully completed.
Checking DBA_THRESHOLDS again, we see the warning level has been changed to 60
percent:
SQL> select metrics_name, warning_operator warn, warning_value wval
2 from dba_thresholds;
METRICS_NAME WARN WVAL
-------------------------------- ---- -------------
Average Users Waiting Counts GT 10
. . .
Blocked User Session Count GT 0
Current Open Cursors Count GT 1200
Database Time Spent Waiting (%) GT 30
. . .
Logons Per Sec GE 100
Session Limit % GT 90
Tablespace Bytes Space Usage LE 0
Tablespace Space Usage GE 60
22 rows selected.
A detailed example of how to use Oracle??™s Advanced Queuing to subscribe to queue alert
messages is beyond the scope of this book. Later in this chapter, I will, however, show some
examples of how to use Enterprise Manager to set up asynchronous notification of alert conditions
using e-mail, a pager, or a PL/SQL procedure.
Resumable Space Allocation
Starting with Oracle9i, the Oracle database provides a way to suspend long-running operations in
the event of space allocation failures. Once the DBA is notified and the space allocation problem
has been corrected, the long-running operation can complete. The long-running operation does
not have to be restarted from the beginning.
Pages:
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349