measure time a SQL has taken

[st2003]

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

[pando]

dupe

http://forums.dbasupport.com/forums/...threadid=39256