Friday, August 15, 2008

Finding orphan mview log registrations

# If someone creates a fast refresh mview in a database it registers with the primary database mview log, and the log keeps all transactions until the next mview refresh. If the destination database is deleted, the primary database mview log will keep growing. The following will check for mview log registrations that have not been refreshed recently.

select * from SYS.SLOG$;