Oracle 10g SGA 相關的VIEW

zhulch發表於2007-02-13
Oracle 10gView
.........[@more@]
ViewDescription
V$SGADisplays summary information about the system global area (SGA).
V$SGAINFODisplays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.
V$SGASTATDisplays detailed information about the SGA.
V$SGA_DYNAMIC_COMPONENTSDisplays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup.
V$SGA_DYNAMIC_FREE_MEMORYDisplays information about the amount of SGA memory available for future dynamic SGA resize operations.
V$SGA_RESIZE_OPSDisplays information about the last 400 completed SGA resize operations.
V$SGA_CURRENT_RESIZE_OPSDisplays information about SGA resize operations that are currently in progress. A resize operation is an enlargement or reduction of a dynamic SGA component.
V$SGA_TARGET_ADVICEDisplays information that helps you tune SGA_TARGET. For more information, see Oracle Database Performance Tuning Guide.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7318139/viewspace-899440/，如需轉載，請註明出處，否則將追究法律責任。

相關文章