Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Session doesn't die with ALTER SYSTEM KILL SESSION — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Session doesn't die with ALTER SYSTEM KILL SESSION

Received Response
3
Views
2
Comments
edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary:

I'm trying to kill a session with ALTER SYSTEM KILL SESSION '<SID>,<Serial#>'; as the Administrator user.

When execute the ALTER SYSTEM KILL SESSION, I see:

System KILL altered.

But when I query V$SESSION, the session status is still ACTIVE.

I've also tried

ALTER SYSTEM DISCONNECT SESSION '<SID>,<Serial#>' IMMEDIATE; as the Administrator user, but when I do, I get:

Error starting at line : 24 in command -

ALTER SYSTEM DISCONNECT SESSION '48333,52001' IMMEDIATE

Error report -

ORA-01031: insufficient privileges

01031. 00000 - "insufficient privileges"

*Cause:  An attempt was made to perform a database operation without

      the necessary privileges.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!