Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: execution plan of a stored procedure

Re: execution plan of a stored procedure

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 10 Jan 2005 15:29:39 -0800
Message-ID: <41e30eb8$1_3@127.0.0.1>


supoman_at_yahoo.com wrote:

> You will have an execution plan for each sql in your procedure so in
> order to see the true cost you'll next to pull them out of the proc and
> generate a paln for each.

Not necessary:

Go to http://www.psoug.org
click on Morgan's Library
click on DBMS_PROFILER

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Received on Mon Jan 10 2005 - 17:29:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US