[DB lock 풀기] # alter system kill session 'SID No,Serial#'; [DB lock 확인] # select a.object_name name, b.session_id sid, c.serial#, c.machine from dba_objects a, v$locked_object b, v$session c where a.object_id=b.object_id and b.session_id=c.sid; File name, tablespace 확인 select file_name, tablespace_name, bytes/1024/1024 from dba_data_files; Flile name 및 size 확인 select file_name, bytes/1024/1024 M..

[비활성화 vg 디스크 활성화 명령어] # lvchange -ay [vg디스크 명] # lvchange -ay /dev/vg_http/lv_http [lv stripe 확인] # lvs --segment LV VG Attr #Str Type SSize lvol01 VG01 -wi-ao-- 6 striped 15.00g