SYSTEM TABLESPACE

[Former Member]

Dear all

I want to ask about one of my tablespace named SYSTEM.

Usually the used percentage is 99%, but today it decrease to 97%

I never extend that tablespace..

How is it happen??

Thanks

[Former Member · Accepted solution]

Hi,

Check if there is there a autoextend on?

[http://www.oracle.com/technology/oramag/code/tips2003/083103.html]

Manoj

[Former Member · Accepted solution]

hi Manoj, thanks for your reply

I can't run the script from the link you gave buat I've chek on DB02, the autoextend set to YES

but my question is "why the size increasing now?" I always monitor the free space from day to day.

Is there any background job related to that tablespace??? in what condition the tablespace size can increase automatically expect from autoextend?

I think I didn't create new background job

[Former Member · Accepted solution]

Has the ts really grown? Or is there just 2% more free space? In the history in DB02 you can see that.

I've never seen that but must admit i never paid attention to it. May be some 'reorg-job' has deleted some old data in the ts. I'd post the question in the oracle forum gere on sdn.

97% is still pretty much

Regards,

ulf

[Former Member · Accepted solution]

Hi Ulf,

the tablespace is really grow up for about 20MB, so the used percentage decreased to 97%

Here is the screen shoot :

Scale: Day Size (Kbyte) Free(Kbyte) Used (Kbyte) %-Used

Date Total Delta Total Total Delta Total Delta

11.03.2009 921.600 0 20.800 900.800 0 97

10.03.2009 921.600 0 20.800 900.800 0 97

09.03.2009 921.600 0 20.800 900.800 0 97

08.03.2009 921.600 20.480 20.800 900.800 1.024 97

07.03.2009 901.120 0 1.344 899.776 0 99

06.03.2009 901.120 0 1.344 899.776 0 99

05.03.2009 901.120 0 1.344 899.776 0 99

04.03.2009 901.120 0 1.344 899.776 0 99

03.03.2009 901.120 0 1.344 899.776 0 99

02.03.2009 901.120 0 1.344 899.776 0 99

01.03.2009 901.120 0 1.344 899.776 0 99

28.02.2009 901.120 0 1.344 899.776 0 99

27.02.2009 901.120 0 1.344 899.776 0 99

26.02.2009 901.120 0 1.344 899.776 0 99

Thanks for posting my question to oracle forum :")

[Former Member · Accepted solution]

Hi Rosa

> Thanks for posting my question to oracle forum

I meant i 'would' post the question there, not i 'did' ;-). That wouldn't make much sense, cause all upcoming questions could only be answered by you.

But at least, Manoj answered your question already, autoextend is active and on (edit:) 8.3. some more space was needed and so the ts was extended automatically.

Edited by: Ulf Brinkmeier on Mar 11, 2009 11:54 AM

[Former Member · Accepted solution]

Rosa,

11.03.2009 921.600 0 20.800 900.800 0 97
10.03.2009 921.600 0 20.800 900.800 0 97
09.03.2009 921.600 0 20.800 900.800 0 97
08.03.2009 921.600 20.480 20.800 900.800 1.024 97

Hope this answer's your question.

Manoj

[Former Member · Accepted solution]

Oic......

Now I understand :'D

Thanks a lot Ulf and Manoj

Regards,

Della