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