Hello:

How would I measure the amount of time the sql has taken or will take?

Sql already executed can be seen in v$sql and v$sqltext. Autotrace or explain_plan can be made for a sql that will be executed. Are these a good start?

Thanks, ST2003