can't get the Query Cost!

From: <wy_at_fudan.edu>
Date: Thu, 23 Dec 1999 14:44:04 GMT
Message-ID: <83tcei$h2u$1@nnrp1.deja.com>

I use 'Explain plan set statement_id ='aa' for &sql' to get the query execute path!
but the results in different user are different!

in user 'pmis'
I can get the cost values in plan_table but in user 'pmis1'
I can not get the cost values in plan_table, they are all null!
why?
Other information such as operation are all the same for the same sql. I have tried some different sqls.

Thanks a lot!

wangyang.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 08:44:04 CST