sqlplus
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
- Date: Tue, 06 Oct 2009 11:20:05 -0400
Hi List,
I have a shell script report the following output for my daily check
routine. I found the SQL> SQL> SQL> is very annoying, is it possible to
get rid off the "lines from coonected to:" to 2 3 4...13" ?
Thanks,
Joan
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7
8 9 10 11 12 13
Thread LastSeqApp1stti Last Sequence Applied LastSeqRec1stti Last
Sequence Received DiffSeq DiffMins
---------- --------------- --------------------- ---------------
---------------------- ---------- ----------
1 06-OCT-09 1428 06-OCT-09
1428 0 0
SQL> SQL> SQL> 2
CURRENT_LOG_GAP
---------------
0
SQL> SQL> 2 3 4
PROCESS SEQUENCE# STATUS
--------------------------- ---------- ------------------------------------
ARCH 1426 CLOSING
ARCH 1427 CLOSING
ARCH 1428 CLOSING
RFS 1429 IDLE
MRP0 1429 APPLYING_LOG
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
--
http://www.freelists.org/webpage/oracle-l
Other related posts: