2022年3月5日
Shared Pool Tuning
摘要： Tuning Library Cache: 1. Increase the size of the shared pool if GETHITRATIO is less than 90%. Check gethitratio in v$librarycache: SQL> select gethit 阅读全文
posted @ 2022-03-05 13:09 baowei*blog 阅读(42) 评论(0) 推荐(0)
Rebuild Index Script
摘要： -- Rebuild index Select 'alter index '||owner||'.'||index_name||' rebuild ONLINE;' from dba_indexes d where D.TABLE_NAME ='PROVIDE_TABLE_NAME' and D.O 阅读全文
posted @ 2022-03-05 13:05 baowei*blog 阅读(37) 评论(0) 推荐(0)