Re: application connection

Yes there is a way out.When the application user logs in the session id and the serial# can be captured and can be stored in some table called the user master or something .In a typical locking suitation the sid of the user who is locked can be captured using utilities like uttlockt.sql found in $ORACLE_HOME/admin directory. Once the sid is found the user can be easily for additional details or scripts email a inswin.training3_at_burton.co.uk Bye
Sanjay Mathew

Laslop Hans <Laslop_at_t-online.de> wrote in article <56qjme$sg8_at_news00.btx.dtag.de>...
> 'Hello world'
>
> who can help me... I'm connecting all users of an application with the
 same
> database user to an oracle 7.x. No I can't see which user connection I
 have
> to terminate when there is a problem e.g. with locks...
>
> ? Is there a possibility to display a description for a session...
> ? ...or can I display a connection-id in the application..
> ? ...or is there a easy way to create db-users witch have the same
> data availabe like the application connection
>
> any help / ideas are welcome
>
> TIA
>
> Hans Laslop
> ======= ====== ===== ===
> = = eMail: Laslop_at_T-Online.de
> ======= ====== ===== ===
>
  Received on Fri Nov 22 1996 - 00:00:00 CET