Wednesday, December 17, 2014

Exadata: Shared Server Connect Prevents Offloading To Storage Cells (Doc ID 1472538.1)

Interesting article:
no offloading (aka Smart Scan) is performed for sessions connected via Shared Server.
Because such sessions cannot use DirectRead which is required for offloading.
In is not a bug, it is a feature.





No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...