Oracle 视图 V$PGA_TARGET_ADVICE 官方解释,作用,如何使用详细说明
Oracle视图V$PGA_TARGET_ADVICE是可以用来分析查看根据你给出的PGA_TARGET_FACTOR,接着系统给出推荐的PGA设置来改善系统效率的视图。其中PGA_TARGET_FACTOR由用户设定,表明当前连接要占用PGA内存的比例;推荐的PGA_TARGET设置应该使系统最大程度的提高,操作的系统效率。
用户可以使用V$PGA_TARGET_ADVICE视图来侦测和调整PGA内存的设置,来改善Oracle数据库的性能。例如,执行以下查询来检查当前的PGA_TARGET的值:
SELECT pga_target_for_estimate, pga_target_factor, estd_pga_target_cache_miss_percentage FROM v$pga_target_advice;
执行这段代码后,会得到当前PING_TARGET的值,当前的PGA_TARGET_FACTOR,以及推荐的PGA_TARGET_CACHE_MISS_PERCENTAGE。
官方英文解释V$PGA_TARGET_ADVICE predicts how the cache hit percentage and over allocation count statistics displayed by the V$PGASTAT performance view would be impacted if the value of the PGA_AGGREGATE_TARGET parameter is changed.
The prediction is performed for various values of the PGA_AGGREGATE_TARGET parameter, selected around its current value. The advice statistic is generated by simulating the past workload run by the instance.
The content of the view is empty if PGA_AGGREGATE_TARGET is not set. In addition, the content of this view is not updated if the STATISTICS_LEVEL parameter is set to BASIC. Base statistics for this view are reset at instance startup and when the value of the PGA_AGGREGATE_TARGET initialization parameter is dynamically modified.
PGA_TARGET_FOR_ESTIMATE / the current value of the PGA_AGGREGATE_TARGET parameter
Indicates whether the advice is enabled (ON) or disabled (OFF) depending on the value of the STATISTICS_LEVEL parameter
Total bytes processed by all the work areas considered by this advice (in bytes)
Estimated number of extra bytes which would be read or written if PGA_AGGREGATE_TARGET was set to the value of the PGA_TARGET_FOR_ESTIMATE column. This number is derived from the estimated number and size of work areas which would run in one-pass (or multi-pass) for that value of PGA_AGGREGATE_TARGET.
Estimated value of the cache hit percentage statistic when PGA_AGGREGATE_TARGET equals PGA_TARGET_FOR_ESTIMATE. This column is derived from the above two columns and is equal to BYTES_PROCESSED / (BYTES_PROCESSED + ESTD_EXTRA_BYTES_RW)
Estimated number of PGA memory over-allocations if the value of PGA_AGGREGATE_TARGET is set to PGA_TARGET_FOR_ESTIMATE. A nonzero value means that PGA_TARGET_FOR_ESTIMATE is not large enough to run the work area workload. Hence, the DBA should not set PGA_AGGREGATE_TARGET to PGA_TARGET_FOR_ESTIMATE since Oracle will not be able to honor that target.
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
Oracle Database
Performance Tuning Guide for information on tuning the PGA_AGGREGATE_TARGET initialization parameter using the PGA advice views
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$PGA_TARGET_ADVICE 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 ALL_ATTRIBUTE_DIMENSIONS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_EDITIONING_VIEWS 官方解释,作用,如何使用详细说明
- Oracle 视图 RECYCLEBIN 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_HIST_RSRC_CONSUMER_GROUP 官方解释,作用,如何使用详细说明
- 使用Oracle分区表高效删除数据(oracle分区表删除)
- 空间查看Oracle临时表空间使用情况(oracle查看临时表)
- Oracle 存储空间最佳化策略(oracle存储大小)
- 查看Oracle版本:最简单的方法(查看安装oracle版本)
- Oracle求字符长度的简易方法(oracle求字符长度)
- 初探Oracle触发器:学习不同类型的触发器(oracle触发器类型)
- 使用Oracle查询数据库字段类型的方法(oracle判断字段类型)
- 名修改Oracle表中用户名的方法(oracle修改表用户)
- Oracle查询表锁定情况,解决越权访问问题(oracle查看表被锁住)
- 使用Oracle自带函数实现数据处理(oracle 自带函数)
- Oracle数据库查询操作入门(oracle q 操作)
- ISS和Oracle 整合保障软件安全(iss oracle)
- 使用HTSQL查询Oracle数据库(htsql-oracle)
- Oracle侦听器设置简明指引(oracle 侦听器设置)
- 限Oracle 授予使用权限的智慧方式(oracle 使用权)
- 视图在Oracle中如何利用视图来发挥作用(oracle中 怎么使用)
- Oracle中Limit的使用方法(oracle中limit)
- 对比Oracle两表不等式对比分析(oracle 两表不相等)
- Oracle LMS将启动新学习旅程(oracle lms0)
- Oracle JVM组件值得信赖的可靠性(oracle jvm组件)