About

Martin Klier

usn-it.de

Oracle srvctl does not remove EONS despite it’s documented (PRKO-2013)

srvctl in Oracle Grid Infrastructure 11g Release 2 has at least one discrepancy between docs and functionality. I saw EONS consuming lots of memory in a non-database grid installation, and wanted to get rid of it. (The eONS is used by Oracle Enterprise Manager to receive notification of change in status of components managed by […]

read more

Oracle 11g Adaptive Cursor Sharing does not work with PL/SQL?

Recently, there was trouble in the air. I migrated a database into 11g to enjoy adaptive cursor sharing, but it did not adapt cursors. In the trouble shooting process, I discovered the following: Bug 8357294: ADAPTIVE CURSOR SHARING DOESN’T WORK FOR SQL FROM PL/SQL Nice one. A short quotation from the bug text: PL/SQL has […]

read more