Books for you

How much hardware do I have now, and how much will I add as the database grows?
Disk drives tend to get cheaper and cheaper. Suppose you??™re planning a database
of 100 GB that youexpect to grow to 300 GB over the next two years. You
may have all the disk space available to plan for the 300 GB target, but it??™s more
likely that you??™ll buy a smaller amount to get started and add disks as the database
grows. It??™s important that youplan the initial layout with the expected
growth in mind.
Prior to Oracle9i, running out of tablespace in the middle of a batch operation
meant that the entire operation had to be rolled back. Oracle9i introduced the
Table 3-1. Access patterns for database objects
Object Create Read Update Delete
EMP


DEPT

SALARY


Creating a Database | 61
concept of resumable space allocation. When an operation encounters an outof-
space condition, if the resumable statement option has been enabled for the
session, the operation is suspended for a specific length of time, which allows
the operator to correct the out-of-space condition.


Pages:
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155