Re: please post your login.sql / glogin.sql [EXAMPLES]

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Tue, 5 Mar 2013 20:42:04 +0800
Message-ID: <CAM_ddu8iEtJfrgV_7ezgp7qTfuCFuWhazZ0yETp_2PguTNbo4Q_at_mail.gmail.com>

Here comes mine.
define _editor=vi
--set serveroutput on size 1000000
set trimspool on
set long 5000
set verify off
set linesize 1000
set pagesize 9999
col object_name format a30
col segment_name format a30
col file_name format a40
col name format a30
col what format a30 word_wrapped
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select lower(user) || '_at_' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name   from (select global_name, instr(global_name,'.') dot from global_name ); set sqlprompt '&gname> '
set termout on
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'; column log_fmt new_value _log_fmt noprint select to_char(sysdate,'YYYY-MM-DD_HH24-MI') log_fmt from dual; spool log/&_log_fmt;
col username for A20
col opid for 99999
select

        s.username,
        s.sid,
        s.serial#,
        p.spid,
        p.pid,
        s.process,
        s.logon_time
from
        v$session s,
        v$instance i,
        v$process p
where
        s.paddr = p.addr
and
        sid = (select sid from v$mystat where rownum = 1)

/

On Tue, Mar 5, 2013 at 8:08 PM, Lukas Lehner <weblehner_at_gmail.com> wrote:

> Hi
>
> please post your login.sql / glogin.sql
> I need some examples for my environment.
>
> Lukas
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards
Sidney Chen


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 05 2013 - 13:42:04 CET