Well, the thing that I must suffer in my databases is when the developers learn how to use hint and put "parallel (32)" in every query. They probably think that this hint is a "set magic=on" that will make everything faster at no cost. So, when you find the "over-parallelism" disease in one of your databases, is …
Jun 24
OCM 11g Preparation - Use SQL*Loader
SQL*Loader is indeed a great tool and by far the fastest way to load a csv/txt file inside your database. It has so many features that can be sometimes confusing. The syntax of the control file is complex and, as I said in the external table topic, be prepared to copy some sample from the official …
Jun 24
OCM 11g Preparation - Configure and use parallel execution for queries
Parallel executions are there since Oracle 8 Parallel Server. The documentation linked below is worth reading. It gives you an overall idea. For this topic, I recommend you to have a good knowledge about each parallel parameter. Type "show parameter parallel" and understand very well each of them. Check parallel performance and informations via v$px …
Jun 23
OCM 11g Preparation - Implement Data Pump to and from remote databases
This topic basically wants us to know how to run expdp and impdp using the "network_link" parameter. This parameter is indeed very useful as this is the only way to: export from a remote database directly locally (like the legacy exp) without generating the file in the remote server and then SCPing. import directly from …
Jun 23
OCM 11g Preparation - Implement Data Pump export and import jobs for data transfer
Data Pump is one of the most basic things, but it has so many parameters that can transform in a complex thing. Anyway, this utility is probably the most used tool for any DBA. So, try to focus during you training in the things that are not very common. Be good exporting at tablespace / schema / …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
