Oracle DBMS_DISRUPT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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
     
     
     
Documented No
Exceptions
Error Code Reason
   
First Available 12.2.0.1
Security Model Owned by SYS with ? granted to ???
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);
TBD
 
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;
TBD

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