RE: Rapidly Growing space usage in TS with only two indexes

Nope. These are not BM's

G. Nizar A. Baig, B.E., O.C.P.,

Senior Database Administrator,

Technical Support Department - Data Center,

Saudi Telecommunications Company

*: +966 1

*: +966 505485605

*: gnahmed.c_at_stc.com.sa <mailto:gnahmed.c_at_stc.com.sa>

*

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arul Ramachandran Sent: Tuesday, June 06, 2006 8:35 PM
To: Nizar Ahmed
Cc: oracle-l_at_freelists.org
Subject: Re: Rapidly Growing space usage in TS with only two indexes

Are these bitmap indexes? Bitmap indexes with lots of table updates would cause something like this.

If not, then checking statspack report is warranted.

Regards,

Arul

On 6/5/06, Nizar Ahmed <gnahmed.c_at_stc.com.sa> 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.

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.

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