21 lines
462 B
SQL
21 lines
462 B
SQL
SELECT
|
|
obj
|
|
, class
|
|
, decode(state,0,'free',1,'xcur',2,'scur',3,'cr', 4,'read',5,'mrec'
|
|
,6,'irec',7,'write',8,'pi', 9,'memory',10,'mwrite'
|
|
,11,'donated', 12,'protected', 13,'securefile', 14
|
|
,'siop',15,'recckpt', 16, 'flashfree', 17, 'flashcur', 18, 'flashna') state
|
|
, hladdr
|
|
, cr_rfcnt
|
|
, shr_rfcnt
|
|
, fp_whr
|
|
, fp_scn_bas
|
|
, fp_scn_wrp
|
|
FROM
|
|
x$bh
|
|
WHERE
|
|
cr_rfcnt + shr_rfcnt > 0
|
|
AND (&1)
|
|
/
|
|
|