Question related to temporary lobs
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 12:08:12 -0400
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
1. dequeue message from AQ, the payload is a CLOB declared as a type.
2. Create a temporary lob
3. assign payload to this temp_lob
4. message the data
5. pass this lob (as nocopy) to another procedure within the same
package
6. This procedure works on the contents and completes processing
7. On success of this procedure execution, destroy the temporary lob
8. 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
