Payroll On Oracle Database

We are currently testing payroll and are due to go live in a month. When we ran our first full payroll for salaried staff (approx 500) the job fell over with an Oracle error "ORA-01000: maximum open cursors exceeded". Our Oracle initialisation parameter for Open_Cursors is set to 1000 which I think is quite high. I would appreciate hearing from anybody who is running payroll on an Oracle database as to what they have set in their INIT file.

Regards
Marty

Marty,

We have open cursors set to 2000 and we are not running payroll.

Regards

Adam

Thanks for this Adam. I thought we were quite high with 1000. Any
performance / tuning issues that we should be aware of before increasing it?

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K






OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K

Re: RE: Payroll On Oracle Database

Marty,

I don't believe that there will be an issue. Each open cursor requires about 250 bytes out of the shared pool.

You can query performance of the shared pool by looking performance monitors such as the cache hit ratio etc.

Caveat: I am not an OCP DBA so please check the above with somebody suitably qualified or maybe one of the Oracle gurus on here can confirm this

Regards

Adam

I'm not on Oracle but, I had an issue with the maximum open cursors exceeded
within the JDE payroll run itself. What is the last ESU you put on?



Jeremey Garcia
Greenville, SC, USA
Xe SP14; ES - AS/400; CO - AS/400; Deploy - NT Citrix - NT SP6; Report Distribution - Formscape;

Re: RE: Payroll On Oracle Database

Marty,

look up the JDE.INI parameter OracleServerHandleReuse=0 under [DB SYSTEM SETTINGS].

It may have a bearing on this.

Cheers,

Thanks for all the replies everybody.

Jeremey

I'm not actively involved in the payroll deployment so I'm not sure what ESU
we are up to. (Go and find out - you say!). It's not quite as easy as that
as we have a bit of of hotch potch of esu's and updates at the moment. We
are offically on update 1 but in order to get payroll working have been
applying esu's from other updates at JDE's request. I suspect that you have
put your finger on the problem. I think I will pass this to Denver as our
development manager is over there working with JDE at the moment. Did you
solve your issue with an ESU?

Adam

I checked with Oracle and you are correct. The effect will be negligible. We
will up the cursor value to 2000 and see what happens.

Larry

Thanks for this. Yes we have that setting in out JDE.ini.


Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K






OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K