OraFAQ Forum: Performance Tuning

Sun, 26 December 2004 18:56

Vikram Mohta
Messages: 1
Registered: December 2004

Junior Member

From which data dictionary view i can get OracleSid name?

Mon, 27 December 2004 09:35

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

Tue, 28 December 2004 00:20

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: Thu Apr 02 23:59:59 CDT 2026