定期的にサイズをチェックし、shrinkなどの対策をするといいでしょう。
実行例は次の通り。set time on set pages 10000 set lines 120 col segment_name for a30 col tablespace_name for a20 col bytes for 9,999,999,999 select tablespace_name,segment_name,bytes from ( select rank() over (order by bytes desc) rnk, tablespace_name,segment_name,bytes from dba_segments ) where rnk<=20;
TABLESPACE_NAME SEGMENT_NAME BYTES -------------------- ------------------------------ -------------- SSS01_INDPA1_DATA TBL_CHARGECONSENTLOG1 1,412,431,872 SSS01_MASTERD_DATA TBL_OBJECTIVESTREAMING01LOG1 1,046,478,848 SSS01_MASTERD_DATA IXT2_OBJECTIVESTREAMING01LOG1 745,537,536 SSS01_MASTERD_DATA TBL_MEDIAAPPITEMLOG1 732,954,624 SSS01_MASTERD_DATA TBL_OBJECTIVESTREAMING01LOG3 495,976,448 SSS01_MASTERD_DATA TBL_OBJSTREAMING01LOG1_1201 490,733,568 SSS01_MASTERD_DATA TBL_OBJSTREAMING01LOG1_0101 475,004,928 SSS01_MASTERD_DATA TBL_OBJSTREAMING01LOG1_0201 452,984,832 SSS01_MASTERD_DATA TBL_CCACCESS1 418,381,824 SSS01_MASTERD_DATA TBL_OBJSTREAMING01LOG1_1101 387,973,120 SSS01_MASTERD_DATA IXT2_OBJECTIVESTREAMING01LOG3 353,370,112 FUKA_I_DATA TBL_OBJECTIVESTREAMING011 344,981,504 SSS01_MASTERD_DATA TBL_MEDIABAGLOG1 342,884,352 FUKA_I_DATA TBL_DAILYTEXTMACHINEUPLOAD1 319,815,680 FUKA_I_DATA TBL_USERSESSION1 318,767,104 FUKA_I_DATA TBL_DAILYTEXTTOTALUPLOAD1 279,969,792 SSS01_I_DATA TBL_USERSESSION1 264,241,152 FUKA_I_DATA TBL_CCQUIZ_USER_RESULT1 244,318,208 FUKA_I_IDX IXT1_DAILYTEXTTOTALUPLOAD1 236,978,176 SSS01_MASTERD_DATA TBL_OBJSTREAMING01LOG3_0201 227,540,992
0 件のコメント:
コメントを投稿