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 / …
Jun 22
OCM 11g Preparation – Administer external tables
Creating an external is not a easy task. Why? Because, at least for me, this is one of the most complexes Oracle syntaxes. So, the best approach for me in this topic is to go quickly in the documentation place of external tables and use a template. Practice a bit to be prepared for the …
Jun 21
OCM 11g Preparation – Configure a schema to support a star transformation query
Star transformation can be really useful in DW environments, where you have your tables divide into dimensions and facts. And the most important, you need to have bitmap indexes! To implement it, you need to change the star_transformation_enabled for your user session and create the tables and indexes to play. Try to practice creating one fact …
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
