My Oracle Support Banner

How to Send Message to all Windows Connected Users to Logoff the Database (Doc ID 137112.1)

Last updated on OCTOBER 10, 2023

Applies to:

SQL*Plus - Version 8.0.6.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Microsoft Windows (32-bit)
Microsoft Windows (32-bit) - OS Version: 7
Microsoft Windows x64 (64-bit) - OS Version: 7
Microsoft Windows x64 (64-bit)
This is for Administrators running Oracle Database, 8.x and higher, on Microsoft Windows.

Goal

In a lot of cases you need to send a message to all connected users of the database to logoff for maintenance reasons.

How to send message to all Windows connected users to logoff the Database?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.