Oracle Database Discussions

Hello everybody!

After I finished the installation of 10.1.0.4 (p4163362_10104_WINNT) on my existing 10.1.0.3 (the installation has been done according the installation notes), I noticed some strange behavior at first in Enterprise Manager Grid Control by getting an alert of the category "Database Limits" with the message:

Metriken "Current Open Cursors Count" in 1261

First I didn't belive that horrible value, so I did a simple select on v$sysstat and got the same value.

In the meanwhile the value has grown up to 972045 (!?!?!), but the database is still working fine (no other alerts so far).

Furthermore, by examining the object definition of v$sysstat I discoverd this:

CREATE PUBLIC SYNONYM "V$SYSSTAT"
FOR "SYS"."V_$SYSSTAT"


and "SYS"."V_$SYSSTAT" is:

CREATE OR REPLACE VIEW "SYS"."V_$SYSSTAT" ("STATISTIC#","NAME",
"CLASS","VALUE","STAT_ID") AS
select "STATISTIC#","NAME","CLASS","VALUE","STAT_ID"
from v$sysstat


I really wonder where the two objects gets its data, is this construct a perpetuum mobile or am I drunk?

Is someone out there experienced the same behavior or can anyone tell me whats going wrong to my 10.1.0.4 ?

regards
- nik madzar