If you have a performance problem and don't have license to use Active Session History
you can use a free version of it. It is not using a direct SGA access but it is designed by Kyle Hailey
- one of OEM Performance tab designer.
When I read about direct access to X$ table using a oradebug utility on
Miladin Modrakovic's blog I started to wonder if this two technologies can be combined.
Unfortunately I have tested direct access using oradebug and CPU usage is unexpected high on my VM machine and in that case direct access can disrupt our observations.
Oracle OpenWorld 2015 - Oracle OpenWorld 2015 is nearly here! Come and see our session on Monday, entitled *The Next Generation of the Oracle Optimizer...and How You Can Use It ...
5 weeks ago