OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SID info

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SID info [message #374716]

Tue, 26 June 2001 07:11

Robert
Messages: 43
Registered: August 2000

Member

Is there any table or command from SQL where you can get the Database SID. I have looked at the Database ID from v$database but this ins't it.

Does anybody know ?

Report message to a moderator

Re: SID info [message #374718 is a reply to message #374716]

Tue, 26 June 2001 08:09

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi

v$instance

Report message to a moderator

Re: SID info [message #374719 is a reply to message #374716]

Tue, 26 June 2001 08:12

venkatesh
Messages: 72
Registered: August 2000

Member

Check out of for instance_name in v$instance...

Report message to a moderator

Re: SID info [message #374720 is a reply to message #374719]

Tue, 26 June 2001 08:13

Rob
Messages: 70
Registered: January 2000

Member

That's brilliant, Cheers.

Report message to a moderator

Re: SID info [message #374721 is a reply to message #374718]

Tue, 26 June 2001 08:44

Rob
Messages: 70
Registered: January 2000

Member

Thats Brilliant, Thanks.

Report message to a moderator

Previous Topic:	Using column defaults for 'Not Null' columns
Next Topic:	URGENT : Spooling to a datetime stamp file in MS DOS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 04:10:21 CDT 2024