Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to reset the userenv('SESSIONID')

How to reset the userenv('SESSIONID')

From: MORDI <mordi_at_rts.co.il>
Date: 1997/08/14
Message-ID: <33F33EDA.46FD@rts.co.il>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US