Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the commonly used Oracle 11g memory view scripts, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Today we mainly share a few scripts about the in-memory view of the Oracle database.

1. V$MEMORY_DYNAMIC_COMPONENTS

V$MEMORY_DYNAMIC_COMPONENTS displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.

Script: Provides information about dynamic memory components.

COLUMN component FORMAT A30 SELECT component, ROUND (current_size/1024/1024) AS current_size_mb, ROUND (min_size/1024/1024) AS min_size_mb, ROUND (max_size/1024/1024) AS max_size_mb FROM v$memory_dynamic_components WHERE current_size! = 0 ORDER BY component

II. V$MEMORY_RESIZE_OPS

V$MEMORY_RESIZE_OPS displays information about the last 800completed memory resize operations (both automatic and manual). This does not include in-progress operations. All sizes are expressed in bytes.

Script: Provides information about memory resize operations.

SET LINESIZE 200 COLUMN parameter FORMAT A25 SELECT start_time, end_time, component, oper_type, oper_mode, parameter, ROUND (initial_size/1024/1024) AS initial_size_mb, ROUND (target_size/1024/1024) AS target_size_mb, ROUND (final_size/1024/1024) AS final_size_mb, status FROM v$memory_resize_ops ORDER BY start_time

III. V$MEMORY_TARGET_ADVICE

V$MEMORY_TARGET_ADVICE provides information about how the MEMORY_TARGET parameter should be sized based on current sizing and satisfaction metrics.

Script 3: Provides information to help tune the MEMORY_TARGET parameter.

SELECT * FROM v$memory_target_advice ORDER BY memory_size

After reading the above, do you have any further understanding of the commonly used Oracle 11g memory view scripts? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.