Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
Have attempted instance sets, grants; still can't seem to get it to work. Would appreciate steps or screenshots.
See MOS Doc 1261985.1 and referenced docs.
What, exactly, do you mean by "view all current requests"?
Refer the below.
How to view/list all concurrent request output