Hi, How can I check how many connection currently accessing a schema? Thankz
read about dynamic performace views
funky... "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
Forum Rules