I use SQLPlus connecting to an Oracle database. See below snapshot. Why the first run of the command show con_name doesn't work and the second run works?

enter image description here


I have to admit that I typed the command show con_name very fast and just after SQLPlus displayed the SQL> prompt. Is it possible that SQLPlus needs to do some initialization stuff before it can start doing its work?

  • 4
    So can you reproduce this at will, or was it just a single occasion? I have the "privilege" of working on undersized AIX/POWER and Solaris/SPARC systems as well, where SQL*Plus may take up to 10 seconds to connect even locally. I am a quick typer, but I can't remember ever having this. – Balazs Papp Jul 30 '19 at 21:36
  • 1
    Are you using a login.sql file from your SQLPATH? There might be a problem with the end of it, or with the file encoding. Do you also get this when you strike enter once after logging in? – durette Jul 31 '19 at 21:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.