Database Administration (MOSC)

MOSC Banner

DB Parameters for AWS instance type change

edited Dec 27, 2017 3:27PM in Database Administration (MOSC) 5 commentsAnswered

Hi All,

We will be running an Oracle 12c Linux DB Instance on AWS EC2 for a specific application.

Prior to an application upgrade, we would like to increase the CPU/Mem and potentially the EBS IOPS to expidite the app upgrade based on a higher instance type.

Currently:

MEMORY_TARGET is set to 0

SGA_TARGET is set appropriatly

PGA_AGGREGATE_TARGET is set appropriatly

STREAMS/JAVA/LARGE/BUFFER/SHARED POOL are set appropriatly

JOB_QUEUE_PROCESSES is set to 10 (cpu_count is 2)

Assumptions:

-cpu_count would automatically adjust with higher instance type

-parallel parameters would automatically adjust with higher instance type

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center