Sample Header Ad - 728x90

Alert on Table size

4 votes
2 answers
281 views
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.
Asked by Sakshi Sharma (41 rep)
Sep 19, 2017, 09:50 AM
Last activity: May 12, 2025, 04:07 AM