5
Database Administration
Increasing Database Storage Size
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 217
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).
