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

--
//www.freelists.org/webpage/oracle-l


Other related posts: