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

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

     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