Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitoring Used (%) space for tablespaces

653744Sep 22 2008 — edited Sep 24 2008

Hi everyone,

I am currently using:
Redhat Linux ES 5 2.6.18 and also
Oracle 10g Release 2 for Linux x86 R10.2.0.3

While monitoring my Tablespaces using OEM Database Control, I notice that two tablespaces were almost full.

[SYSAUX] - Size: 290MB , Used 283MB (97% full)
[SYSTEM] - Size: 320MB, Used 313MB (98% full)

When I try to locate the datafiles of both tablespaces in its directory (/home/dba/oracle/oradata/oracle), it shows the allocated size (290MB for sysaux01.dbf & 320MB for system01.dbf) and not the used space.

I got three questions to ask over here:

1st- Why there isn't any warnings or alarms even though the tablespaces exceeds the critical size?
2nd- How come the datafiles shows the allocated size of the tablespaces and not the Used space?]
3rd- How can I find & monitor the actual used space of the tablespaces?
4th- I have enabled the AutoExtend function but I am worry whether is there any other concern?

I am still very new here.
Please pardon me for anything that is improper.
Looking forward for your expertise, guidance & help.
Thanks for your attention.

-Regards-

++ Kef Lim ++

This post has been answered by NavneetU on Sep 22 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2008

Added on Sep 22 2008

#general-database-discussions, #oracle, #performance

5 comments

4,495 views