I am trying to find an environment variable that returns the current
session's SID. I see things like ora_login_user but can't find anything SID
related. Basically I want to take a statspack snapshot using the SID of the
current session. - E
-
>cc:
Sent by: Subject: SID Environment Variable
[EMAIL PROTECTED]
cc:
Sent by: Subject: SID Environment
Variable
[EMAIL PROTECTED]
om
10/02/01 11:25
AM
Please respond
Ethan,
I'm not sure what you mean by SID.
Do you mean an environmental like ORACLE_SID?
On NT, this does not exist unless you create it by
issuing 'set oracle_sid=prod'.
Similiar thing on Unix, I think.
Internally (in Oracle), you can check things like v$database, v$instance,
even v$thread
so should i manually set the SID environment variable ??
if so how ? if set it manually then it is good for that shell
only. what about programs like Database config assistant that are
lauched via the Start>>Programs>>OraHome. how would they read
this or such an enviroment vari
hecked, via set command on windows NT. the env variable for
SID is not set. though there are other oracle related env variables
like path, classpath that point to various files of oracle install
etc
so should i manually set the SID environment variable ??
if so how ? if set it manually then it i