Re: sqlplus
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: joan.hsieh@xxxxxxxxx
- Date: Tue, 6 Oct 2009 10:24:06 -0500
This is a quick stab:1. "sqlplus -s" should keep the banner from coming out
2. set feedback off
3. set echo off
I may be missing one or two.
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Tue, Oct 6, 2009 at 10:20 AM, Joan Hsieh <joan.hsieh@xxxxxxxxx> wrote:
> 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:
