more size of table spaces after installion

[Former Member]

hi gurus

i installed ecc 6.0 with oracle 10g after installation i checked tablespaces but these are like this

psapsr3 -80%(used)

psapsr3700-99%(used)

system-97%(used)

sysaux-93%

but according to threshold values max allowed upto 80% why it is showing above 95%

what can i do for this. is there any problem in feature for this tablespaces.

[debasissahoo · Accepted solution]

Hi Vasu

but according to threshold values max allowed upto 80% why it is showing above 95%

Question is not very clear.. but if your question is how to rectify or what action to be taken, then,

please note that if the auto extend option is ON, then you need to take the 2nd %age shown in DB02 into consideration which takes autoext option into account.

If after autoext the %used size is close to 90, or auto ext option is OFF, then you've to increase the table space size by

- maintaining autoextend size

- adding datafile

- resizing datafile

all of these can be done in brtools.

Regards,

Debasis.