Shulou(Shulou.com)05/31 Report--

This article will explain in detail the impact of time zone adjustment on the running time of job. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

The time zone can be adjusted either in the operating system or in session, so do different ways have an impact on the planning time of job?

Let's use a practical example to verify it:

Test1:

1. First, take a look at the default system time zone:

Oracle@fmw11g.vm.oracle.com $date

Sat Nov 19 03:50:10 GMT 2016 'STORED_PROCEDURE'

Job_action = > 'JOB_PRO_TEST1'

Start_date = > sysdate + 1Comp24, true

);

End

/

Operational status of 3.check job

Select owner,job_name,job_action,start_date, state from ALL_SCHEDULER_JOBS where owner='MAOB'

MAOB

TJ1 JOB_PRO_TEST1

11xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx + 00:00

SCHEDULED

Sysdate + 1 take 24, true

);

End

/

Operational status of 3.check job

Select owner,job_name,job_action,start_date, state from ALL_SCHEDULER_JOBS where owner='MAOB'

MAOB

TJ2

JOB_PRO_TEST1

11According to 19XX 2016 4 54 purl 34.000000 AM + 08:00

RUNNING

'STORED_PROCEDURE'

Job_action = > 'JOB_PRO_TEST1'

Start_date = > sysdate + 1Comp24, true

);

End

/

Operational status of 3.check job

Select owner,job_name,job_action,start_date, state from ALL_SCHEDULER_JOBS where owner='MAOB'

MAOB

TJ3

JOB_PRO_TEST1

11xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx + 08:00

SCHEDULED

The new job is scheduled at 1:02:57 Beijing time, which officially meets the requirements.

To sum up, normally adjusting the time zone at the operating system level will not affect the job time, but for adjusting the time zone through alter sessoin

You need to be careful, because server process is still the time when fork gets up (GMT) We suddenly changed the time zone of session, but the time

It won't change, so start_date becomes a combination of GMT time and new time zone.

So much for sharing about the impact of time zone adjustment on the running time of job. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.