Hi there,
we have multiple 'parse errors' in our Oracle 12.2 environment log like the next snippet:
2019-11-13T03:21:48.639430+01:00
WARNING: too many parse errors, count=3978 SQL hash=0x78cd8680
PARSE ERROR: ospid=21771, error=942 for statement:
2019-11-13T03:21:48.639908+01:00
select dg.inst_id, dg.name, sum(reads), sum(writes), avg(read_time), avg(write_time), sum(bytes_read), sum(bytes_written) from gv$asm_disk_stat ds, gv$asm_diskgroup dg where ds.group_number=dg.group_number and ds.inst_id=dg.inst_id group by dg.inst_id, dg.name
Any help or advice is welcome.
Regards,
Harry
we have multiple 'parse errors' in our Oracle 12.2 environment log like the next snippet:
2019-11-13T03:21:48.639430+01:00
WARNING: too many parse errors, count=3978 SQL hash=0x78cd8680
PARSE ERROR: ospid=21771, error=942 for statement:
2019-11-13T03:21:48.639908+01:00
select dg.inst_id, dg.name, sum(reads), sum(writes), avg(read_time), avg(write_time), sum(bytes_read), sum(bytes_written) from gv$asm_disk_stat ds, gv$asm_diskgroup dg where ds.group_number=dg.group_number and ds.inst_id=dg.inst_id group by dg.inst_id, dg.name
Any help or advice is welcome.
Regards,
Harry