Re: Why does a datafile extend a very large amount at very infrequent intervals?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Wed, 11 Jul 2012 13:45:53 +0300
Message-ID: <CAD0-DgjbuvkiintyUaEGTT0E1JabTUFcpDD_03KfRaWwfnut4A_at_mail.gmail.com>

Hey Rich, thank you for bringing this to our notice. We are too suffering from this, where tbs grows 18GB at one shot and unfortunately Oracle hasn't answered yet.
I really need to have a look at this Note. We are on 11.2.0.3, is there any work around exists till we get the 11204? On Wednesday, July 11, 2012, Rich wrote:

> [removing the rest of the email chain to prevent getting over-quoting]
> Finally found the answer to this one (with no help from Oracle Support) -
> it's due to the new [in 11g] Oracle process ora_smco.
> This process "performs tablespace-level space (extent) pre-allocation".
>
> This is noted in Oracle Note 743773.1 (last modified 13APR2012).
>
>
> Another thing to potentially note about this is that this process spawns
> slave processes (ora_w###).
>
> On our instance, we also see these processes consuming more CPU time than
> expected - this is bug 12760469: STBH: KTSJ USES CONSIDERABLE AMOUNT OF
> DATABASE TIME/CPU RESOURCE.
>
> This bug is supposed to be fixed in 11.2.0.4.
>
> Rich
>
> Including keywords such that a search will hopefully find this:
> NEXT_EXTENT DBA_DATA_FILES INCREMENT_BY
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
<http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
Oracle Certified Master
(10g)<http://education.oracle.com/education/otn/shussain.html>
Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
*Oracle Magazine DBA of year (2011)*
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
ITIL V3 foundation certified
Oracle RAC SIG Representative for Saudi Arabian
region<http://www.oracleracsig.org>

Advisory & Governance Council for
VirtaThon<http://www.brainsurface.com/virtathon/advisorygovernancecouncil/>
I blog at  : http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
Follow me on twitter : http://twitter.com/#!/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 11 2012 - 05:45:53 CDT