09.10.2008 22:56
OlegON
 
нашел в сети...
Цитата:
SQL> select machine from v$session where sid=userenv('sid');

MACHINE
----------------------------------------------------------------
WORKGROUP\USERCOMP

with t as (
select addr,
(select c.kqfcooff from x$kqfco c,x$kqfta t where t.indx = c.kqfcotab
and t.kqftanam='X$KSUSE' and c.kqfconam='KSUSEMNM'
) offset,
KSUSEMNM machine from x$ksuse
where addr=(select saddr from v$session where sid=userenv('sid'))
)
select to_number(rawtohex(addr),'XXXXXXXX')+offset offset,machine from t;

OFFSET MACHINE
---------- -------------------------------
1337124416 WORKGROUP\USERCOMP

oradebug setmypid;
oradebug poke 1337124416 4 0x6C6C6548;
oradebug poke 1337124420 4 0x6F57206F;
oradebug poke 1337124424 4 0x00646C72;
oradebug poke 1337124428 4 0x00000000;
oradebug poke 1337124432 4 0x00000000;

select machine from v$session where sid=userenv('sid');

MACHINE
---------------
Hello World
Часовой пояс GMT +3, время: 10:09.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.