Measure Perfomance of a Declared Cursor

From: webtourist <webtourist_at_gmail.com>
Date: Mon, 4 Aug 2008 15:36:51 -0700 (PDT)
Message-ID: <a1647581-7383-4a3b-aa02-e5f984e9bf28@m45g2000hsb.googlegroups.com>


<10gR2>

Given a package containing code like:

<code>

FOR i IN some_declared_cursor ( 'foo')
LOOP
  ..... whole bunch of processing

</code>

I need to measure the performance of JUST the cursor "some_declared_cursor"
How to time it ?
And what would be the best method ?

thanks Received on Mon Aug 04 2008 - 17:36:51 CDT

Original text of this message