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>
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