Thanks for the question, Constantinos.
Asked: October 09, 2016 - 9:11 am UTC
Last updated: October 09, 2016 - 11:02 am UTC
Version: RDBMS 11.2.0.4 Enterprise Edition
Viewed 1000+ times
You Asked
Hi,
I am trying to set an interval of 5 seconds to steady_state_duration while creating a file watcher or change the interval to an existing file watcher.
BEGIN
DBMS_SCHEDULER.CREATE_FILE_WATCHER (
file_watcher_name => 'TEST_FILEWATCHER',
directory_path => '/tmp',
file_name => '*.txt',
credential_name => 'SYS.WATCH_CREDENTIAL',
destination => NULL,
min_file_size => 0,
steady_state_duration => INTERVAL '9' SECOND,
comments => NULL,
enabled => false);
END;
ORA-27465: invalid value +000000000 00:00:09 for attribute STEADY_STATE_DURATION
ORA-06512: at "SYS.DBMS_ISCHED", line 3715
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2633
ORA-06512: at line 2
If I set steady_state_duration => INTERVAL '10' SECOND then it works fine.
I can't find information for steady_state_duration low limit...
and Connor said...
This is a limitation that was not documented. The documentation was corrected in 12c
"Minimum time interval that the file must remain unchanged before the file watcher considers the file found. Cannot exceed one hour. If NULL, an internal value is used. The minimum value is 10 seconds. Oracle recommends similar steady_state_duration values for all file watchers for efficient file watcher job operation. Also, the repeat interval of the file watcher schedule must be equal or greater than the steady_state_duration value."
Hope this helps
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment