oracle

1LISTENER=
2  (DESCRIPTION=
3    (ADDRESS_LIST=
4      (ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
5      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
6SID_LIST_LISTENER=
7  (SID_LIST=
8    (SID_DESC=
9      (GLOBAL_DBNAME=sales.us.example.com)
10      (ORACLE_HOME=/oracle11g)
11      (SID_NAME=sales))
12    (SID_DESC=
13      (SID_NAME=plsextproc)
14      (ORACLE_HOME=/oracle11g)
15      (PROGRAM=extproc)))
16

1SQL>select group#, members, sequence#, bytes/1024/1024, status from v$log;