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 …
Oct 30
OCM 11g Preparation – Create and manage temporary, permanent, and undo tablespaces
Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace to use as a template. …
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
