Search notes:

Oracle: File Watchers

A file watcher is a scheduler object that triggers the scheduler to start a job when a file with a given name and location «arrives».
By default, a file watcher checks for new file arrivals every 10 minutes.
A file watcher object is created with dbms_scheduler.create_file_watcher.
In order to use file watchers, the database Java Virtual Machine (JVM) component must be installed.

Change the default exection interval

Change the default execution interval to one minute: 
begin
 
   dbms_scheduler.set_attribute(
      'file_watcher_schedule',
      'repeat_interval',
      'freq=minutely; interval=1'
   );
 
end;
/

See also

An example for a file watcher
Troubleshooting file watcher problems.
dbms_ischedfw
Under the hood of file watchers.
$ORACLE_HOME/rdbms/admin/initscfw.sql
The .NET class System.IO.FileSystemWatcher.
Database objects

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740463505, '18.119.135.208', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/objects/file/watchers/index(78): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78