Category: OCM 11g Preparation

Before studying this topic, I would recommend you to study the Create and manage contexts as VPD can be used together with Contexts and they both mix very well. This is yet another topic that is impossible to do fast in the exam, if requested, without using the official documentation. So, be prepared to access it. …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading