Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 461

TABle 10.1 DBA_RESUMABLE Columns

Column Name Description

USER_ID User ID number of the resumable statement owner

SESSION_ID Session identifier of the resumable statement

INSTANCE_ID Instance number of the resumable statement

COORD_INSTANCE_ID Instance number on which the parallel coordinator is running

COORD_SESSION_ID Session identifier of the parallel coordinator

STATUS Status of the RESUMABLE statement: RUNNING , SUSPENDED , TIMEOUT ,

ERROR , or ABORTED

TIMEOUT Time-out value of the resumable statement

START_TIME Start time of the resumable statement

SUSPEND_TIME The last time the resumable statement was suspended

RESUME_TIME The last time the statement resumed

SQL_TEXT The resumable statement

ERROR_NUMBER The error number of the last error logged or this resumable state-

ment. If no errors, the value will be NULL

ERROR_PARAMETERn Error parameter columns 1 through 5

ERROR_MSG The error message associated with the ERROR_NUMBER

Monitoring Resumable Space Alerts with Enterprise Manager
Oracle Enterprise Manager will display alerts on the database home page when there are
resumable space suspends. In the example shown in Figure 10.1, we have created a suspend
condition by attempting to insert into a table that is in a space-constrained tablespace.
On the database alerts page, shown in Figure 10.2, click the error message Summary
link to see the details of the error.
Now from the alert page, under the Guided Resolution section, click the Edit Tablespace
link, shown in Figure 10.3, to display the tablespace details.
For the constrained tablespace, shown in Figure 10.4, choose to add a new data file to
the tablespace or edit the data file and increase the size.