I previously wrote that I peeped the idea about showing the session information in terminal title from Timur Akhmadeev’s screenshots, and Timur wrote:
I’m using (a bit modified) Tanel Poder’s login.sql available in his TPT scripts library: http://tech.e2sn.com/oracle-scripts-and-tools
My title.sql and on_login.sql
Colored prompt is the one of many features of rlwrap.
Connected as simple user:
Connected as sysdba:
SQL*Plus on OEL through putty: