--------------------------------------------------------------------------------
--
-- File name:   rs.sql
-- Purpose:     Display available Redo Strands
--
-- Author:      Tanel Poder
-- Copyright:   (c) http://www.tanelpoder.com
--              
-- Usage:       @rs
--          
-- Other:       Shows both public and private redo strands
--
--------------------------------------------------------------------------------

COL rs_indx HEAD STR# FOR 999

prompt Display available redo strands in the instance (both private and public)...

SELECT 
    indx                            rs_indx,
    first_buf_kcrfa                 firstbufadr,
    last_buf_kcrfa                  lastbufadr,
    pnext_buf_kcrfa_cln             nxtbufadr, 
    next_buf_num_kcrfa_cln          nxtbuf#, 
    strand_header_bno_kcrfa_cln     flushed,
    total_bufs_kcrfa                totbufs#, 
    strand_size_kcrfa               strsz,
    space_kcrf_pvt_strand           strspc,
    bytes_in_buf_kcrfa_cln          "B/buf", 
    pvt_strand_state_kcrfa_cln      state,
    strand_num_ordinal_kcrfa_cln    strand#, 
    ptr_kcrf_pvt_strand             stradr, 
    index_kcrf_pvt_strand           stridx, 
    txn_kcrf_pvt_strand             txn
FROM 
        x$kcrfstrand
/