Transportable tablespaces

From: Vikas Agnihotri <usenet_at_vikas.mailshell.com>
Date: Sat, 16 Oct 2004 12:47:55 -0400
Message-ID: <2td1h9F1udlniU1@uni-berlin.de>

Has anyone used the transportable tablespace feature in 9.2.0.4?

I am trying to run the dbms_tts.transport_set_check() API specifying 2 tablespaces. Total of about 100 objects, no IOTs, no LOBs, no partitioned tables.

The API takes 50 minutes to run! When I trace it, I see the following stand out

Is anyone else seeing this or is this something in my environment?

Thanks

SELECT obj1_owner,obj1_name,obj1_subname,obj1_type,ts1_name,obj2_owner,

   obj2_name,obj2_subname,obj2_type,ts2_name,constraint_name,mesg_id FROM
  pluggable_set_check WHERE ((ts1_name NOT IN (select tbs from    sys.transts_tmp$)) AND (ts2_name IN (select tbs from sys.transts_tmp$))) OR

((ts2_name = '-1') AND (ts1_name IN (select tbs from
sys.transts_tmp$))) OR

((ts1_name IN (select tbs from sys.transts_tmp$)) AND (ts2_name NOT IN
   (select tbs from sys.transts_tmp$)) AND (mesg_id = 4))

call     count       cpu    elapsed       disk      query    current 
     rows

------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      3.22       3.14          0         22          0 
        0
Execute      1      0.01       0.01          0          0          0 
        0
Fetch        1   3062.20    2998.21       1249     255703          0 
        0

------- ------ -------- ---------- ---------- ---------- ----------

---

total        3   3065.43    3001.36       1249     255725          0 
        0

Received on Sat Oct 16 2004 - 11:47:55 CDT