SQL*Developer Monitoring 工具引发了大量的解析错误 (Doc ID 2577533.1)

Last updated on AUGUST 29, 2019

适用于:

症状

• alert log中出现了大量错误:
  
  2019-05-07T14:50:02.744209+00:00
  WARNING: too many parse errors, count=100 SQL hash=0x39200d60
  PARSE ERROR: ospid=28586, error=942 for statement:
  2019-05-07T14:50:02.744405+00:00
  select test as SEQUENCE_NO, 100*... as PERCENT_FULL,...  as BLOCK_NO, l.bytes as LOG_SIZE_BYTES

  from sys.x$kcccp cp, sys.x$kccle le, (select bytes from v$log where status = 'CURRENT') l

    
  

   

更改

使用了非SYS用户来打开了 SQL Developer monitoring tool Performance Viewer

原因

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.