amitzilblog

#!/bin/bash

t=30
if [ -n "$1" ]; then
        t=$1
fi
first=$(sqlplus -s / as sysdba << EOF
        set pages 0 lines 1000 echo off
        select sum(sequence#),sum(block#) from v\$managed_standby where process='RFS';
        exit

amitzilblog

#!/usr/bin/python

import re
import os
import os.path
from datetime import datetime

# get and open the listener log
lsnr_stat = os.popen("lsnrctl status").read().rstrip()
lsnr_log_line_search = re.search(r'Listener Log File.*$', lsnr_stat, re.M|re.I)