Transportable tablespace set checks...

  • From: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Mar 2009 15:42:19 -0500

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: