Since Upgrade To 11.2 There Are Many Trace Files Created Starting With "prvtaqis - Enter" (Doc ID 1358823.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

 

KUPC: Setting remote flag for this process to FALSE
prvtaqis - Enter
prvtaqis subtab_name upd
prvtaqis sys table upd
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst rqan->lascn_kwqiia > 0 block
...
The alert log doesn't confirm any issue which would justify any new traces. Many unnecessary traces are created.
The following test case will illustrate this:
TEST CASE:
----------
1. Create a test user and some test data

   -- Create user
   create user tc identified by tc default tablespace users;
   grant dba to tc;

   -- Create table
   create table tc.t1 as select * from dual;

   -- Create export directory
   create or replace directory test_dp as '/tmp';

2. Remove all *.trc and *.trm file in the /trace directory of the
   diagnostic home. (use "adrci purge" or OS rm command)

   adrci> purge -age 1 -type TRACE

3. Export table

   host rm /tmp/export.dmp
   host expdp tc/tc directory=test_dp dumpfile=export.dmp tables=t1

4. Check the the /trace trace directory of the diagnostic home.

   You'll find several new traces starting with "prvtaqis - Enter"



Changes

Upgrade to RDBMS Release 11.2 was done.

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