In the preliminary Oracle database, created during the Oracle server installation, the DB Setup Utility allocates tablespaces associated with the SmartPlant Instrumentation Admin schema. Oracle uses these tablespaces to store your SmartPlant Instrumentation database information. This means that Oracle allocates disk space on the selected server drive to be used only for your SmartPlant Instrumentation database. The DB Setup Utility creates three tablespaces (see the table below for additional information about these tablespaces):
-
Admin data — used for the Admin schema.
-
Index data — used for the Admin schema.
-
Temporary tablespace — used for internal Oracle operations (for example, sorting). For the temporary operation of Oracle in each domain, one tablespace is created automatically for all domains during the database setup.
Each tablespace can contain one or more datafiles. SmartPlant Instrumentation database keeps your data in the following schemas:
-
Admin schema — contains the administration data and indexes.
-
Domain schema (a separate schema for each domain) — contains the domain and index data of a SmartPlant Instrumentation domain.
-
View-Only Domain schema (an individual schema for each domain)
The DB Setup Utility creates tablespaces for the Admin schema using the following tablespace default values:
|
Parameter |
Admin Data Tablespace |
Index Data Tablespace |
|---|---|---|
|
Tablespace name |
main_ts |
index_main_ts |
|
Database filename: |
in_main.db |
ix_main.db |
|
Tablespace size |
10 MB |
ix_main.db |
However, you may need to create either larger tablespaces or indexes. During the lifetime of the instrumentation data, you may also need to increase the size of existing index tablespace. The following table lists important statistical data which you can use as a guide when selecting the domain tablespace and index sizes:
|
Item Types |
Quantity (Average) |
|---|---|
|
Instruments |
45058 |
|
Loops |
16616 |
|
CAD drawing blocks |
1381 |
|
Device panels |
11384 |
|
Junction boxes |
504 |
|
Marshaling racks |
45 |
|
Cabinets |
36 |
|
DCSs and PLCs |
108 |
|
Channels |
16880 |
|
Specifications |
111 |
|
P&ID drawings |
855 |
|
Lines |
3132 |
The above item type quantities populate a domain whose tablespace and index sizes are as follows:
|
Admin Data Tablespace |
Admin Index Tablespace |
Domain Data Tablespace |
Domain Index Data Tablespace |
Domain Temporary Data Tablespace |
|---|---|---|---|---|
|
30 MB |
10 MB |
350 MB |
180 MB |
100 MB (auto-extended) |
Later, you may receive an indication that the available free space in the tablespace is low, or you may encounter a message that there is insufficient space while working in SmartPlant Instrumentation. If this happens, SmartPlant Instrumentation System Administrator can increase the size of the tablespace for the specific domain.
-
For better performance, it is highly recommended that you locate the data tablespaces and index tablespaces on different physical disks. You can also locate the system file, database tables and the index data on different physical drives to speed up your work in the Oracle Database. See your Oracle User Guide for more information.
-
Each of the file names must be a legal name. Each tablespace name must be unique within your database.