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