Home » RDBMS Server » Server Utilities » monitoring export ,import job and tuning
monitoring export ,import job and tuning [message #552787] Sat, 28 April 2012 06:48 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
how can i monitor the export and import job and how increase the export and import job performance.

can i monitor the export and import job by checking the log and dump file created by export and import and can its performance increase by configure parallism. m i right or not?
Re: monitoring export ,import job and tuning [message #552793 is a reply to message #552787] Sat, 28 April 2012 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can i monitor the export and import job

For old import and export in non direct mode, just follow the execution of INSERT or SELECT from the tool session.

Quote:
how increase the export and import job performance


Increase BUFFER is the first step.
Otherwise documentation of the tool mentioned how to increase their performances http://tahiti.oracle.com.

Quote:
can i monitor the export and import job by checking the log and dump file created by export and import


Yes.

Quote:
can its performance increase by configure parallism


Old exp/imp do not support parallelism.
Once again documentation tells you all.

Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: monitoring export ,import job and tuning [message #552794 is a reply to message #552793] Sat, 28 April 2012 09:16 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
os xp service pack 2. oracle 10g (10.2.0.1.0).

thanks





Previous Topic: ORA-01950: no privileges on tablespace
Next Topic: import d.dmp file
Goto Forum:
  


Current Time: Fri Mar 29 06:47:16 CDT 2024