Running product against ASM instance increases kernel parameter fs.aio-nr until error ORA-27090 Unab
Hi,
We have a customer who is getting "ORA-27090 Unable to Reserve Kernel Resources" on an asm instance when they run our monitoring product against this instance. Our product runs a number of queries, 2 of which are below.
SELECT dg.NAME, d.group_number, d.operation, d.state, d.POWER, d.actual,
d.sofar, d.est_work, d.est_rate, d.est_minutes
FROM v$asm_diskgroup dg LEFT OUTER JOIN gv$asm_operation d
ON (d.group_number = dg.group_number)
SELECT dg.NAME, dg.total_mb, dg.free_mb, dg.usable_file_mb
FROM v$asm_diskgroup dg