# Oracle Database optimization pack

The Oracle Database optimization pack allows monitoring of an Oracle instance and exploring the configuration space of its initialization parameters. In this way, an Akamas study can achieve goals such as maximizing the throughput of an Oracle-backed application or minimizing its resource consumption, thus reducing costs.

The main tuning areas covered by the parameters provided in this optimization pack are:

* SGA memory management
* PGA memory management
* SQL plan optimization
* Approximate query execution

The optimization pack also includes metrics to monitor:

* Memory allocation and utilization
* Sessions
* Query executions
* Wait events

## Component Types

These component types model different Oracle Database releases, either as on-premise or cloud solutions. They provide the initialization parameters the workflow can apply through the [OracleConfigurator operator](/akamas-docs/3.1.2/akamas-reference/workflow-operators/oracleconfigurator-operator.md), and a set of metrics to monitor the instance performances.

Notice that for the Oracle Database hosted on Amazon RDS, a subset of initialization parameters can be applied in the workflow to interact with the [RDS API interface](https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_ModifyDBParameterGroup.html).

| Component Type                                                                                                                                                                  | Description                       |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------- |
| [Oracle Database 12c](/akamas-docs/3.1.2/akamas-reference/optimization-packs/oracle-database-pack/oracle-database-12c.md)                                                       | Oracle Database 12c               |
| [Oracle Database 18c](https://gitlab.com/akamas/documentation/akamas-docs/-/blob/3.1.2/akamas-reference/optimization-packs/oracle-database-pack/oracle-database-18c.md)         | Oracle Database 18c               |
| [Oracle Database 19c](https://gitlab.com/akamas/documentation/akamas-docs/-/blob/3.1.2/akamas-reference/optimization-packs/oracle-database-pack/oracle-database-19c.md)         | Oracle Database 19c               |
| [RDS Oracle Database 11g](/akamas-docs/3.1.2/akamas-reference/optimization-packs/oracle-database-pack/rds-oracle-database-11g.md)                                               | Oracle Database 11g on Amazon RDS |
| [RDS Oracle Database 12c](https://gitlab.com/akamas/documentation/akamas-docs/-/blob/3.1.2/akamas-reference/optimization-packs/oracle-database-pack/rds-oracle-database-12c.md) | Oracle Database 12c on Amazon RDS |

## Installing

Here’s the command to install the Oracle Database optimization pack using the Akamas CLI:

```bash
akamas install optimization-pack oracle-database
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.akamas.io/akamas-docs/3.1.2/akamas-reference/optimization-packs/oracle-database-pack.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.