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. …
Oct 28
OCM 11g Preparation – Determine and set sizing parameters for database structures
In this topic, you must be able to: Alter all the DB parameters that define any kind of memory or disk sizing. I would recommend you to run “show parameters size” and play with all of them. Create datafiles with different block sizes and check the usage of the db_NK_cache_size areas. Path to Documentation: Administrator’s …
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
