Flushing session UNDO

[KenEwald]

Is there a way to flush session undo?

Our connection pool sessions are retaining lob locators in undo for the life of the session and eventually causing ora-1555 errors.

-Ken

[KenEwald]

And, these are "out of line" lobs

[hrishy]

Hi

Whats the output of

select table_name, column_name, pctversion, retention
from user_lobs

regards

[gandolf989]

You can manually release the pointers in your code.
This looks like a coding issue, not a database issue.

[KenEwald]

HCAW_ADMIN AW$HC_AW AWLOB 0 10800
CUSTAW_ADMIN AW$CUST_AW AWLOB 0 10800
REGRESS_AW AW$REGRESS_AW AWLOB 0 10800
Q12_AW AW$Q12_AW AWLOB 0 15000
CUST_AW AW$CUST_AW AWLOB 0 15000
HC_AW AW$HC_AW AWLOB 0 15000
Q12AW_ADMIN AW$Q12_AW AWLOB 0 15000

What does the syntax look like for manually releasing pointers?