Oracle Cloud Infrastructure Documentation

DB System Time Zone

Note

This topic applies only to Exadata DB systems.

The Time Zone field in the Console and in the API allows you to launch an Exadata DB system with a time zone other than UTC (the default). Although UTC is the recommended time zone to use, having a common time zone for your database clients and application hosts can simplify management and troubleshooting for the database administrator.

The time zone that you specify when you create the DB system applies to the host and to the Oracle Grid Infrastructure, and controls the time zone of the database log files. The time zone of the database itself is not affected, however, the database’s time zone affects only the timestamp datatype. By default, it is set to UTC and although you can change it manually, Oracle recommends that you keep it as UTC to avoid data conversion and improve performance when data is transferred among databases. This is especially important for distributed databases, replication, and exporting and importing.

Time Zone Options

Whether you use the Console or the API, the time zone options you can select from are represented in the named region format, for example, America/Los_Angeles. The Console allows you to select UTC, the time zone detected in your browser (if your browser supports time zone detection), or an alternate time zone.

To specify an alternate time zone (the Select Another Time Zone option), you first select a value in the Time Zone Prefix field to narrow the list of time zones from which to select in the Time Zone Suffix field. In the America/Los_Angeles example, America is the time zone prefix and Los_Angeles is the time zone suffix. The items you see in the Time Zone Prefix and Time Zone Suffix fields roughly correlate with the time zones supported in both the Java.util.TimeZone class and on the Linux operating system. If you do not see the time zone you are looking for, try selecting "Miscellaneous" as the time zone prefix.

Tip

If you are using the API and would like to see a list of supported time zones, you can examine the time zone options in the Console. These options appear in the Launch DB System dialog when you show advanced options after you select an Exadata DB system shape.

Changing Time Zones After Provisioning

Follow these steps if you need to change the time zone of the Exadata DB system, Oracle Grid Infrastructure, or database, after you launch the DB system:

To change the time zone of the DB system host
To change the time zone of the Oracle Grid Infrastructure
To change the time zone of a database