Jul 08

OCM 11g Preparation - Use Result Cache

Result Cache is not enabled by default but is a such amazing feature that can make your 3 hours query run in less than 1 second after the first call. However, your result set need to be short and the tables involved might not be modified so often. The Oracle official documentation for Result Caches is short. So read …

Continue reading

Jul 06

OCM 11g Preparation - Administer flashback data archive and schema evolution

I've already talked about that in the topic Perform various recovery operations using Flashback technology but this is here again. For Oracle to have created a separate topic for that, this probably means you should not even think in skipping to study that. Be well prepared. Practice: Creating a Flashback Data Archive Enabling and Disabling Flashback Data …

Continue reading

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