Oracle教程 2023-02-24

Oracle 视图 V$SGA_DYNAMIC_FREE_MEMORY 官方解释，作用，如何使用详细说明

V$SGA_DYNAMIC_FREE_MEMORY是Oracle数据库的一个系统视图。该视图可以用来查看SGA中动态可分配的内存空间大小。查看SGA中动态可分配的内存空间大小的命令如下：

select * from v$sga_dynamic_free_memory;

通过这个视图可以获取SGA内存空间的大小，可以帮助DBA诊断和决策，来检查动态可分配的内存大小，以便调整SGA配置参数，优化数据库内存管理性能。

V$SGA_DYNAMIC_FREE_MEMORY displays information about the amount of SGA memory available for future dynamic SGA resize operations.

Column Datatype Description

Column	Datatype	Description
`CURRENT_SIZE`	`NUMBER`	Amount of available memory (in bytes)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `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. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

CURRENT_SIZE

NUMBER

Amount of available memory (in bytes)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

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.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data

分享到：