Books for you

Server-generated alerts occur ???just-in-time??? and appear in Enterprise
Manager. Resolving system utilization problems can be as simple as reviewing the
alerts and accepting the recommendations. This is in sharp contrast to steps typically
taken prior to Oracle Database 10g that included actively watching for events,
exploring V$ tables, identifying related SQL, and then figuring out the needed steps
to resolve the problem.
Database Advisors
ADDM is one of several advisors present in Oracle and accessible using Enterprise
Manager today. Other performance related advisors include:
SQL Advisor
Oracle Database 11g includes the SQL Tuning Advisor, SQL Access Advisor,
and Partition Advisor. The SQL Tuning Advisor analyzes SQL statements and
makes SQL improvement recommendations. The SQL Access Advisor and Partitioning
Advisor recommend when to create indexes, materialized views, or
partitioned tables.
SQL Performance Impact Advisor
Introduced in Oracle Database 11g, this advisor enables youto forecast how a
system change will impact SQL performance.


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