RE: Transportable tablespace set checks...

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: