The GV$ views stand for GLOBAL if I'm not mistaking and are only useful if
you're running Oracle Parallel Server (and probably still for Oracle 9i
RAC).
Hence, INST_ID stands for instance id (you can define your instance id in
the init.ora).
Querying V$ views in OPS will reveal info about the instance you're logged
on - querying
the GV$ will reveal the same info but for each instance participating in the
cluster.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3b8cf059$0$233$ed9e5944_at_reading.news.pipex.net...
> If you look at the view definitions you will find that they *are*
different,
> specifically they all include a column INST_ID. Having a think about what
> this column could be will give you the clue as to the difference.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message
> news:ntqpotk581r2pna33a9qlbefva1hb87llf_at_4ax.com...
> > Dear all,
> >
> > There are many dynamic views which starts both with GV$ and V$ and
> > look the same. The books only mention those with V$, why are there
> > also GV$? Thanks in advance.
> >
> > Dino
> >
>
>
Received on Wed Aug 29 2001 - 12:21:29 CDT
