Oracle DBMS_DISRUPT
Version 12.2.0.1

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/or services
AUTHID CURRENT_USER
Constants
Name Data Type Value
all_modules VARCHAR2(2) '*'
all_modules VARCHAR2(2) '*'
all_services VARCHAR2(2) '*'
Dependencies
DBMS_SCHEDULER_JOBS DBMS_SCHEDULER PLITBLM
DBMS_ASSERT DBMS_SERVICE UTL_FILE
DBMS_OUTPUT DBMS_STANDARD V$INSTANCE
DBMS_RANDOM DUAL  
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 (new 12.2)
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 (new 12.2)
Undocumented dbms_disrupt.disrupt_services_cancel(job_name IN VARCHAR2 := '*');
TBD
 
DISRUPT_SERVICES_IMMEDIATE (new 12.2)
Undocumented dbms_disrupt.disrupt_services_immediate(
job_name       IN VARCHAR2,
service_names  IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := NULL,
stop_interval  IN NUMBER,
percentage     IN NUMBER,
output_file    IN VARCHAR2 := NULL);
TBD
 
DISRUPT_SESSIONS (new 12.2)
Undocumented dbms_disrupt.disrupt_sessions(
job_name       IN VARCHAR2,
service_names  IN VARCHAR2,
instance_names IN VARCHAR2,
percentage     IN NUMBER,
sleep_interval IN NUMBER,
stop_interval  IN NUMBER,
duration       IN NUMBER,
output_file    IN VARCHAR2);
TBD
 
DISRUPT_SESSIONS_CANCEL (new 12.2)
Undocumented dbms_disrupt.disrupt_sessions_cancel(job_name IN VARCHAR2);
exec dbms_disrupt.disrupt_sessions_cancel('UWSESSJOB');
 
DISRUPT_SESSIONS_IMMEDIATE (new 12.2)
Undocumented dbms_disrupt.disrupt_sessions_immediate(
job_name       IN VARCHAR2,
service_names  IN VARCHAR2 := '*',
instance_names IN VARCHAR2 := NULL,
module_names   IN VARCHAR2 := '*',
percentage     IN NUMBER,
output_file    IN VARCHAR2 :=NULL);
TBD
 
WAKE_UP_SERVICE (new 12.2)
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 12cR1
What's New In 12cR2

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