Search Oracle Blogs
Tuesday, October 24, 2006
Oracle 11g new features
I have found Laurent post on 11g new features very interesting. Let me comment on some items:
Paweł
- /*+result_cache*/ is very promising. From description it seems that it might be very useful for web applications based on Oracle. But sentence "There is an aggressive cache invalidation, so whatever DML happens on one dependent table, the cache result is invalidated" suggest that it will be useful only in read only environment. Otherwise cache will be constantly invalidated making this feature useless. Question is if query results will be stored in new memory structure, or it will be in Buffer Cache? Anyway there might be need for huge RAM
- Using sequence in PL/SQL without DML. This is long time expected feature
- Trigger order. This can be also sometimes useful.
Paweł
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment