User`s guide

Section 2, Task 2: Create Your Production PDB
You now have the test PDB customized the way that you want it. This task will walk you through creating your production PDB
and copying the structure and settings and data of your test PDB to your production PDB.
Prerequisites
1. Your test PDB is the active PDB.
2. You have write access to your test PDB.
3. You have chosen a name for the PDB that this task will produce.
In this task you will create a permanent PDB for your collector’s data. In this document, we will refer to that PDB as your
production PDB.
A typical name is something like:
Collector PDB Location
ACC
(directories) /prodacc-pdb
MWA
(directories) \prodmwa-pdb
where
directories is the directory path that you want to use for your production PDB.
Actions
1. Estimate the size of your production PDB.
Use an operating system utility such as
du -s
(for UNIX) or
Windows Explorer
(for Windows NT) to check for
the amount of space used by each library (DETAIL, DAY, WEEK, MONTH, YEAR) of your PDB. This amount
indicates the amount needed for one unit of data (where a unit is a day for the DETAIL library and the DAY library, a
week for the WEEK library, a month for the MONTH library, and a year for the YEAR library). Extrapolate for the
length of time (age limit) that you selected for each level.
The amount of data at the day, week, month, and year reduction levels is a function of the number of unique
combinations of class variables values that are present in your data.
Note: The amount of space used at week, month, and year levels does not show any appreciable increase until data for
another week, month, or year are processed. The data currently stored in the week level, for example, represent a
summarization of the whole week and, as such, will be modified by updates to the data during the week, not by additions.
2. Decide where to create your production PDB.
Your estimate of the size of the fully populated PDB may affect where you want the production PDB to reside.
3. Create your production PDB.
a. Create an empty production PDB.