Xref: alice comp.databases.oracle.server:33525
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!master.news.rcn.net!not-for-mail
From: "Kenneth Randell" <kenr@datametrics.com>
Newsgroups: comp.databases.oracle.server
Subject: definitions for v$sysstat entries
Date: Wed, 11 Nov 1998 11:49:15 -0500
Lines: 17
Message-ID: <72cf84$58u$1@autumn.news.rcn.net>
X-Trace: YoWnpZ7QSf30l149tN8IrEulS/gi8Ti6ncWaRNrHyOw=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 11 Nov 1998 16:50:12 GMT
X-MimeOLE:  Produced By Microsoft MimeOLE V4.72.2106.4
X-Newsreader:  Microsoft Outlook Express 4.72.2106.4

Hi --

I am new at this DBA thing, having taken over for someone else.  I see in
the Administrator Guide for Oracle7 there are various statistics available
in the table v$sysstat.  I looked at them, and two of them -- 'session
connect time' (#13) and 'process last non-idle time' (#14) seem to vary
wildly (from +4.0e09 to -1.6e09) in a matter of seconds, each time a new
session is started.  Am I missing something, or is there someplace that
these statistics are documented???  I have looked at the Oracle7 Server
Administrator's Guide without much luck.

Thanx in advance.

Ken Randell
Datametrics, Inc.