Library Hit in statspac report

 Hi all,

   My db is 9.2.0.4 64bit on Unix.

   I generated report by statspack. And from the Instance Efficiency, Library Hit tell we know about shared pool and reusing SQL (relate with hard parse and soft parse), and this value should large (>=90%), am I right ?

   If I right, with example bellow, I think some things are fine but the Library Hit not fine ???

   Load Profile              Per Second    Per Transaction    Per Exec    Per Call

~~~~~~~~~~~~      ------------------  ----------------- ----------- -----------

      DB time(s):               38.5                3.6        0.00        0.05

       DB CPU(s):                3.0                0.3        0.00        0.00

       Redo size:        1,274,642.5          120,091.8

   Logical reads:          169,336.3           15,954.2

   Block changes:           10,512.6              990.5

  Physical reads:            3,190.5              300.6

 Physical writes:            1,239.4              116.8

      User calls:              743.1               70.0

          Parses:               79.5                7.5

     Hard parses:                0.5                0.1

W/A MB processed:               34.1                3.2