The mean time for recovery from a
system failure is specified based on business needs by the database administrator
using Enterprise Manager, and then needed reconfiguration of Oracle
components automatically takes place.
Streams Tuning Advisor
The Streams Tuning Advisor reports on throughput and latency for a Streams
topology among Oracle databases and can identify bottlenecks.
Another class of advisors introduced in Oracle Database 11g can be used to resolve
database issues. When critical errors are detected, the fault diagnosability infrastructure
for Oracle Database 11g can perform a deeper analysis called a health check
using a Health Monitor. The advisors leverage diagnostic data including database
traces, the alert log, Health Monitor reports, and other diagnostic information stored
in the Automatic Diagnostic Repository (ADR). The infrastructure also includes a
SQL Test Case Builder used for reproducing the problem and transmitting the information
to Oracle Support. The advisors in this infrastructure include:
SQL Repair Advisor
If a SQL statement fails with a critical error, the SQL Repair Advisor will analyze
the statement and recommend a patch to repair it.
Pages:
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289