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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
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.

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