|
-
Sure enough the ALERT log shows Undo segs being onlined and offlined to cope with all this. Good call JM - the link explained it perfectly and the example works like a dream.
It doesn't lock existing UNDO, rather creating new segments every time a SELECT opens a query over the link, for the duration of that 'transaction'.
Who'd a thunk it, eh?
Do you think 99.999999999% of developers (or even 90% of DBA's!!!) would know about this? 
Let's just shoot everyone.
Last edited by JMac; 01-20-2005 at 06:30 AM.
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
|
Reply With Quote