Oracle Database Discussions

Hi,

I am trying to use the snapper tool provided by Tanel Poder. Since my database is suffering some CBC latch.

       SID NAME                                      Held       Gets  Held %     Held ms Avg hold ms
---------- ----------------------------------- ---------- ---------- ------- ----------- -----------
     14167 cache buffers chains                       356        356   35.60    3933.800      11.050
     12597 cache buffers chains                       343        342   34.30    3790.150      11.082
     13867 cache buffers chains                       316        315   31.60    3491.800      11.085
     10538 cache buffers chains                       301        301   30.10    3326.050      11.050
     13558 cache buffers chains                       273        273   27.30    3016.650      11.050
     11673 cache buffers chains                       240        239   24.00    2652.000      11.096
     13352 cache buffers chains                       239        239   23.90    2640.950      11.050
     13039 cache buffers chains                       202        202   20.20    2232.100      11.050
     11708 cache buffers chains                       184        184   18.40    2033.200      11.050
     12833 cache buffers chains                       180        180   18.00    1989.000      11.050
     14406 cache buffers chains                       179        179   17.90    1977.950      11.050
     10507 cache buffers chains                       173        172   17.30    1911.650      11.114
      9942 cache buffers chains                       170        170   17.00    1878.500      11.050
     12041 cache buffers chains                       168        161   16.80    1856.400      11.530
.
.

I was trying to trace the session 14167. But snapper is asking for some input which I can't understand:

SQL> @snapper stats 5 1 14167
Sampling SID 14167 with interval 5 seconds, taking 1 snapshots...
Enter value for _if_or:  
    procedure fout is
    *
ERROR at line 181:
ORA-06550: line 181, column 5:
PLS-00103: Encountered the symbol "PROCEDURE"


SQL> @snapper ash=sid+event+wait_class,ash1=sid+sqlid+module,stats,gather=ts,tinclude=CPU,sinclude=parse 5 1 14167
Sampling SID 14167 with interval 5 seconds, taking 1 snapshots...
Enter value for _if_or:

--   The Session Snapper v3.52
--   (c) Tanel Poder ( http://www.e2sn.com )

what is ifor it is asking for?

Regards,