Re: Dynamic performance (V$) tables.

From: Lange Francois <flange_at_pt.lu>
Date: 1997/09/01
Message-ID: <340A6EA2.675A@pt.lu>#1/1

Maurice Bauhahn wrote:
>
> select table_name from sys.dba_tables;
>
> "Winston Douglas" <wdouglas_at_cott.com> wrote:
>
> >How can I get a listing of all the available dynamic performance (V$)
> >tables. There are some differences between those available in 7.2 and 7.3
> >that I am trying to determine precisely.
> >
> >Regards,
> >
> >Winston Douglas

Hi,

The V$ tables are views the X$ are the real tables.

The X$ and V$ objects are nor shown in the sys.dba_tables nor in the sys.dba_views.

To got all of then run the following scripts.

(
echo "connect internal"
strings $ORACLE_HOME/bin/oracle | sed 's/[^A-Za-z0-9_\$]/ /g' | tr '[a-z] ' '[A-Z]\012' | grep '^[XV]_*\$' | sort -u | while read i do

        j=`echo "$i" | sed 's/^./&_/'`
        echo "create view $j as select * from $i ;"
        echo "create public synonym $i for $j ;"

done
echo "create or replace view v_\$pipes ( name , owner ) as select substr ( kglnaobj , 1 , 40 ) , nvl ( substr ( kglnaown , 1 , 40 ) , 'BLANK' ) from sys.x\$kglob where kglobsta = 1 and kglobtyp = 18 ;" echo "create public synonym v\$pipes for v_\$pipes ;" ) | svrmgrl

This nust work in 7.1 & 7.2 & 7.3

From 7.3 you have got a view call

        V$FIXED_VIEW_DEFINITION where you will find what you are looking for.

Run the scripts on both database version.

Used a database link to compare there definition nor sqlplus spool + diff.

Regards Francois LANGE.
flange_at_pt.lu Received on Mon Sep 01 1997 - 00:00:00 CDT