Re: temporary sessionID???

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 16 Jun 2004 08:06:12 +1000
Message-ID: <40cf72bb$0$641$afc38c87@news.optusnet.com.au>

"Alan" <wangxianlg_at_yahoo.com> wrote in message news:18a6fc2f.0406151241.7ff6f05e_at_posting.google.com...
> Recently we moved a application from Unify database into Oracle. In
> the application it uses temporary sessionID from Unify database. I'm
> just wondering if there is a such thing in Oracle.
>
> Thanks
>
> Alan

Dunno. What did the code use it for? How "temporary" is "temporary"? And would the code get upset if it wasn't quite as temporary as the half-life of Einsteinium?

If you select sid, serial# from V$SESSION, you will see that each user gets a unique combination of those two values every time they log on (assuming they really are logging on to the database and not going via some application server). You can match that up to unique numbers assigned as process ID's in V$PROCESS, too, though it requires you know your saddr from your paddr.

Whether that's what you're after, though, rather depends on what your code wants to do with the information.

Regards
HJR Received on Tue Jun 15 2004 - 17:06:12 CDT