Temporary LOBs, temp space, PGA [message #667123] |
Fri, 08 December 2017 06:13 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If I create a temporary LOB with dbms_lob.createtemporary and load it up with 50MB or so of data, it always goes to a temporary segment. This is indeed the documented behaviour:Quote:CREATETEMPORARY Procedures
This procedure creates a temporary BLOB or CLOB and its corresponding index in your default temporary tablespace. Is there some way to prevent this, so that it will remain in PGA rather than going to disc? I had hoped that giving myself a massive PGA (not just with pga_aggregate_target, I've tried _pga_max_size and _smm_max_size too) would help, but no good. Whether I create the LOB to go through buffer cache or not doesn't make any difference, neither does changing workarea_size_policy..
I realize that what I would like to do may be impossible, but if anyone has an idea to keep temporary LOBs in PGA only that would be very useful.
Thank you for any insight.
|
|
|
|
|
|