how to find out user name from session#

We are running Oracle application on Oracle 8. Most of user login as apps. I run select from v$session can find out sid, seriral#, but I don't know how to link to fnd_user table to find out the persons login name.

Could anyone tell me? Thanks

Howard

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!