why Datapump is faster than traditional export and import
Answer Posted / anonymous
We have parameters like parallel to assign number of workers in data pump, but not in exp/imp.
Also Data Pump uses stream pool of SGA.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is dbcc? : sql server DBA
Why would you use sql agent? : sql server DBA
what is a user-defined lock?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is replication? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the recovery models for a database? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how does an oracle clusterware manage crs resources?
What types of replication are supported in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you find out if a table can be redefined?