My Oracle Support Banner

AUTO PURGE ISSUE (Doc ID 2338106.1)

Last updated on MAY 22, 2018

Applies to:

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


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
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




To view full details, 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 a vibrant support community of peers and Oracle experts.