用好HugePage,告别Linux性能故障

2026-05-01Linux/AIX / Oracle / RAC

#

在一个运行着Oracle数据库的专用服务器上,内存基本上被以下内容所占用:

![1756815346131-80ecf10c-9fb7-4fc9-b019-951c2de1d866.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205259304-266326335.png)

![1756815346216-e94b6b3e-16f2-43ae-885a-23d909d51df3.jpg](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205301491-994141514.jpg)

一般情况下对于PGA的大量使用有如下几种操作:

![1756815346330-a5486752-4773-49db-8845-30e359ca27ac.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205302460-471956105.png)

如何为PGA_AGGREGATE_TARGET设置一个合理的值?

![1756815346396-3f498c08-604c-47e1-8354-d831488cd769.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205303460-220016023.png)

![1756815346465-8c926e37-b706-400d-a676-cc412ad5ac59.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205304304-1492567289.png)

![1756815346530-7682df04-4147-466d-a235-f9edd7a3f06a.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205305382-255870954.png)

![1756815346603-ccead5c4-66f4-41d8-95b5-c989379863d9.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205306663-1120759106.png)

![1756815346670-0e55b072-0070-484b-be6c-c4e21204ada0.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205307382-183691797.png)

![1756815346738-c069305b-d3ad-4b1e-b472-10c426f1e30d.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205308179-133417610.png)

![1756815346809-c6411dc9-0d13-4f60-ab6a-8ef3bd960919.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205309023-1946032089.png)

![1756815346885-772e7592-56f6-493a-8095-3677e6c87bd8.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205309913-1866755820.png)

![1756815346962-e346a419-f358-4273-bf17-831b4f8b5349.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205310913-1594132593.png)

![1756815347030-57ed2a7c-72cd-4e90-998e-7649d8f484fc.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205312398-1109554323.png)

12C PGA_AGGREGATE_LIMIT

Buffer Cache

![1756815347108-052795c2-8dc9-4cb8-9ad4-730890f0c1a1.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205313351-270730190.png)

Shared Pool

Granule

![1756815347204-10d2ef4c-14be-4a9b-82ab-624cf37fb1ce.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205314382-209727095.png)

![1756815347268-67f2fb32-cd76-4d92-bc36-8ab38bca5a2f.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205315648-1006120572.png)

![1756815347338-be6ed2a3-141b-48af-8839-974967e4efd5.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205316476-761273703.png)

![1756815347405-a7377b7e-3301-489a-8123-77da0e9772c7.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205317445-604416156.png)

大页的好处

大页的特点/缺点

大页的分配方法

大页的原理

![1756815347487-17855ae3-5008-4b08-b587-cda778a5368d.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205318585-1415678821.png)

页表内存计算

![1756815347556-7ca75887-8afa-409f-910c-8dce27de130c.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205320663-981665072.png)

USE_LARGE_PAGES

![1756815347624-6e5995d4-40d6-41de-a68c-cea60d87a181.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205322538-1776449353.png)

Transparent Hugepage

![1756815347695-c70b18a4-8fff-4260-8ed8-9259dabd7937.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205323945-835493754.png)

![1756815347773-260e30c0-9b2c-43ca-b5ed-4640d4c24daf.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205324945-2066923649.png)

针对于Oracle的内存分配方式,肉丝给大家推荐在核心系统上:

![1756815347858-d4bb6932-9d08-4e46-bc04-b9cce3742de1.png](http://images2015.cnblogs.com/blog/646850/201604/646850-20160420205326288-955645265.png)

****

****

:642808185 若加QQ

		............................................................................................ 
		● 小麦苗的微店:[https://weidian.com/s/793741433?wfr=c&ifr=shopdetail](https://weidian.com/s/793741433?wfr=c&ifr=shopdetail) 
		● 小麦苗出版的数据库类丛书:[http://blog.itpub.net/26736162/viewspace-2142121/](http://blog.itpub.net/26736162/viewspace-2142121/) 
		● 小麦苗OCP、OCM、高可用网络班:[http://blog.itpub.net/26736162/viewspace-2148098/](http://blog.itpub.net/26736162/viewspace-2148098/) 
		............................................................................................ 
		使用**微信客户端**扫描下面的二维码来关注小麦苗的微信公众号([xiaomaimiaolhr](http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=307287619&idx=1&sn=9149fab6ae1aecfd1288316c5edc3805&scene=19#wechat_redirect)),学习最实用的数据库技术。 
1756815347928-d7b946dd-0c2f-4199-bcfa-61676a09c344.jpg
|

好文要顶关注我收藏该文![1756815348021-849adb9a-2d36-43f9-b94e-772cc9f36e15.png](#)![1756815348087-5a4fc460-0202-4b50-aa5b-1663ffe09fec.png](#)![1756815348174-b1177fee-c95d-4512-bced-76d62e5d466f.jpg](http://home.cnblogs.com/u/lhrbest/)^_^小麦苗^_^

关注 – 28

粉丝 – 77+加关注00« 【BBED】 SYSTEM文件头损坏的恢复(4)

» 细致入微 | 让 SQL 优化再多飞一会儿