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

On Thu, 16 May 2002 13:27:09 GMT,
u705413818_at_spawnkill.ip-mobilphone.net (Joe Bayer) wrote:

>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.
>
>
>

The link between v$sqlarea and v$session is sql_address and sql_hash_value. Serial# is a *numeric* column, not a string. *Background* processes usually don't have a sql_address and a sql_hash_value.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 16 2002 - 10:37:17 CDT