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!

What is the 'Alter summary'

user60022Nov 15 2011 — edited Nov 23 2011

Hi All,

My DB is 11.2 Exadata box. When I checked one sql in v$sql, I found the sql it exeutes is 'ALTER SUMMARY "XXX"."XXXX_MV" COMPILE'

But I checked all distinct object type in dba_objects, no summary object_type at all.

I also googled this command but no many useful links.

Could someone give me some tips here, please?

Best regards,

Leon

This post has been answered by Dom Brooks on Nov 15 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2011

Added on Nov 15 2011

4 comments

3,028 views