RE: Rapidly Growing space usage in TS with only two indexes
- From: "Nizar Ahmed" <gnahmed.c@xxxxxxxxxx>
- To: "arul kumar" <arul76_2000@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 10 Jun 2006 09:35:30 +0300
Nope. The indexes were not rebuilt.
And secondly why would indexes grow rapidly after a rebuild unless data
is inserted in / around the indexed area?
I am searching Tom but I have no satisfactory answers.
PS: To solve the issue, we did rebuild the index after 7 days of now
stop growth and space taken up in the TS now is around 25 % less.
Rgds.
G. Nizar A. Baig
-----Original Message-----
From: arul kumar [mailto:arul76_2000@xxxxxxxxx]
Sent: Tuesday, June 06, 2006 8:43 PM
To: Nizar Ahmed; oracle-l@xxxxxxxxxxxxx
Subject: Re: Rapidly Growing space usage in TS with only two indexes
Nizar,
Are these indexes rebuilt recently?
The indexes may grow rapidly after a index rebuilt! (
u may chk it out "AskTom" for more readings on this!)
Thanks,
Arul Kumar.
--- Nizar Ahmed <gnahmed.c@xxxxxxxxxx> wrote:
>
> Dear All,
>
>
>
> I have a table (partitioned - list) with approx. 500
> million rows.
>
> I have two indexes (partitioned - list) on this
> table in their own
> separate tablespace.
>
>
>
> Size of table is roughly 50GB and sizes of the two
> indexes currently are
>
> 17 GB each.
>
>
>
> For the past 4 days, I have noticed that space is
> consumed in the index
> tablespace at the rate of 1 GB per day.
>
>
>
> This has never happened before and I have been
> racking my head as to the
> reason why this is happening.
>
>
>
> One thing I could think of was a 50: 50 block split
> when new values have
> to be inserted in the index.
>
>
>
> Is there any way I can check this or any other ideas
> why this could be
> happening?
>
>
>
> And is indexes rebuild necessary or warranted here?
>
>
>
> Thanks,
>
>
>
>
>
>
>
> G. Nizar A. Baig
>
>
>
>
>
>
>
> Disclaimer: The information in this email and in any
> files transmitted with it,
> is intended only for the addressee and may contain
> confidential and/or privileged material.
> Access to this email by anyone else is unauthorized.
> If you receive this in error,
> please contact the sender immediately and delete the
> material from any computer.
> If you are not the intended recipient, any
> disclosure, copying, distribution or
> any action taken or omitted to be taken in reliance
> on it, is strictly prohibited.
> Statement and opinions expressed in this e-mail are
> those of the sender, and do not
> necessarily reflect those of STC.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Disclaimer: The information in this email and in any files transmitted with it,
is intended only for the addressee and may contain confidential and/or
privileged material.
Access to this email by anyone else is unauthorized. If you receive this in
error,
please contact the sender immediately and delete the material from any computer.
If you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in reliance on it, is strictly
prohibited.
Statement and opinions expressed in this e-mail are those of the sender, and do
not
necessarily reflect those of STC.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
