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] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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

Oracle LazyDBA home page