E000 process consuming CPU constantly

I noticed on one of the 11g databases (recently patched to that it had constant CPU usage that was not there before. One session was constantly in CPU wait. It happened to be the E000 process which is a slave process of event monitor (EMON). As this is the one of the system processes … Read more

Audit oracle connections only for specific users

I have seen on few places in the net questions about how to disable logon and logoff audit for only one specific user (usually DBSNMP). This would really come in handy since some applications can have really excessive number of connections to the database. This should of course be addressed in other manner like creating … Read more