Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why do i see so high "Curs/Sess" in statspack?
lasse.jenssen_at_gmail.com wrote:
> My "open_cursors" is set to 1000. Why do i see so high value for
> "Curs/Sess" in statspack, and what effect could this have on
> performance?
>
> STATSPACK report for
>
> DB Name DB Id Instance Inst Num Release RAC Host
> ------------ ----------- ------------ -------- ----------- ---
> ----------------
> xxxxx xxx xxx xxxxxxx 1 10.1.0.4.0 NO
> redhat-db
>
> Snap Id Snap Time Sessions Curs/Sess Comment
> --------- ------------------ -------- ---------
> -------------------
> Begin Snap: 535 26-Jun-06 10:47:30 156 7,047.1
> End Snap: 536 26-Jun-06 11:17:35 155 7,123.3
> Elapsed: 30.08 (mins)
>
> Regards
> Lasse
See
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i38400
jg
-- @home.com is bogus. Viruses are good. http://www.harvardlawreview.org/issues/119/june06/note/immunizing_the_internet.pdfReceived on Mon Jun 26 2006 - 18:44:04 CDT