My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

Oracle Payroll - Version and later
Information in this document applies to any platform.


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



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.