large pool
large pool是我們比較熟悉的一個sga元件了,主要用來rman,mts,parallel execution時用,有初始化引數_min_large_pool_alloc_size限定large pool最小分配記憶體,預設值是16000,大於此值的object才會進入large pool.large pool的最小有效值是8m,可以從v$sgastat看到.
做了2個large pool的實驗,一個是用rman來備份,只用到很少的large pool mem,另一個用mts來進行大排序操作,設定了large pool 為8m,排序大概需要100m記憶體,修改work_area_policy為manual,設定sar=100m,sars=100m,一執行馬上報large pool的04031錯誤,修改large pool為0,uga在shared pool中分配,由於shared pool只有80m,所以shared pool也報04031,最後修改sars=10m,這樣就進行了one pass sort,可以順利通過,shared pool分配了10m給uga.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/756652/viewspace-242076/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE LARGE MEMORY(zt)Oracle
- golang work poolGolang
- oracle stream pool sizeOracle
- Hystrix Thread Pool 解析thread
- DUBBO Thread pool is EXHAUSTED!thread
- 共享池 shared pool
- LAMBDA: A Large Model Based Data Agent
- 【Leetcode】827. Making A Large IslandLeetCode
- Oracle Shared Pool Memory ManagementOracle
- LISA: Reasoning Segmentation via Large Language ModelSegmentation
- ALTER SYSTEM FLUSH BUFFER_POOL
- Effective Clustering on Large Attributed Bipartite Graphs翻譯
- Solution - Codeforces 1166E The LCMs Must be Large
- Awesome-LLM: a curated list of Large Language Model
- sync.pool 原始碼閱讀原始碼
- Large language models as surrogate models in evolutionary algorithms: A preliminary studyGo
- 歡迎 Stable Diffusion 3.5 Large 加入 🧨 Diffusers
- [GO-LANG] Why is my trivial program such a large binary?Go
- Row size too large (> 8126)解決辦法
- "Visual Studio Code is unable to watch for file changes in this large workspace"
- centos 16安裝PHP7.0 異常 No pool defined. at least one pool section must be specified in config fileCentOSPHPAST
- Python中Pool常用函式有哪些?Python函式
- multiprocessing pool AttributeError: Can't get attribute 'func'Error
- jedis異常:Could not get a resource from the pool
- MySQL innodb_buffer_pool_size 變數MySql變數
- 深度解密 Go 語言之 sync.Pool解密Go
- MySQL入門--記憶體buffer poolMySql記憶體
- 【commons-pool2原始碼】_pre JMX原始碼
- InnoDB 中的緩衝池(Buffer Pool)
- Python程式專題4:程式池PoolPython
- docker筆記43-ceph pool管理Docker筆記
- JVM常量池Constant pool結構速查JVM
- 給從庫預熱innodb buffer pool
- 大型語言模型(Large Language Models)的介紹模型
- Error: --recode does not support multipass recoding of very large files.Error
- 《MapReduce: Simplified Data Processing on Large Clusters》論文研讀
- Mysql 報Row size too large 65535解決方法MySql
- MySQL中讀頁緩衝區buffer poolMySql