2012-12-27 11gR2 "Performance Tuning Guide" page 83 - 113

最新推荐文章于 2013-01-31 15:39:21 发布
最新推荐文章于 2013-01-31 15:39:21 发布
阅读量314 收藏
点赞数
分类专栏： oracle official docs oracle everyday
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/empoli/article/details/8445347
版权

 


Transporting Automatic Workload Repository Data -- 转移AWR数据
Extracting AWR Data
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrextr.sql
A list of the databases in the AWR schema is displayed.

Loading AWR Data
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrload.sql


Generating an Oracle RAC AWR Report -- 生成RAC的AWR报告
The awrgrpt.sql SQL script generates an HTML or text report that displays
statistics for a range of snapshot IDs using the current database identifier and all
available database instances in an Oracle Real Application Clusters (Oracle RAC)
environment.
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgrpt.sql


Generating an AWR Report on a Specific Database Instance -- 在某个单独的实例上生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrrpti.sql


Generating an AWR Report for a SQL Statement -- 为SQL语句生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql


Generating an AWR Report for a SQL Statement on a Specific Database Instance -- 某实例的SQL语句生成AWR
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

Generating an AWR Compare Periods Report -- 生成AWR性能比较报告
The awrddrpt.sql SQL script generates an HTML or text report that compares
detailed performance attributes and configuration settings between two selected time
periods.
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

Generating an Oracle RAC AWR Compare Periods Report -- 生成RAC的AWR性能比较报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

Generating an AWR Compare Periods Report on a Specific Database Instance -- 生成某个实例上的AWR性能比较报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

Generating an Oracle RAC AWR Compare Periods Report on Specific Database
Instances -- 生成RAC的某个实例上的AWR性能比较
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql


Generating an ASH Report -- 生成ASH性能报告
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql

Generating an ASH Report on a Specific Database Instance
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql

Generating an Oracle RAC ASH Report
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

