sqlplus

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: