• 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.