Page History
...
Install the Precise environment before configuring the SQL Server-based PMDB. Before applying the information in this section, refer to the Precise Installation Guide.
Info |
---|
SQL Server 2000 is not supported in v9.0, so an upgrade is not available for such installations. |
For an SQL Server-based PMDB, use an MS-SQL dedicated instance.
...
Setting | Description | Value |
---|---|---|
Size of the datafile | The default size when the PMDB is created. | 2 GB |
Size of the log file | The default size when the PMDB is created. | 500 MB |
Auto Extent size for datafiles and logs | The size of the new segment to be allocated. | 30% of initial datafile (for example, if the datafile is initially 1 GB, the auto extent size should be 300 MB). |
Tempdb location | Put the |
Anchor | ||||
---|---|---|---|---|
|
...
Parameter | Value | Improvement / Remarks |
---|---|---|
log_buffer | If the version <9.2.0.7, then the log_buffer = 3 MB, else the log_buffer= 16 MB. | |
shared_pool_size | 1/4 of the physical memory. | The shared pool should not be too small (< 250 MB) or too large (>2 GB). |
log_checkpoint_timeout | 900 | |
open_cursors | 300 | Verify that you have enough open cursors for the application to execute. |
Processes | 300 | Verify that you have enough processes for the application to execute. |
db_writer_processes | Should be set according to the number of I/O devices you have for the database. | Improves I/O performance in cases of large I/O. Each writer is writing to different disks (improves loads, for example). |
...
Parameter | Value | Improvements / Remarks | |
---|---|---|---|
db_cache_size | Replaces parameter | ||
pga_aggregate_target | 1/3rd of the physical memory. | ||
workarea_size_policy | Auto | This parameter should be set to auto when we use the pga_aggregate_target parameter. | |
session_cached_cursors | 300 | ||
DB-cache_advice | Verify that this parameter is set to | This parameter checks the work on the database and helps determine the recommended size of the Buffer pool. But this damages performance, so verify that it is on only for a short period. |
...
Setting | Description | Value | ||
---|---|---|---|---|
Rollback segments (For Oracle 8i) | Minimum tablespace size | 2 GB (4 GB in large installations) | ||
Rollback segments (For Oracle 8i) | Minimum number of segments | 20 | ||
Rollback segments (For Oracle 8i) | Minimum initial segment size | 5 MB
| ||
Enable AUM (For Oracle 9i and later) | Automatic Undo Management | |||
Temporary tablespace | Minimum temporary tablespace size | 2 GB
| ||
Redo log file | Minimum redo log file size | 1 GB (4 GB in large installations)
|
...