Because ASM is managed through Enterprise Manager, the database administrator
now can perform this critical management task. The need to coordinate this activity
with a system administrator is thus greatly reduced.
Real Application Testing Option
Oracle Database 11g introduced the capability to rerun production workloads and test
system changes through the Real Application Testing Option. This database option
includes a Database Replay facility and the SQL Performance Analyzer. Database
Replay captures production workload information, including concurrency, dependencies,
and timing. It transforms the workload capture files into replay files, provides a
Replay Client for processing the replay files, and provides the means to report on performance
statistics and any errors that might occur. The SQL Performance Analyzer captures
a SQL workload to be analyzed, measures the performance before database
changes and afterward, and identifies performance changes among SQL statements.
Database Security Features
Oracle includes basic security for managing user access through roles and privileges.
Pages:
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92