Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> updating TS$?????

updating TS$?????

From: Joseph S Testa <>
Date: Fri, 09 May 2003 07:07:13 -0800
Message-ID: <>

Unsupported is an understatement, just because something "seems" to work (for an extended time evidently) doesn't make it right to do. Unless you know ALL of the underlying ramifications(which i doubt you do), make your resume be ready to hit the streets at a moments notice.

I guess i dont see why you dont drop first and then import, gosh thats what makes transportable tablespaces quick, you're only importing metadata. Guess I'm missing something here.

PS: Its all fun till someone gets pregnant(or the database dies)

>We are doing this to make our transportable tablespace process simpler.
>We import the transported tablespace. Drop the old one. Rename the new

>Anyone else do this? Any pitfuls other than the shock and awe of us
>touching TS$? I know its not supported.

>For those of you who hate this idea, they've been doing it since before
>I got here. Just looking for outside opinions on this.

What if I don't have SQL in my pl/sql procedure? OP was trying to find why and where his code was looping. Where in pl/sql code there was wastage.

I have been using 10046 for a couple of years, I have done pl/sol for over 6 years, please show me how using 10046 you would find bad pl/sql when there is no single SQL statement in the code.

I am not doubting you, please educate me.


Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Thursday, May 08, 2003 8:07 PM
To: Multiple recipients of list ORACLE-L

Sorry, but your statement that " for pl/sql you have no choice other than dbms_profiler" is incorrect.
I have not challenged the usefulness of dbms_profiler. But I have now been told twice that you can't use 10046 trace for pl/sql and if you believe that you can't get useful information out of a 10046, level 8 trace for a pl/sql job then you are cheating yourself. Let's look again at the original question. For a batch job running pl/sql the user wanted to see: -- the execution plans and costs for all the code it submits I can't find the execution plans/costs using profiler. I could be in for some education here, maybe it's there and I'm just not seeing it. -- memory used
I can't find this using either tool.
-- cpu used
I can't find this in dbms_profiler output, but it is in 10046 trace. -- time to complete.
Clearly available in both. However, a lot more detail of events appears available in 10046.

I only continue to respond to this because I hate for someone who may have never used either tool to get the idea that if tasked with troubleshooting performance of a job that uses pl/sql they cannot use a 10046 trace. That would potentially be a huge part of a DBA's or a developer's world in which they would be limiting themselves. Is it the end all solution? Absolutely not. Is it going to help solve every pl/sql or sql problem? Absolutely not. Is it, in general, a useful tool to use with sql AND pl/sql? Absolutely!!


Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

Please see the official ORACLE-L FAQ:
Author: Joseph S Testa

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri May 09 2003 - 10:07:13 CDT

Original text of this message