Statspack question [message #281565] |
Sun, 18 November 2007 07:04 |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
Hi,
I need some help on analysing statspack. In my statspack report, there is following sql reported:
SQL ordered by Parse Calls for DB: DB1 Instance: Ia Snaps: 10181 -1018
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
SELECT name, item, itemType, price
FROM name_table WHERE name=:1
12,408 12,408 1.29 1599154530
I do not know why there are as many parse calls as there are executions? - should not there be just one parse call and several executions? And if yes (there should be one parse call for several executions), then what could lead to this type of sql? What should be changed to rectify?
Thanks,
Nirav
|
|
|
|
|