Re: v$sysstat

From: Yong Huang <yhuang_at_indigopool.com>
Date: Wed, 13 Sep 2000 16:57:25 -0500
Message-ID: <8pote6$fu9$1@news.sinet.slb.com>

http://technet.oracle.com/doc/oracle8i_816/server.816/a76961/apc2.htm says it's the sum of "db block gets" plus "consistent gets", described above (above on that same page). Look it up.

If you mean how this view is defined, here it is:

SQL> select * from v$fixed_view_definition where view_name = 'V$SYSSTAT';

VIEW_NAME

---

VIEW_DEFINITION

---

---

V$SYSSTAT
select STATISTIC# , NAME , CLASS , VALUE from GV$SYSSTAT where inst_id = USERENV('Instance')

SQL> select * from v$fixed_view_definition where view_name = 'GV$SYSSTAT';

VIEW_NAME

---

VIEW_DEFINITION

---

---

GV$SYSSTAT
select inst_id,indx,ksusdnam,ksusdcls,ksusgstv from x$ksusgsta

I have no idea what ksusgsta means. Probably something like kernel service unknown (by me) system global statistics.

Yong Huang
yhuang_at_indigopool.com

Ray Stell <stellr_at_stell.cns.vt.edu> wrote in message news:8poi3s$lln$1_at_solaris.cc.vt.edu...
> I'd like to quantify the load that lookups put on a server.
> What is the definition of the column, session logical reads
> in v$sysstat version 7.3.4? Is there a better stat to use?
>
> for that matter, where are all the v$ and x$ columns defined?
>
> thanks.
Received on Wed Sep 13 2000 - 16:57:25 CDT