#眉標=Oracle、SGA、PGA #副標=Oracle資料庫優化實務經驗談(1) #大標=運作速度優化與記憶體配置 #作者=文/圖 賞金獵人 ===<反灰>============= select count(*) from v$session ================ ===<反灰>============= Select count(*) from v$process ================ ===<反灰>============= select owner, table_name, num_rows, chain_cnt , round((chain_cnt*100/num_rows),6) as Percent from dba_tables where owner not in ('SYS','SYSTEM') and chain_cnt<>0 ================ 更多優化有關的細節,可來信討論:Bountyhunter.z@hotmail.com。