Sure Srini can you please help me
If you have the performance option for em you can search for the session and see the explain plan. If you don't have that option you can use other methods to see the explain plan. The plan will likely tell you something about the access method for all that data, which will probably be silly. 2G out of how much data?
Pl post OS and database version and the complete EXPDP command used.
Pl be aware that this is a forum of volunteers :-) For all "urgent" issues, pl open an SR with Support.
hi srini below is the complete command i used
expdp username/password@database parfile=export.par
below is my os info
database : 126.96.36.199 version
OK, so if the export has to scan 160G, that might take a long time. If it has to do it for each or statement, that would be a really long time. So it behooves you to trace or explain plans. It might be as simple as changing in to exists. It might be something else. You need to use the tools to figure out what is wrong. Then you can figure out how to make it right.
It might also be helpful to try the predicates in a straight sqlplus and see if that can give some performance clues. See Oracle related stuff: Basic SQL statement performance diagnosis - HOW TO, step by step instructions (except don't use the code tags to try to format).
What is the ETA for the Query when you run on sql prompt
QUERY=PS_FO:"where ((c in (select c from bh_cr))
or (co in (select co from bh_cons))
or (or in (select or from bh_rs))
or (fo in (select fo from bh_ans))
or (em in (select em from bh_emp)))",
PS:"where ((cust in (select cust from bh_cuer))
or (cont in (select cont from bhts))
or (oid in (select oid from bers))
or (foid in (select foid from bhns))
or (em in (select em from bhee)))"
You can try with use the prefix SCHEMA name for each table in above command and add one parameter exclude=STATISTICS