Re: Question about Oracle9i v$ tables

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 29 Jun 2001 04:49:14 -0700
Message-ID: <9hhpvq0jjm@drn.newsguy.com>

In article <ccqnjt0emaskh7679skptkmbqumfa1r9jt_at_4ax.com>, Kev says...
>
>Hello All,
>
>I have a program that I have been developing that uses the v$ tables
>to get performance data from the Oracle 8 & 8i database.
>
>The tables that are in question are:
>
>V$DATAFILE
>V$FILESTAT
>v$log
>v$sysstat
>
>Do you know if any of these tables have been changed or modified in
>Oracle 9i where it might break the current application?
>
>Thanks,
>
>Kev

v$datafile has 2 more columns

BLOCK1_OFFSET NUMBER The offset from the beginning of the file to where the Oracle generic information begins. The exact length of the file can be computed as follows: BYTES+BLOCK1_OFFSET.

AUX_NAME VARCHAR2(513) The auxiliary name that has been set for this file via CONFIGURE AUXNAME And v$sysstat has 50 some odd more rows.

new stats:

NAME

---

DBWR fusion writes
OS All other sleep time
OS Chars read and written
OS Data page fault sleep time
OS Input blocks
OS Involuntary context switches
OS Kernel page fault sleep time
OS Major page faults
OS Messages received
OS Messages sent
OS Minor page faults
OS Other system trap CPU time
OS Output blocks
OS Process heap size
OS Process stack size
OS Signals received
OS Swaps
OS System call CPU time
OS System calls
OS Text page fault sleep time
OS User level CPU time
OS User lock wait sleep time
OS Voluntary context switches
OS Wait-cpu (latency) time
consistent gets - examination
dlm non-pcm messages sent
dlm pcm messages sent
global cache blocks lost
global cache claim blocks lost
global cache cr block build time
global cache cr block flush time
global cache current block flush time
global cache current block pin time
global cache current block receive time
global cache current block send time
global cache current blocks received
global cache current blocks served
global cache skip prepare failures
parse count (failures)
physical reads direct (lob)
physical writes direct (lob)

prefetch clients - 16k
prefetch clients - 2k
prefetch clients - 32k
prefetch clients - 4k
prefetch clients - 8k
prefetch clients - default
prefetch clients - keep
prefetch clients - recycle

shared hash latch gets
shared hash latch upgrades - no wait
shared hash latch upgrades - wait
table lookup prefetch client count
total number of slots

workarea executions - multipass
workarea executions - onepass
workarea executions - optimal

workarea memory allocated

58 rows selected.

Retired stats:

NAME

---

global cache cr block log flush time
global cache cr block log flushes
global cache cr block serve time
global cache cr requests blocked
global cache cr timeouts

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 

Received on Fri Jun 29 2001 - 06:49:14 CDT