Mike,

I do use the ops, but no RAC.

--- Mike Ault <[Email Address Removed] wrote:
> If you aren't using Oracle Parallel Server or Real
> Application Clusters then
> the GV views should give the same information as the
> V$ views only they will
> show an instance number of 1 and no other instances.
> If you have not
> purchased the cluster manager software for your
> system, and, haven't
> installed the OPS or RAC version for Oracle then the
> GV views will not be
> popoulated for any other instance other than the
> current one.
>
> Mike
>
> -----Original Message-----
> From: Gene Gurevich
> [mailto:[Email Address Removed] Sent: Friday, November 30, 2001 12:23 PM
> To: [Email Address Removed] 'LazyDBA.com Discussion'
> Subject: RE: oracle hangs, but why?
>
>
> Mike,
>
> I thought that the GV$ views have the info on all
> instances, while the V$ views only have the local
> info. What happens to me is that if I run a query
> against the GV$ views, it hangs, when I ran the same
> query against the V$ views it runs fine on all
> nodes.
>
> Based on your reply, does this imply some kind of
> inter-node communication? Is there a way for me to
> check that?
>
> thanks
> --- Mike Ault <[Email Address Removed] wrote:
> > The V$ "tables" are actually specialized views of
> > the GV$ tables...shouldn't
> > be having problems unless they can't get the
> > information from your other
> > instance. You should only use the GV$ views if you
> > have OPS or RAC.
> >
> > Mike
> > -----Original Message-----
> > From: Gene Gurevich
> > [mailto:[Email Address Removed] > Sent: Friday, November 30, 2001 12:14 PM
> > To: LazyDBA.com Discussion
> > Subject: oracle hangs, but why?
> >
> >
> > Hi.
> >
> > I'm running oracle 8172 on AIX SP 4.3.3 in ops
> mode
> > on
> >
> > 4 nodes. I have noticed that the queries that are
> > trying to read the GV$ tables are hanging, while
> > those using the V$ tables don't. I have looked at
> > the locks/waits on each node, but didn't see
> > anything
> > unusual (or may be I missed). What/where should I
> be
> > looking to figure out what is going on? Thanks for
> > any
> > input
> >
> >
> >
> > =====
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site
> hosting,
> > just $8.95/month.
> > http://geocities.yahoo.com/ps/info1
> >
> > --------
> > Oracle documentation is here:
> >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > oracledba-[Email Address Removed] > To subscribe: send a blank email to
> > oracledba-[Email Address Removed] > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
>
>
> =====
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting,
> just $8.95/month.
> http://geocities.yahoo.com/ps/info1
>


=====


__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
Oracle LazyDBA home page