insert into $to.V_RESERVED_SIZE_HISTORIES select SYSDATE , '$sid' , FREE_SPACE , AVG_FREE_SIZE , FREE_COUNT , MAX_FREE_SIZE , USED_SPACE , AVG_USED_SIZE , USED_COUNT , MAX_USED_SIZE , REQUESTS , REQUEST_MISSES , LAST_MISS_SIZE , MAX_MISS_SIZE , REQUEST_FAILURES , LAST_FAILURE_SIZE , ABORTED_REQUEST_THRESHOLD , ABORTED_REQUESTS , LAST_ABORTED_SIZE from v$shared_pool_reserved@$sid / col freespc for 999999999 col avgfree for 9999999 col maxfree for 9999999 col used for 999999999 col avgused for 9999999 col requests for 99999999 col failures for 99999999 col lstfailsz for 999999 col misses for 999999 col lstmisssz for 99999 col maxmisssz for 9999
set pages 50000 lines 100 echo off veri off spool $td/$newsid.reserved_size.log
col freespc for 999999999 col avgfree for 9999999 col maxfree for 9999999 col used for 999999999 col avgused for 9999999 col requests for 99999999 col failures for 99999999 col lstfailsz for 999999 col misses for 999999 col lstmisssz for 99999 col maxmisssz for 9999
spool $newsid.reserved_size.$ts spool $newsid.reserved_size.$ts select x.ksppinm||'='||y.ksppstvl PARAMETERS from x$ksppi x, x$ksppcv y where x.indx = y.indx and x.ksppinm like '%reserved%' /