SQL & PL/SQL

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!

Select on view is long - Select on view definition short.

Blues BreakerJun 7 2012 — edited Jun 7 2012

Greetings Everyone -

There is a view in Oracle called V$LOCK.

If I do a count or a select on this view I get a result in *45 seconds*.

There are only 77 records.

However - If I do a select or a count on the view definition (found in V$FIXED_VIEW_DEFINITION)
I get a result in no time. Immediately.

I am signed in accordingly 'sqlplus / as sysdba'

What's going on ??? My feable brain cannot comprehend!!!

Thanks for any help,

BB

This post has been answered by unknown-7404 on Jun 7 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2012

Added on Jun 7 2012

#11g, #sqlplus

8 comments

216 views