Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

elapsed time - set timing and time on sqlplus

71610May 31 2009 — edited May 31 2009
I use these at sqlpromt
SQL>set time on
SQL>set timing on

I then execute the procedure that ran for couple days. I get the elapsed time displayed as follows....

16:15:32 SQL> set timing on
16:15:32 SQL> @/export/dba/dm/insert_dmv_prc_plsql

PL/SQL procedure successfully completed.

Elapsed: -02:-54:-45.-26
12:38:41 SQL>

Elapsed time displayed is strange, i am not sure if these are "-ve". This plsql script ran for couple days. I wanted to interpret the exact elapsed time...
I am sure it ran for more than 2 days...

Thanks
San~
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2009
Added on May 31 2009
#general-database-discussions
1 comment
2,217 views