ORA-07445 WHEN CREATING SQL TUNING SET (Doc ID 980663.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

ORA-7445 dumped when creating SQL tuning set with DMBS_SQLTUNE package.
The error is received when running this select:

SELECT VALUE(P) FROM TABLE(DBMS_SQLTUNE.SELECT_SQL_TRACE( DIRECTORY =><directory_name>,
FILE_NAME => <file_name>, MAPPING_TABLE_NAME =><table_name>,
SELECT_MODE =><select_mode> )) P


The issue reproduces on all platforms, the top function varies, e.g.

- On Solaris Sparc (64-bit) is slmecpy
- On Windows XP is __intel_new_memcpy
- On Linux x86 is _intel_fast_memcpy

The call stack is similar to:

... kesstpProcBindNooactyp  kesstpGetNextSql  kesqsSelectSqlTrace kessiFetchSqlTraceSqlExt spefcmpaqlExt ...



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