How to Change the Default Oracle Database Memory Parameter to Improve Query Response Time ? (Doc ID 2062990.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 9.0.3 and later
Information in this document applies to any platform.

Goal

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.

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

How to Change the Default Oracle Database Memory Parameter to Improve Query Response Time ? (Doc ID 2062990.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!