Skip to content
This repository has been archived by the owner on May 16, 2020. It is now read-only.

client identifier api is not working for some of the names #92

Open
shamis opened this issue Jun 28, 2019 · 1 comment
Open

client identifier api is not working for some of the names #92

shamis opened this issue Jun 28, 2019 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@shamis
Copy link
Member

shamis commented Jun 28, 2019

for example MecIC63_BILL11_prod fails to be set as client identifier.
but its working for MecIC63_BILL12_prod

@shamis shamis added the bug Something isn't working label Jun 28, 2019
@c-bik c-bik self-assigned this Jul 1, 2019
@c-bik
Copy link
Member

c-bik commented Aug 22, 2019

To get the conection name list...

select s.sid, s.serial#, s.username, s.machine, s.program, s.CLIENT_IDENTIFIER
from gv$session s 
join gv$process p on p.addr = s.paddr 
    and p.inst_id = s.inst_id 
    where s.type != 'BACKGROUND' 
order by 3,4,5

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants