problem in tablespaces size

[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.

[Former Member · Accepted solution]

vasu,

If autoextened is on then there is no problem with size,

Better way is to add datafiles so that it will reduce the tablespace size,

Hope this help.

Regards,

Rajesh

[Former Member · Accepted solution]

hi rajesh

atuextend is on to the all tablespaces but problem is why defaultly came with 99% use after installation

[Former Member · Accepted solution]

vasu,

Have you run SGEN after installation? as it compile and regenerates all the screens & programs and occupies the most of the tablespace size.

Your tablespace size is normal, just add datafiles.

Regards,

Rajesh