Skip to Main Content

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 in my V$SQL

556422Aug 22 2007 — edited Aug 28 2007
Hi,

Can someone answer this please?. I'm bit perplexed by the elapsed time in my v$sql

UPDATE ods_router_tables SET last_data_received = :b1, last_data_received_dst = :b3 WHERE
table_name = :b2 AND NVL(last_data_received,TO_DATE('01-JAN-1980','DD-MON-YYYY')) < :b1

Executions: 2786327
Disk reads: 0
Buffer gets: 6023381
Rows processed: 423713
Optimizer cost: 1
Sorts: 0
CPU Time: 898500000
Elapsed Time: 1.84467440681166E19

This table is quite small, only 44 records and if i run the statement in Sql plus, it runs in a
flash. But why this enormous Elapsed time in V$SQL. Is my conversion of this time to
seconds/execution correct?

Elapsed time in seconds/execution: 1.84467440681166E19/1000000/2786327=6620451 seconds!

I guess there is something seriously wrong here. I'm running on a 4 CPU server. DB version is 9.2.

I see similar figures in some of the innocent looking Insert statements as well.

thanks in advance,
Sunil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2007
Added on Aug 22 2007
8 comments
25,533 views