Do we have to use same number of parallel in export and import ?
On what basis is parallel used ?
--> For Data Pump Export, the value that is specified for the parallel parameter should be less than or equal to the number of files in the dump file set. Data Pump Import should not have a value for the PARALLEL parameter that is significantly larger than the number of files in the dump file set.
how to increase the performance of export /import ?
-----------------------------------------------------
-- Set the degree of parallelism to two times the number of CPUs, then tune from there.
-- For Data Pump Export, the PARALLEL parameter value should be less than or equal to the number of dump files.
-- For Data Pump Import, the PARALLEL parameter value should not be much larger than the number of files in the dump file set.
Can we get a dumpfile of a particular size?
How to take certain amount of data backup from a table ?
Encrypted export and import ?
Does archive gets generated during export and import ? If yes, in case a lot of archive is getting generated then what do we do ?
Is UNDO tablespace used during export and import?
Is TEMP tablespace used during export and import ?
How to stop archive log generation while import is running ?
In schema refresh, will be dblinks be copied ?
What is direct=y in export and import?
can we refresh and entire database new/existing using full=y ?
When I drop a 1 TB table where does it reside ?
which tablespace it takes while dropping a table ?
Snapshot too old error during export/ import ?
How do I stop archiving in Oracle ?
How to kill- start/stop , decrease/increase parallel in export/import?
If we want to export only 1000 roes of table during export ? what is the command?
How is the CPU used when running export and import?
When we run an export/import how do we know which process is running which data ?
No comments:
Post a Comment