Some Tips with SQL PLus

Many times we may open several SQL*PLUS windows meaning serveral database consoles. In order to identify the right console we can do,
Code:
SQL> host hostname
Queen

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------    ----------------------------
db_name                              string      kidas

SQL> show user
USER is "SYS"
to be sure on which database as which user we are actually going to run commands.

So after three commands we would run a sql. By setting SQL*plus environmental variable connection identifier we can get rid of it and be sure on which console we are connecting to. Like,
Code:
SQL> SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > "
SYS@kidas >
And now rename the session as of hostname.

cheers