Autonomous Database - comments

Changing time zone
Default Autonomous Database Time Zone

The default Autonomous Database time zone is Coordinated Universal Time ‎(UTC)‎ and by default calls to SYSDATE and SYSTIMESTAMP return the date and time in UTC.

In order to change database time zone, you can run the following statement. 

This example sets the database time zone to UTC-5.

ALTER DATABASE SET TIME_ZONE='-05:00';

Note:

You must restart the Autonomous Database instance for the change to take effect.
After you set the database time zone, by default SYSDATE and SYSTIMESTAMP continue to return date and time in UTC (SYSDATE_AT_DBTIMEZONE is FALSE by default). If you set SYSDATE_AT_DBTIMEZONE to TRUE in a session, SYSDATE and SYSTIMESTAMP return the database time zone.


No comments:

Stopping Global cache blocks lost metric



From Metalink


https://support.oracle.com/epmos/faces/DocumentDisplay?id=2543134.1&displayIndex=1


SOLUTION

cd <OMS_HOME>/bin

$emcli login -username=sysman

$emcli sync

$emcli modify_collection_schedule -targetType="oracle_database" -targetNames="<DBInstanceName>" -collectionName="rac_global_cache_10i" -collectionStatus=Disabled -preview="N"

Real world example

[oracle@oms1 bin]$ $OMS_HOME/bin/emcli login -username=sysman -password=.......

Login successful

[oracle@oms1 bin]$ $OMS_HOME/bin/emcli sync

Synchronized successfully

[oracle@oms1 bin]$ emcli modify_collection_schedule -targetType="oracle_database" -collectionName="rac_global_cache_10i" -collectionStatus=Disabled -preview="N" -targetNames="DemoDB"

Collection Name : rac_global_cache_10i

DemoDB : Collection Schedule updated successfully.

The collection schedule of the following metrics might be affected :

rac_global_cache



No comments:
Subscribe to: Posts (Atom)