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 moreE000 process consuming CPU constantly

Query user defined types over database link

Querying tables over database link is very common today. But what happens when we have a table that depends on one or more user defined types? Oracle needs to know the structure of our table and it’s columns when it receives it over the DB link. However, it cannot retrieve that information from remote server … Read moreQuery user defined types over database link