CURRENT_OBJ# -1 in v$active_session_history [message #573807] |
Thu, 03 January 2013 05:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2a596f07cb5d3274d7a7751d230c306c?s=64&d=mm&r=g) |
tom_watson
Messages: 8 Registered: January 2013
|
Junior Member |
|
|
Hi,
I am currently querying v$active_session_history as I want to get a wait count for "db file sequential read" waits per object. However, when I run the query below, the largest number of waits are for CURRENT_OBJ# equal to "-1". Does anyone know what object this refers to (querying dba_objects for -1 returns no rows) and I haven't had any luck googling..
Query
select current_obj#, count(*) cnt
from v$active_session_history
where event = 'db file sequential read'
group by current_obj#
Thanks,
Tom.
|
|
|
|
|
|
|
|
|
|
|