Viewing Information About the SGA (115)
V$SGA : Displays summary information about the system global area (SGA).
V$SGAINFO : Displays size information about the SGA, including the sizes of different SGA
components, the granule size, and free memory.
V$SGASTAT : Displays detailed information about the SGA.
V$SGA_DYNAMIC_COMPONENTS : Displays information about the dynamic SGA
components. This view summarizes information
based on all completed SGA resize operations since
instance startup.
V$SGA_DYNAMIC_FREE_MEMORY : Displays information about the amount of SGA
memory available for future dynamic SGA resize operations.
V$SGA_RESIZE_OPS : Displays information about the last 400 completed SGA resize
operations.
V$SGA_CURRENT_RESIZE_OPS : Displays 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_ADVICE : Displays information that helps you tune SGA_TARGET.[@more@]
V$SGAINFO : Displays size information about the SGA, including the sizes of different SGA
components, the granule size, and free memory.
V$SGASTAT : Displays detailed information about the SGA.
V$SGA_DYNAMIC_COMPONENTS : Displays information about the dynamic SGA
components. This view summarizes information
based on all completed SGA resize operations since
instance startup.
V$SGA_DYNAMIC_FREE_MEMORY : Displays information about the amount of SGA
memory available for future dynamic SGA resize operations.
V$SGA_RESIZE_OPS : Displays information about the last 400 completed SGA resize
operations.
V$SGA_CURRENT_RESIZE_OPS : Displays 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_ADVICE : Displays information that helps you tune SGA_TARGET.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-996394/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- virtualbox啟動報“Driver is probably stuck stopping/starting. Try ‘sc.exe query vboxdrv’ to get more information about its state”ORM
- About HTMLHTML
- about me
- LOCK_SGA(zt)
- CF115E
- Trivia about pythonPython
- About My Blog
- [LeetCode] 115. Distinct SubsequencesLeetCode
- Narrative writing about a person
- 3.4.1 About Quiescing a DatabaseUIDatabase
- 2.3.3.1 About Application MaintenanceAPPAINaN
- 2.3.1 About Application ContainersAPPAI
- An example about git hookGitHook
- About the Oracle GoldenGate TrailOracleGoAI
- Tree – Information TheoryORM
- [20210723]Minimum sga_target.txt
- SGA: allocation forcing component growth分析
- Notes about Vue Style GuideVueGUIIDE
- Something about seniority in the family or clan
- Some notes about patch workflows
- Some ideas About ‘invisible bug‘Idea
- [Information Security] What is WEPORM
- ordebug 手動修改Oracle sga scnOracle
- [20191211]Free SGA Memory Available.txtAI
- Leetcode-115. 不同的子序列LeetCode
- Tell Me About Yourself Example 1
- What you should know about JavaJava
- Something about 計算幾何
- Something about 樹鏈剖分
- some notes about distributed workflows in GitGit
- What is the N prefix in MSSQL all about?SQL
- Talk about the naming of spring bean namesSpringBean
- System Volume Information是什麼檔案 System Volume Information可以刪除嗎ORM
- 將About加入系統選單
- about oracle10g rac(轉)Oracle
- coca搭配 on vs about 基於ngrams
- information_schema的結構ORM
- Python | 資訊熵 Information EntropyPython熵ORM
- information_schema.innodb_metrics表ORM