 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
Snapshot View Source Log Last Ref Typ Next Ref
Started Query
---------------- ------- --------- --- --------- --- ---------
--------- ------
TEST.SNAP$_TEST MVIEW$_ DEV7_DBA. YES 10-JUN-93 F SYSDATE+7
10-JUN-93 SELECT CHECK_DATE
TEST HIT_RATIO FROM
HIT_RATIOS
mv_log_rep.sql
rem
rem Name: mv_log_rep.sql
rem Purpose: Report on database materialized view Logs
rem Use: From an account that accesses DBA_ views
rem
rem When Who What
rem ------- --------- ----------------
rem 5/27/93 Mike Ault Initial Creation
rem 10/10/01 Mike Ault Updated to oracle9i
rem
SET PAGES 56 LINES 130 FEEDBACK OFF
ttitle "Materialized View Log Report"
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
