The goal of this chapter is to introduce some of the standard features that the Oracle database makes available to solve some common data processing, auditing, version management, and quality issues related to the maintenance of the spatial data. These database features allow developers to keep the data processing operations in the database instead of doing them in the application code. The topics covered in this chapter are:
Row-level and statement-level triggers
Avoiding the mutating table problem
Using materialized views
Logging changes independently of an application
Flashback queries
AWR reports and ADDM
Database replay
Workspace Manager
SecureFile compression