DB서버가 부하가 걸리는거 같아 다음과 같은 쿼리를 날려봤습니다..
select p.spid OS_PID,
s.sid SID,
s.serial# serial,
s.username USERNAME,
s.osuser,
s.program,
a.sql_text SQL
from v$sqltext a, v$session s, v$process p
where p.addr = s.paddr
and a.address = s.sql_address
and a.hash_value = s.sql_hash_value
order by p.spid,a.piece
현재 서버에서 돌고있는 프로세스와 해당 쿼리 내용이 보여지게 되는데요..
Row# OS_PID SID SERIAL USERNAME OSUSER PROGRAM SQL
16302 78 43875 nobody ? @www (TNS V1-V3) select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,
16302 78 43875 nobody ? @www (TNS V1-V3) i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i
16302 78 43875 nobody ? @www (TNS V1-V3) .distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.sa
16302 78 43875 nobody ? @www (TNS V1-V3) mplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt
16302 78 43875 nobody ? @www (TNS V1-V3) ,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),n
16302 78 43875 nobody ? @www (TNS V1-V3) vl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,s
16302 78 43875 nobody ? @www (TNS V1-V3) pare2,decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),2
16302 78 43875 nobody ? @www (TNS V1-V3) 56)) from ind$ i, (select enabled, min(cols) unicols, min(to_num
16302 78 43875 nobody ? @www (TNS V1-V3) ber(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4)
16302 78 43875 nobody ? @www (TNS V1-V3) )) valid# from cdef$ where obj#=:1 and enabled > 1 group by enab
16302 78 43875 nobody ? @www (TNS V1-V3) led) c where i.obj#=c.enabled(+) and i.bo#=:1
이런 이상한 쿼리문이 발견되었습니다..
위내용중 쿼리만 정리해서 보여본다면
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,
i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,
i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,
nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),
i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),
i.spare4,spare2,decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256))
from ind$ i,
(select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c
where i.obj#=c.enabled(+) and i.bo#=:1
이렇게 됩니다..
던진쿼리문은 그렇다 텨도..
문제는 nobody가 이 쿼리문을 던졌다는겁니다..웹상에서..
저희 DB뚤린건가요..?
위 쿼리의 의미는 무엇일까요? 고수님들의 조언이 간절히 필요합니다..
ㅠㅠ
살려주세요 |