Oracle - Sessions
SELECT 'Currently, ' || (SELECT COUNT(*) FROM V$SESSION) || ' out of ' || VP.VALUE || ' connections are used.' AS "Session Usage" FROM V$PARAMETER VP WHERE VP.NAME = 'sessions'
Currently, 1552 out of 6000 connections are used.
Jason's Rant...I mean Blog
SELECT 'Currently, ' || (SELECT COUNT(*) FROM V$SESSION) || ' out of ' || VP.VALUE || ' connections are used.' AS "Session Usage" FROM V$PARAMETER VP WHERE VP.NAME = 'sessions'
Currently, 1552 out of 6000 connections are used.
No comments:
Post a Comment