Oracle 9i and above.
Monitor
status
start time
end time
usage
to see another user's indexes, you must:
have access to SYS.OB$ view
have access to SYS.IND$ view
have access to SYS.USERS$ view
have access to SYS.OBJECT_USAGE view
have the ALTER ANY INDEX privilege.