RE: Transportable tablespace set checks...
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <bbel5@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Mar 2009 23:59:22 +0100
One easy way to check would be to actually run both the options and see
which takes less time.
Regards,
Vishal Gupta
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bellows, Bambi
(Comsys)
Sent: 26 March 2009 20:42
To: oracle-l@xxxxxxxxxxxxx
Subject: Transportable tablespace set checks...
Hey there Gang!
Do you gain a substantial amount of time if you string together
tablespaces to do the transport_set_check for as opposed to running them
serially?
For example, if I were to run
exec sys.dbms_tts.transport_set_check('AAA1,AAA2,AAA3...AAA54');
would it be substantially faster than running:
exec sys.dbms_tts.transport_set_check('AAA1');
exec sys.dbms_tts.transport_set_check('AAA2');
exec sys.dbms_tts.transport_set_check('AAA3');
... exec sys.dbms_tts.transport_set_check('AAA54');
?
TIA!
Bambi.
Other related posts:
