My Oracle Support Banner

ALTER..COMPILE Generated Unnecessary Tracefiles in 12.2 (Doc ID 2486754.1)

Last updated on JULY 21, 2021

Applies to:

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


Unnecessary tracefiles are generated in 12.2 . This is mostly observed while compiling any object 

The contents of the trace file looks like:

*** CONTAINER ID:(1) 2018-07-10T03:53:32.313013+00:00


*** 2018-07-10T03:53:32.753296+00:00 (CDB$ROOT(1))

** This is the tracefile generated while compiling SYS.UTL_FILE


Test case

$ vi x.sql

alter package sys.utl_file compile;

show errors


$ sqlplus / as sysdba

SQL*Plus: Release Production on Tue Jul 10 03:52:59 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release - 64bit Production

SQL> @x.sql

 Package altered.

 No errors.

Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production

$ cd <diag_dest>/trace/

$ ls -ltr

$ cat abcd_ora_14352.trc 

<removing the trace header>


*** 2018-07-10T03:53:32.312834+00:00 (CDB$ROOT(1))

*** SESSION ID:(9.43040) 2018-07-10T03:53:32.312905+00:00

*** CLIENT ID:() 2018-07-10T03:53:32.312925+00:00

*** SERVICE NAME:(SYS$USERS) 2018-07-10T03:53:32.312943+00:00

*** MODULE NAME:(sqlplus@nodename.DOMAIN_NAME (TNS V1-V3)) 2018-07-10T03:53:32.312961+00:00

*** ACTION NAME:() 2018-07-10T03:53:32.312979+00:00

*** CLIENT DRIVER:(SQL*PLUS) 2018-07-10T03:53:32.312996+00:00

*** CONTAINER ID:(1) 2018-07-10T03:53:32.313013+00:00




*** 2018-07-10T03:53:32.753296+00:00 (CDB$ROOT(1))



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.