Oracle DBMS_DISRUPT
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose PL/SQL interface for disrupting sessions and services
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
DBMS_SCHEDULER_JOBS DBMS_SERVICE PLITBLM
DBMS_ASSERT DBMS_STANDARD UTL_FILE
DBMS_RANDOM DUAL V$INSTANCE
DBMS_SCHEDULER    
Documented No
First Available 12.2.0.1
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);
TBD
 
DISRUPT_SERVICES_CANCEL
Undocumented dbms_disrupt.disrupt_services_cancel(job_name IN VARCHAR2 := '*');
TBD
 
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);
TBD
 
DISRUPT_SESSIONS (new 18.1 parameter)
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');

Related Topics
Built-in Functions
Built-in Packages
What's New In 12cR2
What's New In 18cR1

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved