Home » RDBMS Server » Performance Tuning » Regarding dba_scheduler_windows (Oracle 19c)
Regarding dba_scheduler_windows [message #689099] Thu, 21 September 2023 04:17 Go to next message
shipon_97
Messages: 17
Registered: March 2008
Junior Member
Dear Friends ,

I am using Oracle19c database .

I need to have some queries regarding dba_scheduler_windows views .

I have confused about the field name 'DURATION; from "dba_scheduler_windows" view .

 As per oracle doc it means "Duration of the window" .
I found some value already mentioned here by system default .

my question ,

1. If DURATION is 2 hours , then what happen ? all necessary tasks will completed within 2 hours . But if it is not possible to complete
within this 2 hours , what will be happen ?

2. why DURATION is more for the WONDOW of SATURDAY and FRIDAY ?

Waiting for kind reply .. ..
Re: Regarding dba_scheduler_windows [message #689100 is a reply to message #689099] Thu, 21 September 2023 05:58 Go to previous message
John Watson
Messages: 8917
Registered: January 2010
Location: Global Village
Senior Member
1. If you look up the dbms_scheduler.set_attribute procedure, this should become clear.
2. I'm guessing that you are referring to the default maintenance windows. All the detail is here:
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-automated-database-maintenance-tasks.html

(btw, I wish you wouldn't say "field" when you mean "column" Smile  )

[Updated on: Thu, 21 September 2023 05:59]

Report message to a moderator

Previous Topic: How to reduce query Cost
Next Topic: SQL Profiles after upgrade from 11g to 19c
Goto Forum:
  


Current Time: Mon Mar 04 22:55:04 CST 2024