Para ver las sesiones abiertas en oracle

SELECT username, status, sid, serial# FROM v$session;

Así, para ver únicamente las sesiones abiertas con el usuario que se está utilizando en la aplicación. Sería:

SELECT * FROM v$session WHERE username LIKE ‘XXXXXXX’;

(Nota: Se deben tener permisos de SYS.)

1 Comentario

  • Hi here I am so excited I found your weblog, I really found you by accident, while I was
    browsing on Bing for something else, Regardless I am here now and
    would just like to say thank you for a fantastic post and a all round entertfaining blog (I also love thee theme/design), I don’t have time to go
    through it all at the minute but I have
    book-marked it and also added your RSS feeds, so when I have time I
    will be back to read a lot more, Please do keep up the excellent work.

    Heere is mmy web page: seo Barnet (pen.io)

Dejar un comentario