Database Administration (MOSC)

MOSC Banner

12cR2 multitenant dba_scheduler_global_attribute - default_timezone

edited May 23, 2019 2:54AM in Database Administration (MOSC) 9 commentsAnswered ✓

Hi Guys,

Need your advise here.

I have 1 CDB with 1 PDB created.

The daily auto task maintenance job (eg: daily gather stats) run at 10pm GMT +8 which is normal.

However, for the PDB it actually start at 10pm UTC. (meaning that it will run at 6am GMT +8)

Upon investigation, i notice the below. The default_timezone for the scheduler is different between the CDB and PDB.

Is this a expected behavior?

I would expect that the PDB created would have similar scheduler defaullt_timezone as the CDB.

Anyone having the same issue like mine?

thanks

SQL> show con_name;

CON_NAME

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center