Toad World® Forums

Profiler and Parallel Pipelined functions


#1

All

I’m working on a parallel pipelined function in Oracle 10.2.0.4. Is there
any way to use the profiler to determine how many slave process the function is
being executed on at once? i.e. a way of determining the parallelism of the
function in use.

Regards,

Mike McAllister

Principal Systems Engineer

TKC Global, LLC

Phone: 512 423 7447

Email: michael@pairofsixes.com

smime.p7s (5.14 KB)


#2

I don’t know about the profiler, but If the function takes enough time,
you should be able to find it in the session browser and see how many parallel
slaves it has.


#3

Martin – got your email, thanks for the info. I’m not going to be
using my function in a job, it’s going to be embedded in an SQL statement
being used by an ETL tool.

John – I did manage to modify my function to return the SID as part of the
output record, which ends up showing which records came from which slave
process. It ends up that as I’m using the function it’s not being
run in parallel for some reason. I’ll have to do some more investigation.
smime.p7s (5.14 KB)