Reverse engineering consists of analyzing the table structures and generating a physical database
diagram that is consistent with those structures, usually by analyzing column names, constraints,
and indexes to identify key columns. However, normally there is no one-to-one correlation
between the physical database diagram and the entity relationship diagram. Entity relationship
diagrams for packages can usually be obtained from the package vendor; they are helpful in
planning interfaces to the package database.
Space Requirements
Most Oracle-based packages provide fairly accurate estimates of their database resource usage
during production usage. However, they usually fail to take into account their usage requirements
during data loads and software upgrades. You should carefully monitor the package??™s undo
requirements during large data loads. A spare DATA tablespace may be needed as well if the
package creates copies of all its tables during upgrade operations.
?–
?–
?–
?–
Chapter 5: Developing and Implementing Applications 161
Tuning Goals
Just as custom applications have tuning goals, packages must be held to tuning goals as well.
Establishing and tracking these control values will help to identify areas of the package in need
of tuning (see Chapter 8).
Security Requirements
Unfortunately, many packages that use Oracle databases fall into one of two categories: either
they were migrated to Oracle from another database system, or they assume they will have full
DBA privileges for their object owner accounts.
Pages:
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296