> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/reference/configuration-files/how-to-set-database-specific-initialization-options.md).

# How to Set Database Specific Initialization Options

In certain configurations it may be necessary to run specific SQL statements or set database specific options each time a connection to a database is established.

## Oracle

The configuration file “Oracle.xml” contains parameters that control connections made to Oracle. The following configuration directives are supported:

* InitSQL — specify a line of SQL that will be run each time a new connection to Oracle is established. There is no limit to the number of InitSQL elements.

The following Oracle.xml file will cause CopyStorm to run the command:

* `alter session set ‘_optimizer_rownum_pred_based_fkr’=FALSE`

Oracle.xml:

```
<Oracle>
    <InitSQL sql="alter session set &quot;_optimizer_rownum_pred_based_fkr&quot;=FALSE" />
</Oracle>
```