Oracle DBMS_DISRUPT Built-In Package
Versions 12.2 - 21c

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.

Related Topics
DBMS_SQL
Object Privileges
System Privileges