Home » RDBMS Server » Performance Tuning » OracleSid
OracleSid [message #65796] Sun, 26 December 2004 18:56 Go to next message
Vikram Mohta
Messages: 1
Registered: December 2004
Junior Member
From which data dictionary view i can get OracleSid name?
Re: OracleSid [message #65798 is a reply to message #65796] Mon, 27 December 2004 09:35 Go to previous messageGo to next message
Alan
Messages: 68
Registered: October 1999
Member
hi
from the sql propmt type show parameter db_name
this will give you the sid.

cheers

alan
Re: OracleSid [message #65799 is a reply to message #65798] Tue, 28 December 2004 00:20 Go to previous message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi,

You can also query V$instance for getting the name of the instance.

Regards

Milind.
Previous Topic: what is the main use of Pmon
Next Topic: URGENT:-Performance
Goto Forum:
  


Current Time: Wed Sep 23 13:49:19 CDT 2020