5 Database Administration

Increasing Database Storage Size

In this case, if all 48 channels are performing five read table operations, some database operations may fail because of the multiple read table operations on the same channels.

An application developer wants to develop an application that executes six read table operations on six different tables per channel:

500 / (6 1) = 83.33

Therefore, the application can run on as many as 80 channels before it encounters database access problems.

An application developer wants to develop an application to run on 72 channels simultaneously:

500 / (72 1) = 6.94

Therefore, the application can perform up to six read table operations on up to six different tables per channel before it encounters database access problems.

Increasing Database Storage Size

The amount of storage space needed for the database should be decided at the initial installation because the size of the database can affect the disk partition sizes (the database is stored in the /oracle file system).

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 217