I need to create an alert on my application table when it reaches 98% of its threshold. I wrote an SP which checks the rows and logs the information into a log file which was monitored by alert system and that raised alarms successfully.
But now my DBA team is saying they cannot grant the application DB user read/write privileges on UTL_FILE
in production. And OEM (Oracle Enterprise Manager) can't be used at application level.
- What are my options?
- How can I get an alert on table size?
Reference: UTL_FILE
With the UTL_FILE package, PL/SQL programs can read and write operating system text files. UTL_FILE provides a restricted version of operating system stream file I/O.