|
-
Re: Re: Re: EXP, consistent=y equals large rollback segs, why?
Originally posted by slimdave
I believe that it's "serializable",not "read only".
It's READ ONLY, not SERIALIZABLE.
SET TRANSACTION READ ONLY does two things, it inititiates a transaction, and it assigns a start SCN for the transaction. That start SCN will be used for any query executed in the course of the transaction.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: [email protected]
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
|