V$SGADYNAMICFREEMEMORY - Definition - Oracle DBA

Q.  In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations?
- Published on 29 Jul 15

a. V$SGA_DYNAMIC_COMPONENTS
b. V$SGA_DYNAMIC_FREE_MEMORY
c. V$SGASTAT
d. V$SGAINFO

ANSWER: V$SGA_DYNAMIC_FREE_MEMORY
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -The Oracle Database views provides information about some components

    -V$SGA_DYNAMIC_COMPONENTS - It displays information about the dynamic SGA components and also summarizes information based on all completed SGA resize operations since instance startup.

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

    -V$SGASTAT - It displays detailed information about the SGA.

    -V$SGAINFO - It displays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)