Oracle-L: RE: User Package

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Tue, 12 Nov 2002 14:33:56 -0800
Message-ID: <F001.005018A0.20021112143356@fatcity.com>

There is no simple answer to that. You will have to look at what the package does and tune it. Maybe if you post the package (if it's not too big) then people can offer suggestions. SQL tuning can give you amazing results.

Richard

-----Original Message-----

Sent: Tuesday, November 12, 2002 4:54 PM To: Multiple recipients of list ORACLE-L

Hi
I am having one of user created packages.Whenever this package executed by users the CPU utilisation on BOX high.How to fix this package problem thx
-Seema

STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seema Singh
INET: oracledbam_at_hotmail.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.com
--

Author: Richard Ji
INET: richard.ji_at_mobilespring.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