Re: own session's SID

> Probably more efficient for the user to
> call sys_context than it would be to call
> a home-grown pl/sql function. (Not guaranteed,
> of course, as sys_context() is resolved in pl/sql
> through a select from dual).

And even worse, a select from sys.dual, so you can't use your custom dual synonym or view in current schema for getting efficient dual...

Tanel.

--
http://www.freelists.org/webpage/oracle-l