My Oracle Support Banner

ORA-7445[ktusmst2f()+316] when Gathering Statistics for Fixed Tables (Doc ID 2486297.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The following error occurs when collecting statistics of fixed tables:

============
Plan Table
============
------------------------------------------------------+-----------------------------------+
| Id  | Operation                         | Name      | Rows  | Bytes | Cost  | Time      |
------------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT                  |           |       |       |     1 |           |
| 1   |  SORT AGGREGATE                   |           |     1 |   141 |       |           |
| 2   |   OPTIMIZER STATISTICS GATHERING  |           |     3 |   423 |     0 |           |
| 3   |    FIXED TABLE FULL               | X$KTUSMST2|     3 |   423 |     0 |           |
------------------------------------------------------+-----------------------------------+

Changes

 Patch 20195148 for unpublished Bug 20195148 has been installed but the error persists.

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.