Re: hacking V$MYSTAT into "V$MYSESSION"

Thank you very much!

*--*
*Att*

*Luis Santos*

Em sex, 29 de mar de 2019 às 10:39, Oleksandr Denysenko < odenysenko_at_gmail.com> escreveu:

> Hi,
>
> like this one ?
>
> create view SYS.v_$mysession as select * from v$session where
> username=user;
> create public synonym v$mysession for SYS.v_$mysession;
> grant select on SYS.v_$mysession to public;
>
> create user test identified by test;
> grant create session to test;
>
> connect test/test
> select sid,serial#,username from v$mysession;
> SID SERIAL# USERNAME
> ---------- ---------- ------------------------------
> 258 29382 TEST
>
> Best Regards,
>
> Oleksandr Denysenko
>
> 29.03.2019 15:26, Luis Santos пишет:
>
> Is there a way to hack the V$MYSTAT definition to create a "V$MYSESSION",
> which would contain a subset from V$SESSION relative to the current_user
> (current and possibly other sessions from the same user)?
>
> *--*
> *Best regards*
>
>
> *Luis Santos *
>
>

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