Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why do i see so high "Curs/Sess" in statspack?

Why do i see so high "Curs/Sess" in statspack?

From: <lasse.jenssen_at_gmail.com>
Date: 26 Jun 2006 11:19:33 -0700
Message-ID: <1151345973.586304.138270@u72g2000cwu.googlegroups.com>


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 Received on Mon Jun 26 2006 - 13:19:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US