Monitoring Long Operations

Previous

Next

---

The Long Operations page of the Oracle Database XE graphical user interface displays statistics on various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering operations, and query execution.

To monitor long operations:

1. Access the Database Home Page and log in as user SYSTEM.

   See "Accessing the Database Home Page" for instructions.

2. On the Database Home Page, click Administration, and then click Monitor.

3. On the Database Monitor page, click Long Operations.

   The Long Operations page appears.

4. (Optional) Under the SID column, click a session ID to view the Session Details page for that session. The Session Details page enables you to kill the session.