RE: New Dynamic Views

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 01 Feb 2001 05:50:26 -0800
Message-ID: <F001.002A71DE.20010201052025@fatcity.com>

Chandini

Straight from the 8I Refernce guide page 346 - I couldn't explain it better myself :) Well done Oracle..

--Snip--

GV$ Views

For almost every V$ view described in this chapter, Oracle has a corresponding GV$
(global V$) view. In a parallel server environment, querying a GV$ view retrieves
the V$ view information from all qualified instances. In addition to the V$ information, each GV$ view contains an extra column named INST_ID of datatype INTEGER. The INST_ID column displays the instance number from which the associated V$ view information was obtained. The INST_ID column can be used
as a filter to retrieve V$ information from a subset of available instances. For
example, the query:

SELECT * FROM GV$LOCK WHERE INST_ID = 2 OR INST_ID = 5 retrieves the information from the V$ views on instances 2 and 5.

In order to query the GV$ views, the value of the PARALLEL_MAX_SERVERS parameter must be greater than zero on all instances mounting the database. The sections that follow list the columns and public synonyms for the dynamic
performance views.
--snip--

HTH Mark

-----Original Message-----

Paterson
Sent: Thursday, February 01, 2001 12:31
To: Multiple recipients of list ORACLE-L

Hi,
  I was just looking at the data dictionary (dict table) and came upon a whole list of views that have similar names to the dynamic views (V$), but all start with GV$.
  EG:- GV$DLM_LOCKS
        GV$LOCK
   etc.

There almost seems to be one GV$ view for each V$ view. Would somebody tell me what these views are and why they are used. Oh, I am on ver 8.1.5 by the way.

Thanks a lot
Chandini Paterson

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Chandini Paterson
INET: chandini.paterson_at_morse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

RE: New Dynamic Views - GV$ ???