Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: number of cursors
Karl Hungus wrote:
>>Depends on whether more traffic means more sessions. The question >>is really one of whether you are a good coder and close what you >>open. Bad C leaks memory ... bad PL/SQL leaks cursors.
A session is a connection to the database ... look at the 'magic' view v_$session. There is one row per session. With dedicated connections ... one user equals on session. With the web it may well be that many users connected through an app server equate with only one or a few connected sessions.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Feb 28 2004 - 11:53:20 CST