Ryan,
I use it extensively ... for some of the utilities I wrote for application support ...
here is one sample ...
This utility shows errors in the pl/sql code, what's different is not only it shows
the errors, but also shows the source lines and exact location of the error.
To test, install
I recently rewrote a poor-performing data load procedure (with single row
inserts, commit batches of 2000) to a pipelined table function, which
enabled insert /*+ append */ into the target table, which greatly enhanced
performance. The original routine contained an embedded select, a second
by: [EMAIL PROTECTED]
12/31/2003 09:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: anyone use pipelined functions?
I recently rewrote a poor-performing data load procedure (with single row
inserts, commit batches
[EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each
PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each would
:
Subject:Re: anyone use pipelined functions?
In the interests of documentation, and if I have time, I could engineer a
similar 'dumb' procedure, perform trace as each modification is made, and
post the results here. It's pretty easy to come up with an artificial
routine, though, to do
recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes
]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
That would be cool if you have time for it.
Re the sequence: is it assigned in a trigger, or directly in the SQL?
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:19
My responses below are below
Ryan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:54 AM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
great response. questions inline
My responses below are below -- sigh, it's been a long day. lol
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
My responses
10 matches
Mail list logo