My Oracle Support Banner

ORA-600 [504] [mostly latch-free SCN] During a Query (Doc ID 552152.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
HP-UX PA-RISC (64-bit)
HP-UX PA-RISC (64-bit)

Symptoms

The following error is seen in the alert log:
    ORA-600: internal error code, arguments: [504], ... [mostly latch-free SCN]

<>The call stack can look like this:
    ksl_level_check <- kslgetl <- kcsadj1 <- kcmclscn <- ksxpwait <- ksliwat <- kslwaitns_timed
    <- kskthbwt <- kslwait <- kmgs_sleep_wait <- kmgs_create_request <- kmgs_immediate_req
    <- ksmasg <- kghnospc</>

- The failing SQL may fail when running in a batch job.

Changes

 NONE

Cause

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
Symptoms
Changes
Cause
Solution
References


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