| 失效链接处理 |
|
oracl database performance tuning guide 11gr2 PDF 下载
本站整理下载：
相关截图：
主要内容：
What's New in Oracle Database Performance
Tuning Guide?
This section describes new performance tuning features of Oracle Database 11g
Release 2 (11.2) and provides pointers to additional information. The features and
enhancements described in this section comprise the overall effort to optimize
database performance.
For a summary of all new features for Oracle Database 11g Release 2 (11.2), see Oracle
Database New Features Guide.
Oracle Database 11g Release 2 (11.2.0.4) New Features in Oracle
Database Performance
The new and updated performance tuning features include:
■ Dynamic statistics enhancements
In previous releases, Oracle Database only gathered dynamic statistics (previously
called dynamic sampling) when one or more of the tables in a query did not have
optimizer statistics. Starting in Oracle Database 11g Release 2 (11.2.0.4), the
optimizer can automatically decide whether dynamic statistics are useful and
which dynamic statistics level to use for all SQL statements. For example, the
optimizer automatically decides whether to gather dynamic statistics during table
scans, index access, joins, and GROUP BY operations. The enhanced behavior is
enabled only when the OPTIMIZER_DYNAMIC_SAMPLING initialization parameter is
set to the new value of 11.
See "Controlling Dynamic Statistics" on page 13-22.
Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle
Database Performance
The new and updated performance tuning features include:
■ Resource Manager enhancements for parallel statement queuing
You can use Resource Manager to control the order of statements in a parallel
statement queue. For example, you can ensure that high-priority statements spend
less time in the queue. Also, you can use a directive to prevent one consumer
group from monopolizing all of the parallel servers, and to specify the maximum
time in seconds that a parallel statement can wait to be launched.
For more information, see "Managing CPU Resources Using Oracle Database
Resource Manager" on page 9-10 and Oracle Database VLDB and Partitioning Guide.
xviii
■ Resource Manager enhancements for CPU utilization limit
You can use Resource Manager to limit the CPU consumption of a consumer
group. This feature restricts the CPU consumption of low-priority sessions and can
help provide more consistent performance for the workload in a consumer group.
For more information, see "Managing CPU Resources Using Oracle Database
Resource Manager" on page 9-10. ■ New package for Automatic SQL Tuning
The DBMS_AUTO_SQLTUNE package is the new interface for managing the Automatic
SQL Tuning task. Unlike the SQL Tuning Advisor package DBMS_SQLTUNE, which
requires ADVISOR privileges, DBMS_AUTO_SQLTUNE requires the DBA role.
For more information, see "Configuring Automatic SQL Tuning" on page 17-7. ■ Oracle Orion I/O Calibration Tool Documentation
Oracle Orion is a tool for predicting the performance of an Oracle database
without having to install Oracle or create a database. Unlike other I/O calibration
tools, Oracle Orion is expressly designed for simulating Oracle database I/O
workloads using the same I/O software stack as Oracle. Orion can also simulate
the effect of striping performed by Oracle Automatic Storage Management.
For more information, see "I/O Calibration with the Oracle Orion Calibration
Tool" on page 8-12.
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
