-
Book Overview & Buying
-
Table Of Contents
Managing Multimedia and Unstructured Data in the Oracle Database
By :
The review of the database is the most critical step, and approximately two working weeks should be devoted to it. The review involves:
Analyzing information collected about the database from the previous 6 months and forecasting growth and database usage
Liaising with groups (see the next table), and determining potential changes to the environment in the next 6 months, for example, there might be a plan to double the number of users who access the database
Liaising with management to acquire extra storage and capacity based on forecasts; if due to cost constraints, this capacity cannot be acquired and then alternatives must be explored
The following table shows the areas the DBA should liaise with when performing a review:
|
Developers |
Determine upgrades planned in the next 6 months, and review indexes and SQL statements. |
|
Application Users |
Review application usage and review data entry usage. |
|
Application Management |
Determine application changes in the next 6 months, and... |
Change the font size
Change margin width
Change background colour