Re: Bug in V$SQl view?

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

View V$SQL is select
"SQL_TEXT","SHARABLE_MEM","PERSISTENT_MEM","RUNTIME_MEM","SORTS","LOADED_VERS ION
S","OPEN_VERSIONS","USERS_OPENING","EXECUTIONS","USERS_EXECUTING","LOADS","FI RST
_LOAD_TIME","INVALIDATIONS","PARSE_CALLS","DISK_READS","BUFFER_GETS","ROWS_PR OCE
SSED","COMMAND_TYPE","OPTIMIZER_MODE","OPTIMIZER_COST","PARSING_USER_ID","PAR SIN
G_SCHEMA_ID","KEPT_VERSIONS","ADDRESS","HASH_VALUE","CHILD_NUMBER","MODULE"," MOD ULE_HASH","ACTION","ACTION_HASH","SERIALIZABLE_ABORTS" from v$sql

View V$SQLAREA is select
"SQL_TEXT","SHARABLE_MEM","PERSISTENT_MEM","RUNTIME_MEM","SORTS","VERSION_COU NT"
,"LOADED_VERSIONS","OPEN_VERSIONS","USERS_OPENING","EXECUTIONS","USERS_EXECUT ING
","LOADS","FIRST_LOAD_TIME","INVALIDATIONS","PARSE_CALLS","DISK_READS","BUFFE R_G
ETS","ROWS_PROCESSED","COMMAND_TYPE","OPTIMIZER_MODE","PARSING_USER_ID","PARS ING
_SCHEMA_ID","KEPT_VERSIONS","ADDRESS","HASH_VALUE","MODULE","MODULE_HASH","AC TIO N","ACTION_HASH","SERIALIZABLE_ABORTS" from v$sqlarea

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

In article <362eedfd.7030016_at_news2.axs2000.net>,   chuckh_at_safeaccess.net (Chuck Hamilton) wrote:
> Is there a bug in the V$SQL view in version 7.3.2.3.10?
>
> Yesterday I ran the following query displaying session and sql info:
>
> select a.username, a.sid, b.sql_text
> from a.v$session, b.v$sql
> where a.sql_address = b.address
> and sid = 14;
>
> I consistently got more than 1 lines returned. When I changed v$sql to
> v$sqlarea, I only got one.
> --
> Chuck Hamilton
> chuckh_at_safeaccess.net
>
> If at first you don't succeed, sky diving isn't for you.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 21 1998 - 15:53:34 CDT