Re: sqlplus

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 6 Oct 2009 10:24:06 -0500
Message-ID: <e9569ef30910060824jfb75edq3bb39dc4cbf3255e_at_mail.gmail.com>

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_at_tufts.edu> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Oct 06 2009 - 10:24:06 CDT