今天就跟大家聊聊有关常用的Oracle 11g内存视图脚本有哪些，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。

今天主要分享几个关于Oracle数据库的内存视图的脚本。

一、V$MEMORY_DYNAMIC_COMPONENTS

V$MEMORY_DYNAMIC_COMPONENTSdisplaysinformationaboutthedynamicSGAcomponents.ThisviewsummarizesinformationbasedonallcompletedSGAresizeoperationssinceinstancestartup.Allsizesareexpressedinbytes.

脚本： Provides information about dynamic memory components.

COLUMNcomponentFORMATA30SELECTcomponent,ROUND(current_size/1024/1024)AScurrent_size_mb,ROUND(min_size/1024/1024)ASmin_size_mb,ROUND(max_size/1024/1024)ASmax_size_mbFROMv$memory_dynamic_componentsWHEREcurrent_size!=0ORDERBYcomponent;

二、V$MEMORY_RESIZE_OPS

V$MEMORY_RESIZE_OPSdisplaysinformationaboutthelast800completedmemoryresizeoperations(bothautomaticandmanual).Thisdoesnotincludein-progressoperations.Allsizesareexpressedinbytes.

脚本：Provides information about memory resize operations.

SETLINESIZE200COLUMNparameterFORMATA25SELECTstart_time,end_time,component,oper_type,oper_mode,parameter,ROUND(initial_size/1024/1024)ASinitial_size_mb,ROUND(target_size/1024/1024)AStarget_size_mb,ROUND(final_size/1024/1024)ASfinal_size_mb,statusFROMv$memory_resize_opsORDERBYstart_time;

三、V$MEMORY_TARGET_ADVICE

V$MEMORY_TARGET_ADVICEprovidesinformationabouthowtheMEMORY_TARGETparametershouldbesizedbasedoncurrentsizingandsatisfactionmetrics.

脚本3： Provides information to help tune the MEMORY_TARGET parameter.

SELECT*FROMv$memory_target_adviceORDERBYmemory_size;

看完上述内容，你们对常用的Oracle 11g内存视图脚本有哪些有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注亿速云行业资讯频道，感谢大家的支持。