Start?
Or Connect?
Or both?
If you do
sql /nolog - how long to get a prompt?
Once you have a prompt, how long to establish your connection?
And then, how long to establish same connection in SQ*Plus for comparison.
Jeff
PS I still call it ezconnect.
From: Sweetser, Joe [mailto:JSweetser@xxxxxxxx] ;
Sent: Thursday, January 04, 2018 10:46 AM
To: Jeff Smith <jeff.d.smith@xxxxxxxxxx>; neil_chandler@xxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; gogala.mladen@xxxxxxxxx
Subject: RE: SQL Command list history on Linux
FWIW, on my laptop (old-ish hp840, 16gb RAM, winders 10) it takes 8-10 seconds
to connect using ezconnect (is it still called that?) syntax.
sql jsweetser@jdbc:oracle:thin:@<hostname>:<port>/<service_name>
Not complaining, just throwing out a data point.
-joe
C:\tools\> java -version
java version "1.8.0_151"
Java(TM) SE Runtime Environment (build 1.8.0_151-b12)
Java HotSpot(TM) Client VM (build 25.151-b12, mixed mode)
From: HYPERLINK
"mailto:oracle-l-bounce@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx ;
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeff Smith
Sent: Thursday, January 4, 2018 8:11 AM
To: HYPERLINK "mailto:neil_chandler@xxxxxxxxxxx"neil_chandler@xxxxxxxxxxx; ;
HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx; HYPERLINK ;
"mailto:gogala.mladen@xxxxxxxxx"gogala.mladen@xxxxxxxxx
Subject: RE: SQL Command list history on Linux
Slow to start? Maybe a second, or 3? If it's taking longer than that, please
let me know.
Java 8u50 or higher will be ok, which is about 2-2.5 years old?
It's a 20mb or so download, so takes less than a minute to install if you don't
have it. Less time than it takes maybe to setup rlwrap.esp if you're on
Windows.
From: Neil Chandler [mailto:neil_chandler@xxxxxxxxxxx] ;
Sent: Thursday, January 04, 2018 7:59 AM
To: HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx; HYPERLINK ;
"mailto:gogala.mladen@xxxxxxxxx"gogala.mladen@xxxxxxxxx
Subject: Re: SQL Command list history on Linux
Mladen,
What has that go to do with the original posters question?
If you are developing PL/SQL in SQL*Plus, you're probably not doing it
efficiently. SQL Developer is the better (free) tool for that, regardless of
platform.
SQLCI is great, but it's slow to start, requires a fairly recent Java release,
and only natively available from 12.2.
If you want Windows-like editing on a Linux SQL*Plus (or dgmgrl, rman or
whatever), use rlwrap.
regards
Neil Chandler.
Database Guy.
_____
From: HYPERLINK
"mailto:oracle-l-bounce@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx ;<HYPERLINK
"mailto:oracle-l-bounce@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Mladen Gogala <HYPERLINK
"mailto:gogala.mladen@xxxxxxxxx"gogala.mladen@xxxxxxxxx>
Sent: 04 January 2018 10:57
To: HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx
Subject: Re: SQL Command list history on Linux
On 01/02/2018 04:51 PM, Neil Chandler wrote:
Jeff,
My preferred solution is to install "rlwrap" [ e.g. "yum install rlwrap" -
check out HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttps-2D3A-5F-5Fgithub.com-5Fhanslub42-5Frlwrap-2526d-253DDwMFAw-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253D0bds7QIoykh2KktiFwI5q5NtAunsmhvpPbDLFAGKbBY-2526s-253DcRMpNNnqbVGwt9R-2DSUJkdE4mCdC-2D1KZy0LkLX77BvUY-2526e-253D-26data-3D02-257C01-257CJSweetser-2540icat.com-257C71fcf051dd5448f606b608d553859a0b-257C5d3bf30e9adb4c17b2425c17523e6e5e-257C0-257C0-257C636506755637843208-26sdata-3DspLAqnmcrSKBH-252BpCCuW3BfBF0XgArZ4IAE2ItQonRNk-253D-26reserved-3D0&d=DwMFAg&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=96DqygTiB0EjE0q1Q0iBWsh38dovI8Od6iAbGCUDJ4I&s=wgTotyCPcIBHC_H5uUnjuEhnyIn4ldvzAFIUcNz4xxA&e="https://github.com/hanslub42/rlwrap
] it provides similar functionality to a windows CMD environment. You just
call the command you want to use via rlwrap
e.g. rlwrap sqlplus, or rlwrap dgmgrl
To keep thing simple, you can alias it
alias rsql='rlwrap sqlplus'
alias rdg='rlwrap dgmgrl'
regards
Neil Chandler
Hi Neil,
Rlwrap is not an equivalent solution. The "rlwrap" trick breaks editing of
PL/SQL code, which can be annoying. If you write a multi-line PL/SQL snippet
and something goes wrong, "ed" will only return a part of the snippet. SQLCl
will do the right thing and give you back the entire procedure. It has a
primitive screen editor built into the code because arrow keys also work when
editing the history commands. Also, SQLCl has "REPEAT" command which turns your
SQLCl session into an instant monitor, if necessary. In addition to all that,
there is Jeff Smith, who has been doing an outstanding job with the product and
explaining it on this list. Jeff is extremely helpful and a very nice guy. And
no, I don't work for Oracle Corp. and I don't plan on working for Oracle
anytime soon.
Regards
--
Mladen Gogala
Oracle DBA
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fmgogala.freehostia.com-2526d-253DDwMFAw-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253D0bds7QIoykh2KktiFwI5q5NtAunsmhvpPbDLFAGKbBY-2526s-253DPcMyzBvpXVEJ8OtXmrHXL-2DcnBgMOPb4mBf88-2DfufLHU-2526e-253D-26data-3D02-257C01-257CJSweetser-2540icat.com-257C71fcf051dd5448f606b608d553859a0b-257C5d3bf30e9adb4c17b2425c17523e6e5e-257C0-257C0-257C636506755637843208-26sdata-3DG4Ok-252FXktt12Cdh1-252Byt2n1zz1T33K7wxEH-252FcFxJDezyE-253D-26reserved-3D0&d=DwMFAg&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=96DqygTiB0EjE0q1Q0iBWsh38dovI8Od6iAbGCUDJ4I&s=FEZYvAI43hoWw41WNw1a-xnSsfj3sKialFGV_6y4KAg&e="http://mgogala.freehostia.com
This e-mail transmission and any attachments that accompany it may contain
information that is privileged, confidential or otherwise exempt from
disclosure under applicable law and is intended solely for the use of the
individual's to whom it was intended to be addressed. If you have received this
e-mail by mistake, or you are not the intended recipient, any disclosure,
dissemination, distribution, copying or other use or retention of this
communication or its substance is prohibited. If you have received this
communication in error, please immediately reply to the author via e-mail that
you received this message by mistake and also permanently delete the original
and all copies of this e-mail and any attachments from your computer. Please
note that coverage cannot be bound or altered by sending an email. You must
receive written confirmation from a representative of our firm to put coverage
in force or make changes to an existing policy.
