1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

materialized view log size doesn't correlate with its rows quantity

Discussion in 'General' started by ecivgamer, Nov 19, 2014.

  1. ecivgamer

    ecivgamer Active Member

    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    130
    Hi all,

    We investigated that materialized view log size doesn't correlate with its rows quantity.

    For example,

    select segment_name, bytes from dba_segments where (segment_name, owner) = (
    select log_table, log_owner
    from dba_mview_logs
    where master = 'AP_INVOICES_ALL'
    )

    SEGMENT_NAME BYTES
    ------------------------------
    MLOG$_AP_INVOICES_ALL 113786880


    select count(1) cnt from AP.MLOG$_AP_INVOICES_ALL

    CNT
    ----------
    15

    Maybe I just do not know something, but

    select 113786880 / 1024 / 1024 as mbytes from dual

    MBYTES
    ----------
    108,515625

    this size doesn't seem to be the appropriate.

    Could someone please comment?

    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    PL/SQL Release 9.2.0.4.0 - Production
    "CORE 9.2.0.3.0 Production"
    TNS for Solaris: Version 9.2.0.4.0 - Production
    NLSRTL Version 9.2.0.4.0 - Production