Its not my idea, so I dont have to make my resume ready. Im just asking about it.
>
> From: "Joseph S Testa" <jtesta_at_dmc-it.com>
> Date: 2003/05/09 Fri AM 11:07:13 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: updating TS$?????
>
> 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.
>
> Joe
> 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
> >one.
>
> >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.
>
> Raj
> --------------------------------------------------------------------------------
> 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!!
>
> DL
>
>
>
>
>
> Joseph S Testa
> Chief Technology Officer
> Data Management Consulting
> p: 614-791-9000
> f: 614-791-9001
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joseph S Testa
> INET: jtesta_at_dmc-it.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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:32:23 CDT
