AUTO PURGE ISSUE

(Doc ID 2338106.1)

Last updated on MAY 22, 2018

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 to 12.2.1.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Receiving the following errors when running the autopurge:
ORA-30036 unable to extend statement by 8 in undo tablespace 'UNDOTBS1' ORA-06512 at "FMW_SOAINFRA.SOA"


AUTO PURGE job1 is not working. The job is scheduled to run every night at midnight and when it starts it keeps running until the database administrators will disable it on their side. Not even sure if it is accomplishing what it needs to do.Here are the settings we have for the job:
Attribute: PurgeJobDetails
DOP 4
PQS 1
batchSize 20000
enabled true
executionSchedule freq=daily; byhour=00;
ignoreState false
jobDisplayName SOA Flow Purge Job 1
jobName delete_instances_auto_job1
maxCount 1000000
maxCreationPeriodDay -1
maxRuntime 60
minCreationPeriodDays -1
purgePartitionedComponent false
purgeType SINGLE
retentionPeriod 90
retentionPeriodUnit D
sqlTrace false

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms