Oracle management (K1) « Różności …

25 lutego 2011

Oracle management (K1)

Zaszufladkowany do: Bazy danych,Oracle — Tagi: oracle — Jacek @ 15:57

SQL AdvisorStatistics 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 datain the AWR.

Server-generated alerts occur “just-in-time” and appear in EnterpriseManager.

ADDM is one of several advisors present in Oracle and accessible using EnterpriseManager 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 andmakes SQL improvement recommendations. The SQL Access Advisor and PartitioningAdvisor recommend when to create indexes, materialized views, orpartitioned tables.

SQL Performance Impact Advisor - Introduced in Oracle Database 11g, this advisor enables youto forecast how asystem change will impact SQL performance.

Memory Advisors - The Memory Advisor is an expert system that provides automatic memory managementand eliminates manual adjustment of the SGA and PGA when enabled(and recommended in Oracle Database 11g). If just automatic shared memory isenabled instead, youwill have access to the Shared Pool (SGA) Advisor and PGAAdvisor. Finally, if youare manually managing shared memory, youwill haveaccess to the Shared Pool (SGA) Advisor, Buffer Cache Advisor, and PGA Advisor.

Segment Advisor – Use of the Segment Advisor eliminates the need to identify fragmented objectsand reorganize the objects using scripts. The Segment Advisor advises whichobjects to shrink and allows youto simply accept the recommendations. Youmight also use this information in capacity planning.

Undo Advisor - The Undo Advisor helps size the undo tablespace and can be used to set the lowthreshold of undo retention for Flashback. Oracle Database 11g features automaticundo management.

MTTR Advisor -The Mean Time to Recovery (MTTR) Advisor provides guidance regarding theimpact of MTTR settings and physical writes. The mean time for recovery from asystem failure is specified based on business needs by the database administratorusing Enterprise Manager, and then needed reconfiguration of Oraclecomponents automatically takes place.

Streams Tuning Advisor - The Streams Tuning Advisor reports on throughput and latency for a Streamstopology among Oracle databases and can identify bottlenecks.

Health Monitor - Health Monitor reports, and other diagnostic information stored in the Automatic Diagnostic Repository (ADR).

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.

Data Recovery Advisor
The Data Recovery Advisor is used in recovering from corrupted blocks, corrupted or missing files, and other data failures and is integrated with database health checks and RMAN.

Oracle Enterprise Manager

Database Management Packs – Diagnostics, Tuning, Change Management, Configuration Management,Provisioning

Database Diagnostics Pack - Provides automatic performance diagnostics by leveraging ADDM, the AWR, monitoring templates, and advanced event notification and alerting
Database Tuning Pack - Provides the statistics, SQL profiling, access path, and SQL structure analysis leveraged by the SQL Tuning Advisor and includes the SQL Access Advisor and Object Reorganization Wizard
Database Change Management Pack - Provides capture and version baselines, database object and data copying, and object definition updates
Database Configuration Management Pack - Provides system inventory collection and reporting, configuration comparisons and history, policy manager, and critical patch advisor
Database Provisioning Pack- Provides automated patching, cloning, provisioning, and single instance to RAC conversion

Standalone Management Packs- Provisioning, Service Level Management
Application Management Packs - E-Business Suite, PeopleSoft Enterprise, Siebel
Middleware (Oracle Application Server) Management Packs - Diagnostics, Configuration Management, Identity Management, Provisioning, SOA Management
Management Connectors - Microsoft Operations Manager, Remedy Helpdesk
Operating System Management Packs - Oracle Linux
System Monitoring Plug-ins - EMC Celerra, EMC Symmetrix DMX, NetApp Filer, BEA WebLogic, JBoss Application Server, IBM WebSphere, IBM WebSphere MQ, IBM DB2, Microsoft IIS Server, Microsoft Active Directory, Microsoft BizTalk Server, Microsoft Commerce Server, Microsoft ISA Server, Microsoft .NET framework, Microsoft SQL Server, Check Point Firewall, Juniper Netscreeen Firewall, F5 BigIP Local Traffic Manager, Linux Hosts, Unix Hosts, Windows Hosts

Oracle Management Agents - These agents monitor targets for health, status, and performance. Management Agents can also send Simple Network Management Protocol (SNMP) traps to database performance monitors in other system monitoring tools.

EM2Go is a mobile version of Enterprise Manager introduced with Oracle Database 10g.

In Oracle, a collection of contiguous blocks is referred to as an extent. A collection of extents is referred to as a segment.

As of Oracle Database 10g, resolving fragmentation issues became fairly trivial. You can perform an online segment shrink using the Segment Advisor interface accessible through EM. ADDM recommends segments to shrink, and you simply choose to accept the recommendations. (151)

Komentarze są wyłączone

Brak komentarzy

Brak komentarzy.

Kanał RSS z komentarzami do tego wpisu.

Przepraszamy, możliwość dodawania komentarzy jest obecnie wyłączona.