Curs/Sess in the STATSPACK report shows as #########

Hi,

The STATSPACK report shows in this way.

Snap Id Snap Time Sessions Curs/Sess Comment
--------- ------------------ -------- --------- -------------------
Begin Snap: 34343 12-Sep-09 18:00:03 37 #########
End Snap: 34344 12-Sep-09 19:00:02 39 #########
Elapsed: 59.98 (mins)

I have question regarding the following.

Curs/Sess
---------
#########
#########

Is there in concern regarding this pound sign in the above.

values overflow edition mask.

Quote:

---

Originally Posted by PAVB

values overflow edition mask.

---

Exactly, you need to either modify the script or select a smaller interval.
:rolleyes:
PS: Change the format in the sprepins.sql script.

Hope number of cursors open is more per session, that is why # is coming. Is there any way to control the number of cursors open..?