SQL & PL/SQL

Hi,
My database is showing Max OPen Cursors exceeded error and I have set the value open_cursors =1000 and after few days same problem repeated.
when I tried to find the open cursors thru the Query

select a.value, s.username, s.sid, s.serial# ,s.PROGRAM,s.inst_id
from gv$sesstat a, gv$statname b, gv$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current' ;

I found the following result
VALUE USERNAME SID SERIAL# INST_ID SQL_ID PROGRAM PROCESS

1 399 158 1 2 oracle@EH-DB2 (CKPT) 16538
2 118 158 1 1 oracle@EH-DB1 (CKPT) 31532
3 85 HR 110 306 1 w3wp.exe 4696:2688


can you please advice why the value for CKPT process is high .
Note : we have two 2 instances in our database.

Edited by: user11342455 on Jul 30, 2010 6:25 AM