empoli
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle 11gr2 Performance Tuning Guide (e41573)-计算机科学
04-22
Performance Tuning Guide11g Release 2 (11.2)E41573-03September 2013Oracle Database Performance Tuning Guide, 11g Release 2 (11.2)E41573-03Copyright :copyright: 2000, 2013, Oracle and/or its affiliates...
Oracle Database Performance Tuning Guide 11g Release 2 (11.2)-56
06-18
《Oracle Database Performance Tuning Guide 11g Release 2 (11.2)-56》是Oracle公司为数据库管理员提供的一本详细指南，专注于优化Oracle 11g Release 2数据库的性能。这本书由众多专家共同撰写，包含了从2000年到...
2012-12-25 11gR2 "Performance Tuning Guide" page 70 - 82
Poli Liu's Oracle World
12-25 348
Operating System Statistics -- 操作系统的统计信息 CPU Statistics -- CPU信息 The V$OSSTAT view captures machine-level information in the database, making it easier for you to determine if hardware-level resour
2012-12-17 11gR2 "Performance Tuning Guide" page 1 - 49
Poli Liu's Oracle World
12-17 362
Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle Database Performance -- 11202新特性 Oracle Orion I/O Calibration Tool Documentation -- Oracle Orion I/O测试工具 Oracle Orion is a tool for p
2012-12-11 11gR2 "2 Day + Performance Tuning Guide" page 1 - 51
Poli Liu's Oracle World
12-11 377
Gathering Database Statistics Using the Automatic Workload Repository -- 使用AWR收集系统信息 The following initialization parameters are relevant for AWR:  -- STATISTICS_LEVEL Set this parameter to TYPICAL
2012-12-19 - 12-20 11gR2 "Performance Tuning Guide" page 50 - 69
Poli Liu's Oracle World
12-20 250
Steps in The Oracle Performance Improvement Method -- 性能调优的步骤 1. Perform the following initial standard checks: -- 初始标准的检查 a. Get candid feedback from users. Determine the performance project's scop
2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168
Poli Liu's Oracle World
12-14 262
Creating a SQL Tuning Set: Load Method -- SQL TUNING SET的加载方法 Loading Active SQL Statements Incrementally from the Cursor Cache You can load active SQL statements from the cursor cache into the SQL
2013-1-23 - 1-24 11gR2 "Performance Tuning Guide" page 142 - 151
Poli Liu's Oracle World
01-24 314
Shared Pool Concepts A cache miss on the data dictionary cache or library cache is more expensive than a miss on the buffer cache. For this reason, the shared pool should be sized to ensure that fr
2013-1-30 - 1-31 11gR2 "Performance Tuning Guide" page 152 - 162
Poli Liu's Oracle World
01-31 300
Interpreting Shared Pool Statistics Allocating Additional Memory to the Data Dictionary Cache Examine cache activity by monitoring the GETS and GETMISSES columns. For frequently accessed dictionary
2013-1-6 - 1-7 11gR2 "Performance Tuning Guide" page 114 - 141
Poli Liu's Oracle World
01-07 408
Buffer Pool Data in V$DB_CACHE_ADVICE -- 在v$视图中查询BUFFER POOL的相关数据 You can use V$DB_CACHE_ADVICE to size all pools configured on a database instance. Make the initial cache size estimate, run the rep
2012-10-8 11gR2 concepts page 1-32
Poli Liu's Oracle World
10-08 470
今天开始翻阅11GR2 CONCEPTS文档。 摘要如下：   Brief History of Oracle Database  -- Oracle版本的历史演变  -- Founding of Oracle -- Oracle公司的成立 In 1977, Larry Ellison, Bob Miner, and Ed Oates started the consultancy Sof
oracl database performance tuning guide 11gr2.pdf
02-02
### Oracle Database性能调优指南11g Release 2 (11.2)关键知识点解析 #### 一、文档概述 本文档《Oracle Database性能调优指南11g Release 2 (11.2)》（以下简称“指南”）是Oracle官方发布的关于其11g Release 2...
Oracle Database 12c Performance Tuning - Vol 2
最新发布
05-13
本卷《Oracle Database 12c: Performance Management and Tuning Student Guide - Volume II》主要围绕性能管理和调优展开，旨在帮助读者深入理解如何有效地管理和优化 Oracle 12c 数据库的性能。 #### 二、性能...
2012-10-27 - 2012-10-28 11gR2 "ADMINISTRATOR'S GUIDE" page 305 - 352
Poli Liu's Oracle World
10-28 1441
接下去的这一章讲了很多的如何向Oracle Support提供incident package的方法。 可以细看 page 308 - 325   这一章节基本都是讲EM的操作，其实我们更多时候最好是不用EM，但是我一直十分喜欢用EM进行数据库的性能监控。   Directory Structure in the Management Service Home for Release 1
2012-10-26 11gR2 "ADMINISTRATOR'S GUIDE" page 252 - 304
Poli Liu's Oracle World
10-26 1203
Run the following query to obtain a value for SGA_TARGET: -- 获取SGA_TARGET应该设置的值 SELECT ( (SELECT SUM(value) FROM V$SGA) - (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY) ) "SGA_TARGET" FROM
2012-10-25 11gR2 "ADMINISTRATOR'S GUIDE" page 219 - 251
Poli Liu's Oracle World
10-25 914
Comparing DRCP to Dedicated Server and Shared Server -- DRCP与专有模式和共享模式的比较   Shared Server Data Dictionary Views -- 与共享模式有关的数据字典视图   Configuring Database Resident Connection Pooling -- 配置DRCP
2012-10-22 11gR2"2DAY DBA"page126-280 & "ADMINISTRATOR'S GUIDE" page1-61
Poli Liu's Oracle World
10-22 788
Large object (LOB) columns are used to contain unstructured data (such as text or streaming video), and can hold terabytes of information. In Oracle Database 11g, you can use SecureFiles, the next g
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值