This discussion is archived
3 Replies Latest reply: Aug 6, 2012 2:30 PM by damorgan RSS


Rinne Newbie
Currently Being Moderated
I created the login.sql and put it under C:\app\...\product\11.2.0\client_1\sqlplus\admin
but after I run SQLPLUS and test by putting show serveroutput, it looks like it didn't run login.sql.
Is there anything else I need to do to make it work?

Here is the content of login.sql

set termout off
set serveroutput on size 1000000 format wrapped
column object_name format a30
column segment_name format a30
column file_name format a40
column name format a30
column file_name format a30
column what format a30 word_wrapped
column plan_plus_exp format a100
set trimspool on
set long 5000
set linesize 131
set pagesize 9999
define gname=idle
column global_name new_value gname
select lower(user) || '@' ||
substr( global_name, 1, decode( dot,
0, length(global_name)
from (select global_name, instr(global_name, '.') dot
from global_name );
set sqlprompt '&gname> '
set termout on

Edited by: Rinne on Aug 6, 2012 3:34 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points