RE: Transportable tablespace set checks...

From: Vishal Gupta <>
Date: Mon, 30 Mar 2009 23:59:22 +0100
Message-ID: <>

One easy way to check would be to actually run both the options and see which takes less time.  


Vishal Gupta  

[] On Behalf Of Bellows, Bambi (Comsys)
Sent: 26 March 2009 20:42
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.

Received on Mon Mar 30 2009 - 17:59:22 CDT

Original text of this message