Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about Dual
I'd guess its reduction in latching costs. There's no such thing as consistent read with x$
tables, so you don't need to latch them etc etc - you just go grab the data and you're done.
Interestingly, Oracle seem to have "given up" on people's predilection with unneccesarily querying from dual. In v10, there's a new optimization which skips the query to dual altogether.
Cheers
Connor
Coming Soon! "Oracle Insight - Tales of the OakTable"
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
-- To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/Received on Sun Sep 12 2004 - 05:15:26 CDT
![]() |
![]() |