ORA-00029: session is not a user session

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
alpeshviranik
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm
Contact:

ORA-00029: session is not a user session

Postby alpeshviranik » Fri Aug 15, 2014 9:41 pm

i am getting below error in Oracle. i think my session id is right. how i can check it?
ORA-00029: session is not a user session


Guest

Re: ORA-00029: session is not a user session

Postby Guest » Fri Aug 15, 2014 9:58 pm

ORA-00029: session is not a user session
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user session (for example, recursive, etc.).
Action: Retry with a user session ID.

killing a session with the alter system command and you did specify a correct sid and serial number.
The session is not a user session, in this case it will be a background session:

you can check user session or background session by below query:

Code: Select all

SQL> select sid, serial#, process,  type from v$session;

   SID    SERIAL#    PROCESS                  TYPE
   ---- ---------- ------------------------   ----------
         1          1       1452                     BACKGROUND
         2          1       3214                     BACKGROUND
         3          1       2314                     BACKGROUND
         4          1       9871                     USER


If you want to kill a background session, which is discouraged. I think you need to kill the process at operating system level.


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest