High CPU Usage in SOA 220.127.116.11 due to Full Table Scan
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Platform - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
a) SOA consumes considerable CPU resources.
b) AWR reports shows Full Table Scan on COMPONENT_INSTANCE table.
The problem can be observed when the MDS repository grows in size.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms