SYSAUX Table Shrink
1. 스냅샷 설정 확인 select * from dba_hist_wr_control ; 2. 현재 스냅샷 조회 col startup_time for a30 col begin_interval_time for a30 select snap_id, startup_time, begin_interval_time, snap_level from dba_hist_snapshot…
DB Admin Knowhow
1. 스냅샷 설정 확인 select * from dba_hist_wr_control ; 2. 현재 스냅샷 조회 col startup_time for a30 col begin_interval_time for a30 select snap_id, startup_time, begin_interval_time, snap_level from dba_hist_snapshot…