Without knowing in detail what flows and usage pattern the application is supposed to have I can give a general answer.We have customers with similar volumes and Oracle is generally good at handing larger volumes.Some advice given the data volumes you are talking about is to use custom query's carefully, in some cases indexes might need to be customized as well.
If you look in your top SQL you might see: select toid from type$ where… It is related to metadata loading in Aurena and consumes quite some resources during metadata load. This is due to a bug in Oracle which can be resolved by applying a patch. Basically the patch solves a missing sys index. Search Bug 25154887 : RECURSIVE QUERIES ON TYPE$ RUN DURING DESC SLOW IN 12C in Oracle Metalink. //Fredrik
Hi,Could you if possible get a statpack report for that system during the time period when the problem occur. Could you also describe the typical user behavior during this time frame? Send the statpack report to me for further investigations in IFS Benchmarking lab.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.