Re: Bug in V$SQl view?

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sat, 24 Oct 1998 12:18:52 +0800
Message-ID: <3631552C.B63408EA@hk.super.net>

Same as Satar commented. V$SQLAREA is a dynamic performance view for memory statistics of SQL statements which remain in shared pool currently. On the other hand,
entries of V$SQL like something called history log which records SQL statements parsed by Oracle and other information about the SQL statement.

satar_at_my-dejanews.com wrote:

> I did a select count(*) on v$sql and v$sqlarea, with two different results. I
> think its due to our lack of understanding of these two views/tables that
> results in different results. Here is what I know...<not much>:
> V$SQl not listed in my Oracle& Server SQL Language Quick Reference
> V$SQLAREA Statistics on the shared cursor cache

> Maybe it's because V$SQLAREA is shared cursors, and V$SQl is not? Anyone that
> can add to this discussion, please do.
>
> Satar Naghshineh
>

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 23 1998 - 23:18:52 CDT