管理内存
show parameter db_block 查看标准块信息
CREATE INDEX cust_idx …
STORAGE (BUFFER_POOL KEEP);
ALTER TABLE oe.customers
STORAGE (BUFFER_POOL RECYCLE);
ALTER INDEX oe.cust_lname_ix
STORAGE (BUFFER_POOL KEEP);
show parameter cache 查看sga块分配情况
show parameter shared_pool查看共享池空间
select component,current_size from v$memory_dynamic_components;查看各内存情况
select * from v$sgastat where pool='shared pool' 查看共享内存 内部分配情况
V$MEMORY_DYNAMIC_COMPONENTS has the current status of all memory components
V$MEMORY_RESIZE_OPS has a circular history buffer of the last 800 memory resize requests
V$MEMORY_TARGET_ADVICE provides tuning advice for the MEMORY_TARGET initialization parameter
CREATE INDEX cust_idx …
STORAGE (BUFFER_POOL KEEP);
ALTER TABLE oe.customers
STORAGE (BUFFER_POOL RECYCLE);
ALTER INDEX oe.cust_lname_ix
STORAGE (BUFFER_POOL KEEP);
show parameter cache 查看sga块分配情况
show parameter shared_pool查看共享池空间
select component,current_size from v$memory_dynamic_components;查看各内存情况
select * from v$sgastat where pool='shared pool' 查看共享内存 内部分配情况
V$MEMORY_DYNAMIC_COMPONENTS has the current status of all memory components
V$MEMORY_RESIZE_OPS has a circular history buffer of the last 800 memory resize requests
V$MEMORY_TARGET_ADVICE provides tuning advice for the MEMORY_TARGET initialization parameter
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28889722/viewspace-1252767/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
