| Security Advisory |
According to the file header for this package it is part of Application Resilience and is a PL/SQL API for disrupting sessions and services.
If the use of the word DISRUPT in conjunction with sessions and services does not provide sufficient information as to why you should monitor any and all access and attempts to access this package you are probably on the wrong website. |
| |
| Recommended Security Rules |
NEVER
- Grant execute on this package to any user or application unless that application is only for use in a test environment as part of a program approved and monitored by your CISO.
WITH GREAT CARE
- Monitor every call to execute this package
CAUTIONS
- Log any questions or requests with respect to accessing or utilizing this package
|
| |
| DBMS_METADATA Package Information |
| AUTHID |
DEFINER |
| Constants |
| Name |
Data Type |
Value |
| all_instances |
VARCHAR2(2) |
'*' |
| all_modules |
VARCHAR2(2) |
'*' |
| all_services |
VARCHAR2(2) |
'*' |
| all_users |
VARCHAR2(2) |
'*' |
| cur_instance |
VARCHAR2(2) |
'?' |
| cur_user |
VARCHAR2(2) |
'?' |
|
| Dependencies |
| DBA_SCHEDULER_JOBS |
DBMS_SERVICE |
PLITBLM |
| DBMS_ASSERT |
DBMS_STANDARD |
UTL_FILE |
| DBMS_RANDOM |
DUAL |
V$INSTANCE |
| DBMS_SCHEDULER |
|
|
|
| Documented |
No |
| Exceptions |
| Error Code |
Reason |
| ORA-20001 |
invalid parameter - stop_interval |
| ORA-27475 |
unknown job "SYS"."DSR$UWSESSJOB" |
|
| First Available |
12.2 |
| Security Model |
Owned by SYS with no privileges granted. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsapre.sql |
| Subprograms |
|
| |
| DISRUPT_SERVICES |
| Undocumented |
dbms_disrupt.disrupt_services(
job_name IN VARCHAR2,
service_names IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := NULL,
percentage IN NUMBER,
sleep_interval IN NUMBER,
stop_interval IN NUMBER := 0,
duration IN NUMBER := 0,
output_file IN VARCHAR2 := NULL); |
exec dbms_disrupt.disrupt_services('UWSESSJOB', percentage=>0, sleep_interval=> 0, stop_interval => 1);
PL/SQL procedure successfully completed. |
| |
| DISRUPT_SERVICES_CANCEL |
| Undocumented |
dbms_disrupt.disrupt_services_cancel(job_name IN VARCHAR2 := '*'); |
exec dbms_disrupt.disrupt_services_cancel('UWSESSJOB');
PL/SQL procedure successfully completed. |
| |
| DISRUPT_SERVICES_IMMEDIATE |
| Undocumented |
dbms_disrupt.disrupt_services_immediate(
job_name IN VARCHAR2,
service_names IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := NULL,
percentage IN NUMBER,
stop_interval IN NUMBER,
output_file IN VARCHAR2 := NULL); |
exec dbms_disrupt.disrupt_services_immediate('UWSESSJOB', percentage=>10, stop_interval => 2);
PL/SQL procedure successfully completed. |
| |
| DISRUPT_SESSIONS |
| Undocumented |
dbms_disrupt.disrupt_sessions(
job_name IN VARCHAR2,
user_names IN VARCHAR2 := '?',
service_names IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := '?',
module_names IN VARCHAR2 := '*',
percentage IN NUMBER,
sleep_interval IN NUMBER,
duration IN NUMBER := 0,
output_file IN VARCHAR2 := NULL); |
| TBD |
| |
| DISRUPT_SESSIONS_CANCEL |
| Undocumented |
dbms_disrupt.disrupt_sessions_cancel(job_name IN VARCHAR2 := '*'); |
exec dbms_disrupt.disrupt_sessions_cancel('UWSESSJOB'); |
| |
| DISRUPT_SESSIONS_IMMEDIATE |
| Undocumented |
dbms_disrupt.disrupt_sessions_immediate(
user_names IN VARCHAR2 := '*',
service_names IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := '?',
module_names IN VARCHAR2 := '*',
percentage IN NUMBER,
output_file IN VARCHAR2 := NULL); |
| TBD |
| |
| WAKE_UP_SERVICE |
| Undocumented |
dbms_disrupt.wake_up_service(
service_name IN VARCHAR2,
instance_name IN VARCHAR2,
output_file IN VARCHAR2) := NULL; |
exec dbms_disrupt.wake_up_service('SYS$USERS', 'ORABASE');
PL/SQL procedure successfully completed. |