E000 process consuming CPU constantly

I noticed on one of the 11g databases (recently patched to 11.2.0.4) 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 moreE000 process consuming CPU constantly

Enforce a constraint but do it fast and don’t look at my data

Here is a silly little thing you can do to your columns for … some reason. Create a constraint on a table full of data that would not pass the check for the constraint. This is not something that should be done if it can be avoided. You want your constraints to define a rule … Read moreEnforce a constraint but do it fast and don’t look at my data

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 moreAudit oracle connections only for specific users