Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to reset the userenv('SESSIONID')
Hello,
I use the userenv('SESSIONID') string to create dynamic tables and
indexes as part of their names.
Some times i got a 7 digits number and other times a 4 digit number.
The userenv('SESSIONID') function returns the sys.v$session.AUDSID
value.
In my Oracle 7.3.3 instance on Solaris in don't enable the Audit.
This number increases at least with every connect to the database.
It doesn't reset after database shutdow.
Is it possible to reset it?
Received on Thu Aug 14 1997 - 00:00:00 CDT
![]() |
![]() |