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 morenologging 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 moreE000 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.
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
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