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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

 name=SYS.UTL_FILE

*** 2018-07-10T03:53:32.753296+00:00 (CDB$ROOT(1))
 name=SYS.UTL_FILE 

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

Changes

Test case

$ vi x.sql

alter package sys.utl_file compile;

show errors

exit

$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 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 12.2.0.1.0 - 64bit Production

SQL> @x.sql

 Package altered.

 No errors.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 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

 

  name=SYS.UTL_FILE

 

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

  name=SYS.UTL_FILE

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.