Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enabling Resumable wait

KavanaghOct 22 2012 — edited Oct 25 2012

11.2.0.2 Two-node RAC DB /Solaris 10

I believe that resumable wait is enabled by setting a value for RESUMABLE_TIMEOUT parameter.
In our DB, I can see it has been set as zero

SQL > show parameter resumable_timeout

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resumable_timeout                    integer     0

Despite this setting , the resumable wait is enabled in our DB as you can see from the below log where impdp is waiting when there is a lack of space.
How is this possible?

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table RMSP_DEV.PKT_PARCEL_DTL by 8192 in tablespace RMSP_TBS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table RMSP_DEV.PKT_PARCEL_DTL by 8192 in tablespace RMSP_TBS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table RMSP_DEV.PKT_PARCEL_DTL by 8192 in tablespace RMSP_TBS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table RMSP_DEV.PKT_PARCEL_DTL by 8192 in tablespace RMSP_TBS
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table RMSP_DEV.PKT_PARCEL_DTL by 8192 in tablespace RMSP_TBS

This post has been answered by Castell on Oct 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2012

Added on Oct 22 2012

#database-key-features, #export-import-sql-loader-external-tables

5 comments

1,450 views