Scheduler Time Zone
Before doing that, we have make sure the time zone region you want to set is valid for Oracle.
Then we change the default time zone (DEFAULT_TIMEZONE) of scheduler in database as following.
SQL> exec dbms_scheduler.set_scheduler_attribute('default_timezone', 'Asia/Hong_Kong');
PL/SQL procedure successfully completed.
You can see more usages about DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE procedure in documentation.
Then check scheduler default time zone again.
SQL> select dbms_scheduler.stime from dual;
STIME
---------------------------------------------------------------------------
09-MAR-22 09.53.38.123446000 AM ASIA/HONG_KONG
We're good.
Please note that, STIME is a function of DBMS_SCHEDULER, which can display current scheduler time stamp with time zone.