Home » RDBMS Server » Server Administration » Blank username in v$session , How to find who is connecting (Oracle 11.2.0.4)
() 1 Vote
Blank username in v$session , How to find who is connecting [message #678006] |
Wed, 30 October 2019 09:12 |
|
Akmmhto
Messages: 38 Registered: September 2018
|
Member |
|
|
Dear team,
In QA DB server , Today I got ORA-00020
Check and found too many active sessions from v$session.
The question is that the username column is blank.
Program - JDBC Thin Client
OSUSER - pqadmn
Since our sys and system users are in locked state.
Hence I am unable to find the real culprit.
Audit trail is not showing any login information and only filled with ora-01017
Attaching some logs
|
|
|
|
|
Blank username in v$session , How to find who is connecting
By: Akmmhto on Wed, 30 October 2019 09:12
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
By: Akmmhto on Sat, 09 November 2019 02:34
|
|
|
Re: Blank username in v$session , How to find who is connecting
By: Akmmhto on Sat, 09 November 2019 02:38
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
By: Akmmhto on Sat, 09 November 2019 03:16
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
By: Akmmhto on Sat, 09 November 2019 04:08
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
|
|
Re: Blank username in v$session , How to find who is connecting
By: Akmmhto on Wed, 30 October 2019 14:24
|
|
|
Re: Blank username in v$session , How to find who is connecting
|
Goto Forum:
Current Time: Sat Apr 20 06:39:37 CDT 2024
|