Huge archive generation causing payroll process to fail, Error: ORA-1652: Unable to extend temp segment by 16 in tablespace (Doc ID 1450593.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Jan-2016***
***Checked for relevance on 13-Mon-2013***

Symptoms

Problem Statement:

When attempting to run any application compenent, the database is generating huge archive logs even if we stop the application components the following error occurs.

ora-1652 : unable to extend temp segment by 16 in tablespace TEMP1 STEPS

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1. Run any concurrent program or application
  2. Huge log files are being created
  3. This is affecting the payroll run

 

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