Database Tuning (MOSC)

MOSC Banner

how to show function calls from tkprof on Oracle 11G?

edited Nov 2, 2011 11:16AM in Database Tuning (MOSC) 1 commentAnswered
Hi,

I have a procedure p1 which in turn call other functions in a query.  I like to get info about the function calls and the execution plans, cup time. elaspsed time etc for the queries inside the function. But when I run tkprof on the procedure p1, I don't see theese function calls from tkprof trace files. It worked on 10G but not working on 11G

My database is 11.2.0.2 on Linux

The code is something llike this:

PRODCEDURE p1

IS

BEGIN

select  cust_name, fi(cust_id) as total_purchaes

from customer;

END;/

Where f1 is a function like

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center