How to choose “non recommended” character sets(US7ASCII、WE8ISO8859P1) in DBCA 11G, 12C or later

  • 2017/11/27
  • ORACLE 9i-23ai
  • 1,295 views
  • How to choose “non recommended” character sets(US7ASCII、WE8ISO8859P1) in DBCA 11G, 12C or later已关闭评论

We limit the default display of database character sets that can be used for a new database in Oracle Database 11 via DBCA (Database Creation Assistant) based on the recommended list.

,

阅读全文

Oracle 12.2 DB alert show “WARNING: too many parse errors” or “__Oracle_JDBC_internal_ROWID__” in sql

  • 2017/11/24
  • Cloud, ORACLE 9i-23ai
  • 8,823 views
  • Oracle 12.2 DB alert show “WARNING: too many parse errors” or “__Oracle_JDBC_internal_ROWID__” in sql已关闭评论

alert log中出现了大量的”WARNING: too many parse errors”，是以前的版本中从未见过，这也是12.2的新特性，自动生成解析失败的信息写入db alert log, 即使没有在数据库启用event 10035，当JDBC 中scroll sensitive resultset 启用时，JDBC驱动就会在用户SQL中自动增加ROWID

, ,

阅读全文