Books for you

You will need an understanding of all of
these areas as youplan and implement effective management strategies for your Oracle
database environment.
124 | Chapter 5: Managing Oracle
Manageability Features
Oracle Database 10g and its ???Intelligent Infrastructure??? was a huge step forward in
simplifying management of the Oracle database. Many manual steps needed to
manage database releases previous to Oracle Database 10g were eliminated. Oracle
Database 11g introduced still more self-tuning and self-management features. Key
maintenance tasks are automated, including optimizer statistics gathering, the
Segment Advisor, and the SQL Tuning Advisor. Management of the entire infrastructure
is accomplished through self-managing capabilities within the database and
through Oracle Enterprise Manager.
Statistics containing active session history are now gathered and populate the Automatic
Workload Repository (AWR). The Automatic Database Diagnostic Monitor
(ADDM) automatically tracks changes in database performance leveraging the data
in the AWR.


Pages:
262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286