My Oracle Support Banner

在12.2中ALTER..COMPILE生成不必要的跟踪文件 (Doc ID 2535488.1)

Last updated on JULY 29, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.2.0.1 和更高版本
本文档所含信息适用于所有平台

症状

在12.2中生成不必要的跟踪文件。 这主要是在编译任何对象时观察到的

跟踪文件的内容如下所示:

*** 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 

** 这是编译SYS.UTL_FILE时生成的跟踪文件

更改

Test case

$ vi x.sql

alter package sys.utl_file compile;

show errors

exit

$ chmod -R 777 x.sql

$ 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.us.oracle.com (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

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.