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
How would you go about verifying the network name that the local_listener is currently using?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Where would you look for errors from the database engine?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the operating modes in which database mirroring runs? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
which background process invoke at the time of upgradation tell me???
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different ways you can create databases in sql server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How do you trace the traffic hitting a sql server? : sql server DBA
how can you connect from 10g user to 11g user??