I have this procedure that is constantly running and works with LOBS.
Although there is a temporary lob creation/destroy code, I see that
every time this procedure finishes a loop, the value of temporary lobs
attached to this sid gets incremented by 4 (in v$temporary_lobs).
Is there any way we could trace at what stage lobs get created and why
they don't get destroyed? The program pseudo code is as follows ...
While 1=1
Loop
- dequeue message from AQ, the payload is a CLOB declared as a type.
- Create a temporary lob
- assign payload to this temp_lob
- message the data
- pass this lob (as nocopy) to another procedure within the same
package
- This procedure works on the contents and completes processing
- On success of this procedure execution, destroy the temporary lob
- loop back.
End loop;
TIA
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Apr 21 2004 - 11:05:35 CDT
