Oracle DBMS_DISRUPT
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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 18cR3

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