Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Seeking v$view information

Seeking v$view information

From: Chris Quigley <cquigley_at_liquidaudio.com>
Date: 3 Mar 2001 00:24:56 +0100
Message-ID: <58F50FD70C66D411847C00D0B774C9E9C4D4B1@blondie.liquidaudio.com>

Hello,

How do the v$views handle sql text?
I have read that sql text selected from v$sql is only sql text still in the buffer cache.
Throughout the day, sql text queried from v$sql can jump from 73 selections to 400 selections (ex).
If the buffer can hold 400 sql text statements, why is it that I sometimes can only see 73 sql text statements?
Here is one of my example queries:

select a.sql text
from v$sql a, v$session b, dba users c
where a.parsing user id c.user id AND c.username b.username AND c.username ! 'SYS'
AND c.username ! 'SYSTEM';

Anybody know where I can learn in-depth stuff about v$views? The Oracle documentation disc does not seem to cut it.

Thank You,

Christopher

--
Received on Fri Mar 02 2001 - 17:24:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US