Home » RDBMS Server » Performance Tuning » statspack error
statspack error [message #252806] Fri, 20 July 2007 01:18 Go to next message
somavamshi
Messages: 17
Registered: July 2007
Location: bangalore
Junior Member
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

Re: statspack error [message #252810 is a reply to message #252806] Fri, 20 July 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read How to format your posts and retry.
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Maybe this
Quote:
ERROR: End Snapshot Id specified does not exist for this database/instance

is a clue?

Regards
Michel
Re: statspack error [message #252898 is a reply to message #252810] Fri, 20 July 2007 09:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check it

http://ora-00604.ora-code.com/msg/31295.html
Re: statspack error [message #252910 is a reply to message #252898] Fri, 20 July 2007 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any relation between the question and your link.
Apart from Statpack name and an error (but not the same of the question) but if you want to post every link with "Statpack" and "ORA-" inside...

Regards
Michel
Re: statspack error [message #252916 is a reply to message #252910] Fri, 20 July 2007 10:58 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID

begin


I guess link cover this error.
Re: statspack error [message #252923 is a reply to message #252916] Fri, 20 July 2007 11:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The most important is the FIRST error.
The other ones are so secondary that I even does not worth to read them.
Focusing on a secondary error is misleading.
The OP can read and search during hours on this error and this will not lead to anything.

In this case, this error is an error. There is no "Snapshots chosen span an instance shutdown" there is "End Snapshot Id specified does not exist".

Regards
Michel

Re: statspack error [message #393840 is a reply to message #252923] Tue, 24 March 2009 10:44 Go to previous messageGo to next message
Arsitobule
Messages: 1
Registered: March 2009
Location: France
Junior Member
Same error with Reflection (HP-UX emulator). In fact, i was entering numbers with the numeric pad and it doesn't work.
Try with the numbers on the keyboard (above the letters)
Re: statspack error [message #393841 is a reply to message #252806] Tue, 24 March 2009 10:49 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Why are you responding to a 2 year old post?

[Updated on: Tue, 24 March 2009 10:50]

Report message to a moderator

Previous Topic: Performance tuning
Next Topic: Tkprof trace file meaning
Goto Forum:
  


Current Time: Tue Dec 06 08:21:10 CST 2016

Total time taken to generate the page: 0.10663 seconds