Oracle Database Discussions

hi guys,

i am viewing an addm report and is concern about a top sql activity.

i have an sql having top elasped time.

<i>
2,372 2,275 128,690,535 0.00 4.28 fphtjnquzzpud radiusd@localhost.localdomain (TNS V1-V3) SELECT USER_ID FROM SUBSCRIBER...
</i>



q1) what is the meaning of elasped time ?
the time taken per execution of an sql statement ?

q2) is the elasped time in the report shown above = sum of all the the elapsed time per execution of the sql ?

if that the case, the most/frequently i run a SQL statement, the higher the elasped time it will be and thus higher db time.

but how can we say that it is an inefficient sql since it has the most elasped time just because it is run way too frequently then other sqls ?


Please advise
Regards,
Noob