help: sql_hash_value=00 and sql

From: Joe Bayer <u705413818_at_spawnkill.ip-mobilphone.net>
Date: Thu, 16 May 2002 13:27:09 GMT
Message-ID: <l.1021555629.1600860595@[64.94.198.252]>

I was trying

select sql_text from v$sqlarea q, v$session s Where q.address = s.sql_address and s.sid = 34 and s.serial# = '5252'

but got no result.

Further investigate the v$session, I found quite some has sql_address=0 and hash_value = 00, what does that suppose to mean? Can I get the sql statement for that sid?

SID SQL_ADDR SQL_HASH_VALUE
--------- -------- --------------

        1 00                    0
        2 00                    0
        3 00                    0
        4 00                    0
        5 907B8C78     1714733582
        6 907F6278      189272129
        7 90A3C344     4060635985
        8 90AE326C       88643110
        9 00                    0
       13 90567148     1947261727
       16 00                    0
       26 00                    0
       34 00                    0
       39 00                    0
       43 904E2154     2419559955
       45 00                    0
       50 909BF854      795820095
       52 90A669C0     4097685491
       53 909B3CAC     3045462467
       59 00                    0

Thanks for your help.

-- 
Sent by joebayerii from  hotmail in field com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Thu May 16 2002 - 08:27:09 CDT

help: sql_hash_value=00 and sql_address=0, why?