Hi ...
While I am running statspack I am facing error.. below shown. Pls resolve this issue.
1) Begin : 3 END : 4
ERROR: End Snapshot Id specified does not exist for this database/instance
WARNING: timed_statitics setting changed between begin/end snaps: TIMINGS ARE IN
VALID
ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID
ERROR: Session statistics are for different sessions: RESULTS NOT PRINTED
begin
*
ERROR at line 1:
ORA-20100: Missing end value for statistic: db block changes
ORA-06512: at "PERFSTAT.STATSPACK", line 977
ORA-06512: at "PERFSTAT.STATSPACK", line 1102
ORA-06512: at line 2
2) Begin 1 End 2
VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
2 1 0.74 2522684317
Module: sqlplus@servername (TNS V1-V3)
BEGIN statspack.snap; END;
1 2 0.37 204386021
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) fro
m objauth$ where obj#=:1 and col# is not null group by privilege
#, col#, grantee# order by col#, grantee#
1 1 0.37 431456802
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
1 2 0.37 839312984
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decod
e(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180
,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedsto
rage,nvl(deflength,0),default$,rowid,col#,property, nvl(charseti
d,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ wh
1 4 0.37 1433558559
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
1 1 0.37 1480155015
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.sa
mplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt
,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),n
1 2 0.37 1980305124
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)
)from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(co
l#,0) order by grantee#
1 1 0.37 2367942048
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clu
cols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,
blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,
property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernel
cols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6
1 1 0.37 2889900621
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#
=:1
0 5 0.00 2703824309
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$,
spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespa
SQL ordered by Parse Calls for DB: ATICSPRD Instance: aticsprd Snaps: 1 -2
While am taking with 1 and 2 Ids I am getting the values and also the above script. WHy its showing the script..
[Updated on: Fri, 20 July 2007 01:23] Report message to a moderator |
] 
Blog
Search
Help
Members
Register
Login
Home
