Re: How to find SID

From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Thu, 1 Nov 2001 13:08:16 -0500
Message-ID: <lcgE7.5$Fk3.9157@news.nyc.globix.net>

SELECT *
FROM global_name;

SELECT *
from V$INSTANCE;

HTH,
Vladimir
"Nasir" <nmajeed_at_prosrm.com> wrote in message news:3be1628d$0$13458$39cecf19_at_nnrp1.twtelecom.net...
> Is there a way to query Oracle server to find out SID for the instance ?
>
> Thanks,
> Nasir
> nmajeed_at_prosrm.com
>
>
>
Received on Thu Nov 01 2001 - 12:08:16 CST

This message: [ Message body ]
Next message: Vladimir Ivanovich: "Re: Compact Oracle Database (Shrink it using SQL Plus)"
Previous message: Bliss: "Can in anyway use LEAST () with a null value???"
In reply to: Nasir: "How to find SID"
Next in thread: Nasir: "Re: How to find SID"
Reply: Nasir: "Re: How to find SID"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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