Oracle | DBMS

Oracle DBMS_DISRUPT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Application Resilience API 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

DBA_SCHEDULER_JOBS	DBMS_SERVICE	PLITBLM
DBMS_ASSERT	DBMS_STANDARD	UTL_FILE
DBMS_RANDOM	DUAL	V$INSTANCE
DBMS_SCHEDULER

Documented No

First Available 12.2

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

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