OraFAQ Forum: SQL & PL/SQL » materialized view log size doesn't correlate with its rows quantity

Home » SQL & PL/SQL » SQL & PL/SQL » materialized view log size doesn't correlate with its rows quantity (Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

materialized view log size doesn't correlate with its rows quantity [message #628051]

Wed, 19 November 2014 09:34

ecivgamer
Messages: 147
Registered: May 2011
Location: Ukraine

Senior Member

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

Report message to a moderator