-
Flushing session UNDO
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
-
And, these are "out of line" lobs
-
Hi
Whats the output of
select table_name, column_name, pctversion, retention
from user_lobs
regards
-
You can manually release the pointers in your code.
This looks like a coding issue, not a database issue.
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|