So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and how to use the 260 parameters (not including the hidden ones)? Off course not. You are studying for OCM, not for any memorization championship. But what you must know is …
Nov 14
OCM 11g Preparation - Configure the database environment to support optimal data access performance
This topic is not so specific as the others. It says "Support optimal data performance". This lead us to think in about 1000 items that are relates to performance in a DB. Basically, this means: study a lot of performance. Read the whole Oracle doc for Performance Tuning and get the OCE Performance Tuning. This is …
Nov 14
OCM 11g Preparation - Stripe data files across multiple physical devices and locations
Here you need to know how to strip the oracle data files. It is "data files", not "datafiles". So, don't forget to strip any kind of oracle file in different mount points, like: Controlfiles Redologs Tablespaces (create more than one datafile for each) You can also do a indirect striping using +ASM diskgroups across multiple …
Nov 13
Howto apply OJVM PSU, DB PSU and Generic JDBC Patch in 11.2.0.4
Starting at October 2014, all the DB PSU come along with the OJVM PSU option on the main download page (Doc ID 756671.1). Oracle recommends to install both, as well as the Generic JDBC Patch that is also available there. In this tutorial, I will show how to install the OJVM PSU, DB PSU and JDBC …
Nov 07
Rename schema in Oracle 11g with Loopback DBLink
In this article, we will deal a very common situation where the DBA is tasked to rename or clone a user into the same database. In the following lines, I will explain how to make this copy without higher complexities and with no need to generate intermediate dump files, using DataPump import utility with a …
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
