Skip to Main Content
  • Questions

  • ORA-27465 when setting File Watcher's attribute steady_state_duration a value less that 10 second

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Chris Saxon

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)

We're not taking comments currently, so please try again later if you want to add a comment.

Comments

Constantinos Constantopoulos, October 25, 2016 - 11:31 am UTC


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.