Interested to Buy Any Domain ? << Click Here >> for more details...
why Datapump is faster than traditional export and import
- 4 Answers
- 21490 Views
- Mphasis, I also Faced
- E-Mail Answers
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
What are the commands you'd issue to show the explain plan for "select * from dual"?
internal architecture
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how to restore files with rman?
Why does Oracle not permit the use of PCTUSED with indexes?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you process messages in order asynchronously?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do you open a cluster administrator? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is dbcc? : sql server DBA
