where P.pid = '123160'

should be

where P.spid = 123160

v$process shows server process

v$session shows user process or logon sessions