How can I check how many connection currently accessing a schema?
read about dynamic performace views
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
SELECT * FROM V$SESSION WHERE SCHEMANAME='YOUR_SCHEMA'
DITTO on reply from member abhaysk
Able was I ere I saw Elba