BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck

DBA_RESUMABLE view tips

Oracle Tips by Burleson Consulting

DBA_RESUMABLE

<< Return to the index

Oracle 11g makes the following comments about the DBA_RESUMABLE table: "Resumable session information in the system"

Related notes on DBA_RESUMABLE:

Column description of the DBA_RESUMABLE view:

USER_ID

Description of DBA_RESUMABLE.USER_ID: "User who own this resumable session"

SESSION_ID

Description of DBA_RESUMABLE.SESSION_ID: "Session ID of this resumable session"

INSTANCE_ID

Description of DBA_RESUMABLE.INSTANCE_ID: "Instance ID of this resumable session"

COORD_INSTANCE_ID

Description of DBA_RESUMABLE.COORD_INSTANCE_ID: "Instance number of parallel query coordinator"

COORD_SESSION_ID

Description of DBA_RESUMABLE.COORD_SESSION_ID: "Session number of parallel query coordinator"

STATUS

Description of DBA_RESUMABLE.STATUS: "Status of this resumable session"

TIMEOUT

Description of DBA_RESUMABLE.TIMEOUT: "Timeout of this resumable session"

START_TIME

Description of DBA_RESUMABLE.START_TIME: "Start time of the current transaction"

SUSPEND_TIME

Description of DBA_RESUMABLE.SUSPEND_TIME: "Suspend time of the current statement"

RESUME_TIME

Description of DBA_RESUMABLE.RESUME_TIME: "Resume time of the current statement"

NAME

Description of DBA_RESUMABLE.NAME: "Name of this resumable session"

SQL_TEXT

Description of DBA_RESUMABLE.SQL_TEXT: "The current SQL text"

ERROR_NUMBER

Description of DBA_RESUMABLE.ERROR_NUMBER: "The current error number"

ERROR_PARAMETER1

Description of DBA_RESUMABLE.ERROR_PARAMETER1: "The 1st parameter to the current error message"

ERROR_PARAMETER2

Description of DBA_RESUMABLE.ERROR_PARAMETER2: "The 2nd parameter to the current error message"

ERROR_PARAMETER3

Description of DBA_RESUMABLE.ERROR_PARAMETER3: "The 3rd parameter to the current error message"

ERROR_PARAMETER4

Description of DBA_RESUMABLE.ERROR_PARAMETER4: "The 4th parameter to the current error message"

ERROR_PARAMETER5

Description of DBA_RESUMABLE.ERROR_PARAMETER5: "The 5th parameter to the current error message"

ERROR_MSG

Description of DBA_RESUMABLE.ERROR_MSG: "The current error message"

DBA_RESUMABLE View Source

Oracle 11g's data dictionary defines the DBA_RESUMABLE view using the following source query:

select distinct S.USER# as USER_ID, R.SID as SESSION_ID,
R.INST_ID as INSTANCE_ID, P.QCINST_ID, P.QCSID,
R.STATUS, R.TIMEOUT, NVL(T.START_TIME, R.SUSPEND_TIME) as START_TIME,
R.SUSPEND_TIME, R.RESUME_TIME, R.NAME, Q.SQL_TEXT, R.ERROR_NUMBER,
R.ERROR_PARAMETER1, R.ERROR_PARAMETER2, R.ERROR_PARAMETER3,
R.ERROR_PARAMETER4, R.ERROR_PARAMETER5, R.ERROR_MSG
from GV$RESUMABLE R, GV$SESSION S, GV$TRANSACTION T, GV$SQL Q, GV$PX_SESSION P
where S.SID=R.SID and S.INST_ID=R.INST_ID
and S.SADDR=T.SES_ADDR(+) and S.INST_ID=T.INST_ID(+)
and S.SQL_ADDRESS=Q.ADDRESS(+) and S.INST_ID=Q.INST_ID(+)
and S.SADDR=P.SADDR(+) and S.INST_ID=P.INST_ID(+)
and R.ENABLED='YES' and NVL(T.SPACE(+),'NO')='NO'

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books