Skip to Main Content
  • Questions
  • Unable to read trace file generated by EXPDP

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: February 09, 2019 - 5:24 am UTC

Last updated: February 19, 2019 - 5:48 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

HI THERE,
We are running EXPDP on a daily basis and size for the schema is only 14GB but the job is taking around 6 hours to complete.

so yesterday i executed the expdp with TRACE=480300 and i got

One trace file for the master processes testdb_dm00_5016.trc (size is 455 kb)

And

One trace files for the worker processes testdb_dw00_7432.trc (size is 4080 kb)

Now i really don't know how to convert it into readable form,And i am doing this for the first time
would you guys please share things that i have to look into after converting those trace file to find the actual cause..

And one more thing, will hard disk problem slowdown expdp and impdp jobs??

and Connor said...

I've had similar experiences with DataPump tracing in that I've generally found the content to be useful only for logging an SR and providing information to Oracle Support. In particular, I don't think the tracing is targetted for performance, but more for errors and the like.

But!

Standard sql trace can be your friend here. Since data pump fires off multiple sessions you can set it at system level or using a logon trigger, eg

alter system set events = '10046 trace name context forever, level 8'


or

create or replace
trigger sys.TRACE_ALL_LOGINS
after logon on XXXX.schema
begin
    execute immediate 'alter session set tracefile_identifier = XXX';
    execute immediate 'alter session set events = ''10046 trace name context forever, level 18''';
exception
  --
  -- if something goes wrong, we still want to allow a login to proceed
  --
  when others then null;
end;
/


and work from that.

will hard disk problem slowdown expdp and impdp jobs??

Probably. Because Data pump jobs are typically I/O intensive.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

vishnudas, February 18, 2019 - 9:46 am UTC

Thank you for your answer.i will try with your suggestion
Connor McDonald
February 19, 2019 - 5:48 am UTC

glad we could help

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.