Wow. I could have expected that from the old DB Control, but not that kind of load using DB Express.
I had noticed the CDB$VIEW being 'heavy' when I first looked at it, but didn't pursue it as there were too many other interesting things to look at. I would hope that it's been addressed with PS1
Thanks for identifying that /Hans On 17/09/2014 10:16 PM, Stojan Veselinovski wrote:
Oracle Enterprise Manager Database Express (EM Express). http://docs.oracle.com/database/121/ADMQS/em_manage.htm#ADMQS031Stojan www.stojanveselinovski.com/blog <http://www.stojanveselinovski.com/blog> www.stojanveselinovski.com <http://www.stojanveselinovski.com>On Thu, Sep 18, 2014 at 2:03 PM, Hans Forbrich <fuzzy.graybeard@xxxxxxxxx <mailto:fuzzy.graybeard@xxxxxxxxx>> wrote:On 17/09/2014 9:33 PM, Stojan Veselinovski wrote:What I found interesting is managing these pdbs with DB control was chewing up to 50% of the available cpu at times with parallelqueries over the CDB_ views.DB Control? Do you mean EM Control Light or Cloud Control? /Hans