abnormal growth of tablespace

[Former Member]

Hi all,

How to know the growth of a tablespace of last one hour.

Exp:while monitoring a particular filesystem it showed me 48.896 and i updated that.

After 10 min when my lead is checking 48.696,he is saying that there cant be 200MB growth in 10 min.

How to find out.........plz

[markus_doehr2]

You need to give more information before someone will be able to help you.

- What database version are you using?

- Which table is growing so fast?

- Do you use ASSM on that tablespace?

--

Markus

[Former Member]

Hi,

We are using oracle 9.2 and it is BW 3.5 server.

in RZ20 filesystems (e drive)when i updated it is 49.696 after 10 min it is 49.896.

it is a prd server.

My lead says u have entered wrong data, in 10 min there cant be 200 MB growth.

I assure i did not make a mistake.

Please let me know

[markus_doehr2]

Without knowing more about your configuration it's almost impossible to help you.

What's the autoextend size of the tablespaces, that's affected? If this is 200 MB then it's correct, the database increased the space for 200 MB but they are not yet occupied by data.

But without knowing more about your Oracle configuration in detail, it's impossible to dig that down.

--

Markus