Re: please post your login.sql / glogin.sql [EXAMPLES]
- From: Sidney Chen <huanshengchen@xxxxxxxxx>
- To: weblehner@xxxxxxxxx
- Date: Tue, 5 Mar 2013 20:42:04 +0800
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) || '@' || 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@xxxxxxxxx> wrote:
> Hi
>
> please post your login.sql / glogin.sql
> I need some examples for my environment.
>
> Lukas
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Regards
Sidney Chen
--
//www.freelists.org/webpage/oracle-l
Other related posts:
