Explain Plan Steps Always Show 1 Second
Comments
-
Hi,
Are you planning to migrate to the first patchset (12.1.0.2)? That is the terminal release for 12c Rel. 1 and is far more robust. It would also be interesting to know whether the issue reproduces in 12.1.0.2.
That being said, the issue of too low a time estimate in execution plan output was raised against Rel. 11.2.0.2 as Bug 12405410 and determined by Development not to be a bug. (If, however, the cost-based optimizer chooses an execution plan which runs slowly over one which runs quickly, then that would qualify as a bug.)
Sincerely,
Ted
Oracle Support Services
0 -
above time in plan not always correct and by this column we can not conclude the query elapsed time.
if you've DB tuning license then you can get detail of all these thing at real time by sql monitoring feature.
http://www.oracle.com/technetwork/database/manageability/owp-sql-monitoring-128746.pdf
0