RE: Transportable tablespace set checks...

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Mon, 30 Mar 2009 23:59:22 +0100
Message-ID: <787DD2F284E39D4FA3C2ABD2DAF1AB2D014ED4_at_MAIL.vishalgupta.co.uk>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bellows, Bambi (Comsys)
Sent: 26 March 2009 20:42
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l

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