sql> select type, high_scn, status from v$logstdby;
type high_scn status
------------ ---------- --------------------------------------------------
coordinator ora-16115: loading log miner dictionary data
reader ora-16127: stalled waiting for additional transact
ions to be applied
builder ora-16117: processing
preparer ora-16116: no work available
sql> select type, high_scn, status from v$logstdby;
type high_scn status
------------ ---------- --------------------------------------------------
coordinator ora-16126: loading table or sequence object number
reader ora-16116: no work available
builder ora-16116: no work available
preparer ora-16116: no work available