Long time ago when i was still an apprentice doing my fist ETL for one i learned about the good and common practice that specific tables in data warehouse should be loaded in NOLOGGING mode. Reasoning for doing this were sound, we did it for the tables that can always be repopulated with ETL. It won’t … Read more nologging in Oracle
I noticed on one of the 11g databases (recently patched to 22.214.171.124) 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 E000 process consuming CPU constantly
It’s simple. Just use the command prompt and VBoxManage.exe command (it’s located in your VBox installation folder): VBoxManage.exe startvm “VM name” –type headless Check out VBoxManage manual page for other neat things you can do with it.
I just had a task to validate rman backup of a production database without actually having to restore it somewhere. Although i prefer to do something like clone the database from backup and see for myself if the instance will actually open and work, there is a way to do simple validation from rman. RMAN allows … Read more Validate RMAN Backups
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 more Query user defined types over database link