Oracle 18cR3 DBMS

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	DISRUPT_SESSIONS	DISRUPT_SESSIONS_IMMEDIATE
DISRUPT_SERVICES_CANCEL	DISRUPT_SESSIONS_CANCEL	WAKE_UP_SERVICE
DISRUPT_SERVICES_IMMEDIATE

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');