Jul 06

OCM 11g Preparation – Create and manage contexts

Oracle Contexts is very useful, specially for application developers. You can define namespaces, variables and keep their values in memory instead of needing to commit to a table. You can also use it as a global variable where similars sessions can share, so it’s a good way to also exchange information! The documentation related below is very very …

Continue reading

Jun 30

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

Jun 30

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

Jun 29

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

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 …

Continue reading