June 2015 archive

Oracle 12c - ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Those days, while adding a new PDB to my Oracle 12c database (PSU 12.1.0.2.3), I got the following error in my dbca: [Thread-50] [ 2015-06-30 16:50:36.315 BRT ] [BasicStep.handleNonIgnorableError:480] ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege There is an Oracle Support Document 17182200.8 (Bug 17182200 - SET CONTAINER reports ORA-1035 even with restricted …

Continue reading

OCM 11g Preparation - Implement fine-grained access control

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

OCM 11g Preparation - Administer, manage and tune parallel execution

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

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 …

Continue reading

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 …

Continue reading