update seg$ top 2nd in SQL ordered by Gets in statspack report
615488Jan 17 2009 — edited Jan 22 2009Hi,
oracle version:8.1.7.0.0.
i had generated statspack report in that sql order by gets :
SQL ordered by Gets for DB: PINDB Instance: pindb Snaps: 203 -204
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
Buffer Gets Executions Gets per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
57,332,137 71 807,494.9 36.3 1161928628
select C.BILL_OBJ_ID0,B.BUFFER_BUF,A.ACCOUNT_NO,NVL(BB.START_T,0
),NVL(BB.END_T,0), nvl((select bill_no from bill_t where
account_obj_id0 =A.POID_ID0 and bill_no like 'PO%' and end_t=( s
elect max(end_t) from bill_t where account_obj_id0 =A.POID_I
D0 and start_t!=end_t and bill_no like 'PO%' and end_t < (se
23,853,967 1,860 12,824.7 15.1 2249281901
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts
=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13
, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cacheh
int=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17) where ts#=:1
and file#=:2 and block#=:3
i could not understand what this query (update seg$ set ) is this and why it is taking more intensive query(cpu heavy sql)
Thanks
Prakash
Edited by: prakashdba on Jan 17, 2009 6:26 AM
Edited by: prakashdba on Jan 17, 2009 6:28 AM