How check shared memory connection vs remote session ?

[grunnpi]

Hi there,

I'm making some test in order to compare remote connect statement vs shared memory connection for some appserver process running on database server.
Even if my connect string statement seems different, I'm not sure my update worked.

Once process running and connected, is there a way to check (maybe on db level, ie using promon) to check connected client ?

Thanks for helping

Cheers,
Grunnpi.

 

[TomBascom]

find _myconnection no-lock.
find _connect no-lock where _connect._connect-id = _myconnection._myconn-userid + 1.
display
  _connect-id
  _connect-usr
  _connect-name
  _connect-type
.

 

[grunnpi]

Perfect !
Thank you very much Tom.