[Spacewalk-list] massive transactions on dist import

Marcus Moeller mail at marcus-moeller.de
Mon Nov 2 15:32:48 UTC 2009


Dear Michael.

> % Hi,
> %
> % >> we have noticed that a distribution import (e.g. full F11 64bit) causes a huge oracle transaction log (about 50GB). The database itself has a size of about 7GB atm.
> %
> % > I'm sorry I have no idea what transaction log are you talking about.
> % > Could you be more specific?
> %
> % I was talking about the Oracle Transaction Log. During an mass import
> % using spacewalk-repo-sync/satellite-sync, we got about 70 transactions
> % per second, extremely bloating the transaction log.
>
> Well, I'm an Oracle DBA for a quite long time but I still don't know
> what is Oracle Transaction Log. Nor google helps me. So, are you talking
> about audit log? Or is it a file? Or a table inside database? Could you
> send a specific command how do you found out it's  about 50GB?

I was talking about the archive log.

Best Regards
Marcus
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3253 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20091102/151be09e/attachment.p7s>


More information about the Spacewalk-list mailing list