Oracle TopSessions Messages

VMS-01000 to VMS-01999: Not So Critical Errors

VMS-01000: Unable to access public synonym V$OPEN_CURSOR. Cannot show open cursors.

Cause: Either v$open_cursor does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.

VMS-01001: Unable to access public synonym V$SQLTEXT. Cannot show explain plan.

Cause: Either v$sqltext does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.

VMS-01002: Unable to access public synonym V$LOCK. Cannot show locks information.

Cause: Either v$lock not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.

VMS-01003: Unable to access public synonym SYS.DBA_WAITERS. Cannot show blocked sessions.

Cause: It either does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATBLOCK.SQL and grant you SELECT privilege on all columns of the views DBA_WAITERS and DBA_LOCKS.

VMS-01004: Unable to access table SYS.PLAN_TABLE. Cannot show explain plan.

Cause: Either sys.plan_table does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run UTLXPLAN.SQL and grant you SELECT, INSERT and DELETE privileges on all columns of this table.

VMS-01005: Unable to access public synonym DBA_OBJECTS. Cannot show blocked sessions.

Cause: Either dba_objects does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.

VMS-01006: Cannot access DBA_WAITERS and SYS.PLAN_TABLE. Cannot show blocked sessions and explain plan.

Cause: Either sys.plan_table does not exist or the user does not have the necessary permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL and UTLXPLAN.SQL; to grant you the SELECT privilege on all columns of DBA_WAITERS; and to grant you SELECT, INSERT and DELETE privileges on all columns of SYS.PLAN_TABLE.

VMS-01007: System failed to allocate a timer.

Cause: A timer could not be obtained from the system.

Action: Try closing other applications which use timers.

VMS-01008: Failed to connect to database.

Cause: A database session could not be opened.

Action: Specify a different username, password, or connect string.

VMS-01009: File topsess.opt not found.

Cause: Could not find the options file topsess.opt.

Action: Specify default options and continue. Oracle TopSessions will recreate this file when it exists.

VMS-01010: Trouble reading topsess.opt file.

Cause: Unable to read the options file topsess.opt.

Action: Specify the default options and continue. Oracle TopSessions will recreate this file when it exists.

VMS-01011: Could not write to topsess.opt file.

Cause: Unable to write to the options file topsess.opt file.

Action: The file probably has read-only permissions, or you may be out of hard disk space.

VMS-01012: Could not serialize to topsess.opt file.

Cause: Unable to serialize to the options file topsess.opt.

Action: The file probably has read-only permissions, or you may be out of hard disk space.

VMS-01013: Cannot proceed further. Press Retry to reconnect.

Cause: Unable to connect to the database.

Action: Press the retry button to reconnect.

VMS-01014: Cannot verify if SYS.DBA_WAITERS and SYS.PLAN_TABLE are accessible. Assuming they are accessible.

Cause: Unable to verify whether SYS.DBA_WAITERS and SYS.PLAN_TABLE are accessible.

Action: None.

VMS-01015: Unable to access public synonym V$ROLLNAME. Cannot show locks information.

Cause: Unable to access v$rollname public synonym. It either does not exist or you do not have permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.

VMS-01016: Unable to access public synonym AUDIT_ACTIONS. Cannot show session commands.

Cause: Unable to access audit_actions public synonym. It either does not exist or you do not have permissions to access it.

Action: Ask your system administrator to run the script CATALOG.SQL.