測試將表快取到keep池
1、設定keep池大小
SYS@jzh>alter system set db_keep_cache_size=60m;
System altered.
2、建立測試表
JZH@jzh>create table t as select * from dba_objects;
Table created.
3、檢視執行計劃
JZH@jzh>select * from t;
74756 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
5985 consistent gets
1065 physical reads
0 redo size
8574342 bytes sent via SQL*Net to client
55336 bytes received via SQL*Net from client
4985 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
74756 rows processed
4、將表存放keep池中
JZH@jzh>alter table t storage (buffer_pool keep);
Table altered.
5、查詢表是否在keep池中
JZH@jzh>select table_name,buffer_pool from user_tables;
TABLE_NAME BUFFER_POOL
------------------------------ --------------------
T KEEP
6、查詢表是否被cache
JZH@jzh>select table_name,buffer_pool,cache from user_tables;
TABLE_NAME BUFFER_POOL CACHE
------------------------------ -------------------- --------------------
T KEEP N
7、快取表
JZH@jzh>alter table t cache;
Table altered.
JZH@jzh>select table_name,buffer_pool,cache from user_tables;
TABLE_NAME BUFFER_POOL CACHE
------------------------------ -------------------- --------------------
T KEEP Y
8、檢視執行計劃
JZH@jzh>select * from t;
74756 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
5987 consistent gets
0 physical reads
0 redo size
8574342 bytes sent via SQL*Net to client
55336 bytes received via SQL*Net from client
4985 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
74756 rows processed
SYS@jzh>alter system set db_keep_cache_size=60m;
System altered.
2、建立測試表
JZH@jzh>create table t as select * from dba_objects;
Table created.
3、檢視執行計劃
JZH@jzh>select * from t;
74756 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
5985 consistent gets
1065 physical reads
0 redo size
8574342 bytes sent via SQL*Net to client
55336 bytes received via SQL*Net from client
4985 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
74756 rows processed
4、將表存放keep池中
JZH@jzh>alter table t storage (buffer_pool keep);
Table altered.
5、查詢表是否在keep池中
JZH@jzh>select table_name,buffer_pool from user_tables;
TABLE_NAME BUFFER_POOL
------------------------------ --------------------
T KEEP
6、查詢表是否被cache
JZH@jzh>select table_name,buffer_pool,cache from user_tables;
TABLE_NAME BUFFER_POOL CACHE
------------------------------ -------------------- --------------------
T KEEP N
7、快取表
JZH@jzh>alter table t cache;
Table altered.
JZH@jzh>select table_name,buffer_pool,cache from user_tables;
TABLE_NAME BUFFER_POOL CACHE
------------------------------ -------------------- --------------------
T KEEP Y
8、檢視執行計劃
JZH@jzh>select * from t;
74756 rows selected.
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
5987 consistent gets
0 physical reads
0 redo size
8574342 bytes sent via SQL*Net to client
55336 bytes received via SQL*Net from client
4985 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
74756 rows processed
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-2130063/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Cache】將常用的“小表”快取到Buffer Cache快取
- Buffer Cache(緩衝區快取)篇:keep pool(保留池)快取
- Dcat Admin 自定義 Form 表單—將配置內容快取到 Redis 並統一呼叫ORM快取Redis
- oracle KEEP池的CACHE特點Oracle
- 程式池、執行緒池效率測試執行緒
- 【轉】設定db_keep_cache_size快取,並把一個表快取進去快取
- keep-alive:元件級快取Keep-Alive元件快取
- 快代理代理IP測試,最新代理IP質量測試
- Vue 頁面快取keep-aliveVue快取Keep-Alive
- VUE快取:動態keep-aliveVue快取Keep-Alive
- Vue 全站快取之 keep-alive : 動態移除快取Vue快取Keep-Alive
- 【專項測試系列】-快取擊穿、穿透、雪崩專項測試快取穿透
- MYSQL壓縮表測試MySql
- UIWebView攔截圖片請求,SDWebImage下載快取到本地,然後從本地讀取到UIWebView中UIWebView快取
- 將檔案讀取到連結串列裡面
- 修改Ehcache快取中取到的值,快取中的值也被修改了快取
- 寫Cache快取物件測試例項快取物件
- 實現vue 的keep-alive快取功能VueKeep-Alive快取
- 11.2使用KEEP池導致ENQ: KO - Fast Object Checkpoint等待ENQASTObject
- 巢狀表的測試(一)巢狀
- 巢狀表的測試(二)巢狀
- MySQL 5.5 MyISAM表鎖測試MySql
- 測試TOM=SQLLDR生成外部表SQL
- 表分割槽機制測試
- myBatis 基礎測試 表關聯關係配置 集合 測試MyBatis
- php 快取使用監控測試程式碼PHP快取
- 產品/測試 思考的快與慢--02
- 產品/測試 思考的快與慢--05
- 夠快雲庫可用性測試記
- 【JDBC】java連線池模擬測試 連線oracleJDBCJavaOracle
- Sqlserver資料寫入表測試SQLServer
- 軟體測試常用術語表
- Oracle 用拼接字串更新表 測試Oracle字串
- oracle外部表的測試學習 (轉)Oracle
- Oracle可傳輸表空間測試Oracle
- MySQL 5.5 InnoDB表鎖行鎖測試MySql
- Oracle調優-常用表KEEP到記憶體中Oracle記憶體
- Keep小表到記憶體,提高訪問速度記憶體