For legacy sql*plus reports definitely, keep using sql*plus. We’ve tried to
support all of those options, but there are gaps.
Writing out large files, I’m not super surprised, but if you get any numbers
you want to share, please feel free to send them over.
We have tried to make executing scripts in general as fast as possible. For
example we used installing APEX as a benchmark, and you should be able to do
this faster in SQLcl than in SQL*Plus now. Deets here
http://krisrice.io/2017-07-11-sqlcl-172/
From: Mark W. Farnham [mailto:mwf@xxxxxxxx] ;
Sent: Friday, January 05, 2018 8:50 AM
To: mcdonald.connor@xxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: RE: SQL Command list history on Linux
Regarding performance, the only thing I’ve found significant in my (very
non-comprehensive) testing of just the features I use is that IF (and there are
better choices, such as a C program) sqlplus (especially 12.2+ in a correctly
chosen mode) is used to produce large output files it is significantly faster
than sqlcl.
Please do not take this as a slam on sqlcl. Neither of these products are
really designed as giant output engines.
I’m just noting it to avoid folks who switch from sqlplus to sqlcl and do
create giant output files from thinking sqlcl is “slow.”
mwf
From: HYPERLINK
"mailto:oracle-l-bounce@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx ;
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Connor McDonald
Sent: Friday, January 05, 2018 2:55 AM
Cc: ORACLE-L
Subject: Re: SQL Command list history on Linux
https://mailtrack.io/trace/mail/72554f0d0e9e918a68fafccbccfbb90404693b27.png?u=941627
sqlplus is a little faster to start than sqlcl, but not something that I think
would be deemed a show-stopper,
eg here
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__imgur.com_a_Ft4d2&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=oEN92ovNCBuwF9XG8pKFBt0n7e4tyR7HW4aGtO4-6pg&s=5x76xbMmAQgQ53mlj6AViv-GmaRgi_J3ercrhD9itbU&e="https://imgur.com/a/Ft4d2
On Fri, Jan 5, 2018 at 8:21 AM, Sayan Malakshinov <HYPERLINK
"mailto:xt.and.r@xxxxxxxxx"xt.and.r@xxxxxxxxx> wrote:
And I've just found another bug: If I save SQLcl settings with "store set
sqlplus_settings.sql replace" and execute @sqlplus_settings.sql to restore
them, SQLcl returns a couple of errors:
SQL>store set sqlplus_settings.sql replace
Wrote file S:\sqlplus_settings.sql
SQL>@sqlplus_settings.sql
Autotrace Disabled
Usage: SET DESCRIBE [DEPTH {1|n|ALL}] [LINENUM {ON|OFF}] [INDENT {ON|OFF}]
SP2-0158: unknown SET option beginning "setlongchu..."
On Fri, Jan 5, 2018 at 3:18 AM, Sayan Malakshinov <HYPERLINK
"mailto:xt.and.r@xxxxxxxxx"xt.and.r@xxxxxxxxx> wrote:
Jeff,
Ah, it seems I found a bug: sqlcl can't find files from virtual drives mounted
with subst command.
My S: drive was created with "subst S: n:\s" command and sqlcl auto-completion
can't find files from S:\, though it can execute them.
But if I change directory to N:\s (original location), it works fine.
On Fri, Jan 5, 2018 at 3:09 AM, Jeff Smith <HYPERLINK
"mailto:jeff.d.smith@xxxxxxxxxx"jeff.d.smith@xxxxxxxxxx> wrote:
In my windows My Documents folder
After starting sqlcl, I used the CD command to nav to that directory, so that’s
where SQLcl is looking.
Jeff
From: Sayan Malakshinov [mailto:HYPERLINK ;
"mailto:xt.and.r@xxxxxxxxx"xt.and.r@xxxxxxxxx] ;
Sent: Thursday, January 04, 2018 7:05 PM
To: Jeff Smith <HYPERLINK
"mailto:jeff.d.smith@xxxxxxxxxx"jeff.d.smith@xxxxxxxxxx>
Cc: HYPERLINK "mailto:gdherri@xxxxxxxxx"gdherri@xxxxxxxxx; HYPERLINK ;
"mailto:neil_chandler@xxxxxxxxxxx"neil_chandler@xxxxxxxxxxx; ORACLE-L ;
<HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx>; Mladen
Gogala <HYPERLINK "mailto:gogala.mladen@xxxxxxxxx"gogala.mladen@xxxxxxxxx>
Subject: Re: SQL Command list history on Linux
Jeff,
I haven't understood, where are your lo* files located?
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=oEN92ovNCBuwF9XG8pKFBt0n7e4tyR7HW4aGtO4-6pg&s=eHdAPOYDPxbik5QPp3dFQELtaQZKWEq7H_dyDhu2hlQ&e="http://orasql.org
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=oEN92ovNCBuwF9XG8pKFBt0n7e4tyR7HW4aGtO4-6pg&s=eHdAPOYDPxbik5QPp3dFQELtaQZKWEq7H_dyDhu2hlQ&e="http://orasql.org
--
Connor McDonald
===========================
blog: HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=http-3A__connormcdonald.wordpress.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=oEN92ovNCBuwF9XG8pKFBt0n7e4tyR7HW4aGtO4-6pg&s=lKu0EUGXVn7UtHuh6JyfgXspm89LsvhEJZAcgewTwho&e="connormcdonald.wordpress.com
twitter: @connor_mc_d
"If you are not living on the edge, you are taking up too much room."
- Jayne Howard
Fine print: Views expressed here are my own and not necessarily that of my
employer