Re: SQLl _at_ command

I am working on a project which includes GoldenGate. The client wanted to see how fast can GG deliver large amount of records. I pushed 10M records on one side and was using "repeat" in SQLCl to count the rows every 10 seconds, 50 times. I am very pleased with both GG and SQLCl. The "repeat" command is by far the best thing ever. Wait...there is also sqlformat ansiconsole and then there is tnsping and "which". And there is DDL to reconstruct the DDL....Let me rephrase that: "repeat" is the best thing in sqlcl except for the other fabulous things that sqlplus cannot do. There! Hopefully everybody will be happy now.BTW, since Bobby Curtis is here, I noticed that the transfer is faster if RMTTRAIL is added directly to the database extract, without data pump process.
On Wed, 2020-08-26 at 13:37 -0700, Jeff Smith wrote:
> End of day, I’m happy to hear that sqlcl is being used and helping
> people do good things.
>
> I’m testing the fix now reported from some folks online about
> excessive line breaks/blank lines in output, and we’re working on a
> FASTER, native compiled sqlcl that will eliminate any ‘java tax’ when
> it comes to startups.
>
> Keep up the feedback, we’re gonna keep building.
>
> From: Mladen Gogala <gogala.mladen_at_gmail.com>
> Sent: Wednesday, August 26, 2020 4:27 PM
> To: Martin Berger <martin.a.berger_at_gmail.com>; Jack Applewhite <
> jack.applewhite_at_austinisd.org>
> Cc: Jeff Smith <jeff.d.smith_at_oracle.com>; franck_at_pachot.net; Oracle-L
> oracle-l <oracle-l_at_freelists.org>
> Subject: Re: SQLl _at_ command
>
> I agree. I misreported the problem. I am using Oracle 12.2 and have
> downloaded SQLCl 20.2 but forgot to put $HOME/sqlcl/bin into the
> PATH. The problem was with Oracle 12.2 version of SQLCl, not with
> 20.2. I humbly apologize for the confusion.
>
> On Wed, 2020-08-26 at 22:11 +0200, Martin Berger wrote:
> > Jack,
> >
> > please download & use latest 20.x SQLcl.
> > I saw similar issues with pre 20.x Versions, but my
> > observation with 20.x is fine.
> >
> > hth,
> > Martin
> >
> > Am Mi., 26. Aug. 2020 um 22:05 Uhr schrieb Jack Applewhite <
> > jack.applewhite_at_austinisd.org>:
> > > This is on an X8-M ODA at 18.8 with 18c DBs. Not sure why 18c
> > > shipped with SQLDev and sql 17.3.
> > >
> > > [oracle_at_falcon admin]$ echo $PWD
> > > /u01/app/oracle/admin
> > > oracle_at_falcon admin]$ sql /nolog
> > >
> > > SQLcl: Release 17.3.0 Production on Wed Aug 26 15:03:08 2020
> > >
> > > Copyright (c) 1982, 2020, Oracle. All rights reserved.
> > >
> > > _at_ > show sqlpath
> > > SQLPATH :
> > > /u01/app/oracle/product/18.0.0.0/dbhome_1/sqldeveloper/sqldevelop
> > > er/bin/:.
> > > _at_ >
> > > _at_ > exit
> > > [oracle_at_falcon admin]$
> > >
> > > What's it supposed to be?
> > > Thanks.
> > > --
> > > Jack C. Applewhite - Database Administrator
> > > Austin I.S.D. - MIS Department
> > > 512.414.9250 (wk)
> > > I cannot help but notice that there is no problem between us that
> > > cannot be solved by your departure. -- Mark Twain
> > >
> > > From: Jeff Smith <jeff.d.smith_at_oracle.com>
> > > Sent: Wednesday, August 26, 2020 14:51
> > > To: Jack Applewhite <jack.applewhite_at_austinisd.org>; Martin
> > > Berger <martin.a.berger_at_gmail.com>; franck_at_pachot.net <
> > > franck_at_pachot.net>
> > > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > > oracle-l_at_freelists.org>
> > > Subject: RE: SQLl _at_ command
> > >
> > > Jumping in late, so apologies
> > >
> > > But if I echo $PWD
> > >
> > > And then start sqlcl
> > >
> > > And show sqlpath…
> > >
> > > I see $PWD
> > >
> > > So can someone explain to me what we’re doing wrong? Happy to
> > > file a bug and drive to get it fixed for you.
> > >
> > > Jeff
> > >
> > > From: Jack Applewhite <jack.applewhite_at_austinisd.org>
> > > Sent: Wednesday, August 26, 2020 3:20 PM
> > > To: Martin Berger <martin.a.berger_at_gmail.com>; franck_at_pachot.net
> > > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > > oracle-l_at_freelists.org>
> > > Subject: Re: SQLl _at_ command
> > >
> > > Yes, this has been bugging us since we migrated to 18c. I LOVE
> > > sql or sqlcl, but having it not respect $PWD is Very annoying.
> > > I just execute sql, which launches the sql script in
> > > $ORACLE_HOME/bin, which executes the line below
> > >
> > > cd "`dirname $0`"/../sqldeveloper/sqldeveloper/bin && bash
> > > sql $*
> > >
> > > So, not being an ace shell scripter, is there a straightforward
> > > way to get this to inherit the $PWD of the original invocation of
> > > sql? Or to edit the .../sqldeveloper/bin/sql big ol' script to
> > > inherit $PWD?
> > >
> > > Thanks.
> > > --
> > > Jack C. Applewhite - Database Administrator
> > > Austin I.S.D. - MIS Department
> > > 512.414.9250 (wk)
> > > I cannot help but notice that there is no problem between us that
> > > cannot be solved by your departure. -- Mark Twain
> > >
> > > From: oracle-l-bounce_at_freelists.org <
> > > oracle-l-bounce_at_freelists.org> on behalf of Franck Pachot <
> > > franck_at_pachot.net>
> > > Sent: Wednesday, August 26, 2020 11:26
> > > To: Martin Berger <martin.a.berger_at_gmail.com>
> > > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > > oracle-l_at_freelists.org>
> > > Subject: Re: SQLl _at_ command
> > >
> > > Hi all,
> > > It is not SQLcl that changes the directory but the wrapping
> > > script that you find in $ORACLE_HOME/bin/sql
> > > Franck.
> > >
> > > On Wed, Aug 26, 2020 at 5:02 PM Martin Berger <
> > > martin.a.berger_at_gmail.com> wrote:
> > > > Hi Mladen,
> > > >
> > > > I had similar issues with versions prior to 20.2: SQLcl changed
> > > > it's working directory.
> > > > can you please do a
> > > > !pwd
> > > > (or !cd )
> > > > to see in which directory your SQLcl really is?
> > > >
> > > > hth
> > > > berx
> > > >
> > > > Am Mi., 26. Aug. 2020 um 16:40 Uhr schrieb Mladen Gogala <
> > > > gogala.mladen_at_gmail.com>:
> > > > > Hi!
> > > > > I am having problems with the _at_ command from SQLCl. For some
> > > > > reason, SQLCl 20.2 doesn't find the file, even if it is in
> > > > > the current directory. Does anyone have the same experience?
> > > > > Regards
> > > > > -- Mladen Gogala
> > > > > Database Consultant
> > > > > Tel: (347) 321-1217
> > > >
> > > >
> > > >
> > > > --
> > > > Martin Berger Oracle ♠
> > > > martin.a.berger_at_gmail.com _at_martinberx
> > > > ^∆x http://berxblog.blogspot.com
> > >
> > > Confidentiality Notice: This email message, including all
> > > attachments, is for the sole use of the intended recipient(s) and
> > > may contain confidential student and/or employee information.
> > > Unauthorized use of disclosure is prohibited under the federal
> > > Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR
> > > Part 99, 19 TAC 247.2, Gov’t Code 552.023, Educ. Code 21.355, 29
> > > CFR 1630.14(b)(c)). If you are not the intended recipient, you
> > > may not use, disclose, copy or disseminate this information.
> > > Please call the sender immediately or reply by email and destroy
> > > all copies of the original message, including attachments.
> > > Confidentiality Notice: This email message, including all
> > > attachments, is for the sole use of the intended recipient(s) and
> > > may contain confidential student and/or employee information.
> > > Unauthorized use of disclosure is prohibited under the federal
> > > Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR
> > > Part 99, 19 TAC 247.2, Gov’t Code 552.023, Educ. Code 21.355, 29
> > > CFR 1630.14(b)(c)). If you are not the intended recipient, you
> > > may not use, disclose, copy or disseminate this information.
> > > Please call the sender immediately or reply by email and destroy
> > > all copies of the original message, including attachments.
> >
> >
> >
> -- Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217

-- 
Mladen Gogala

Database Consultant

Tel: (347) 321-1217


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