ALTER..COMPILE Generated Unnecessary Tracefiles in 12.2
(Doc ID 2486754.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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:
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 |