v$ tables are really useful for finding out information about your database.
For example:
v$session holds information about all open database sessions - try this:
select osuser from v$session - you'll see a list of all users Operating
System Ids who are currently connected to Oracle (not their Oracle account).
v$sga holds information about the System Global Area (how much memory your
Oracle instance is running with)
v$sql holds actual SQL statements currently stored in the SGA
v$instance holds information about the Oracle instance itself - which
machine, version, status etc.
--
Jim Harrison
Colway Software and Design
www.freeserve.co.uk
Received on Mon Apr 24 2000 - 00:00:00 CDT
