Scripts:curheaps.sql Updated on December 22, 2014 by Louis Liu 该script 显示各个cursor占用的heap大小 ——————————————————————————– — — File name: curheaps.sq[……] Read more
Script: search datafile segments in order For resizing datafiles Updated on December 22, 2014 by Louis Liu 下面脚本可以检测datafile 中创建segment的次序,以利于以后move object 进而resize datafile大小之用 block_id * 8代表 blocksize=8092 SQL>SET ECHO off FEEDBACK off HEADING o[……] Read more