How to Change the Default Oracle Database Memory Parameter to Improve Query Response Time ?
Last updated on JUNE 14, 2017
Applies to:Oracle Communications Performance Intelligence Center (PIC) Software - Version 9.0.3 and later
Information in this document applies to any platform.
Oracle Database on Storage server is configured to use only 8GB of RAM whatever the hardware configuration of the server. As some servers are configured with 24GB (HP G6) or 32 GB (HP Gen8) we can allocate more memory to Oracle instance to boost the query response time.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms