Newbie question, on reindexing tables

Hi,

I am new at Oracle so please forgive me if I ask a silly question;-)

OK, the vendor of our application who uses an Oracle database has told me to reindex two

tables in his database.

If I look in Oracle storage manager I see that only one tablespace is near it's capacity,

the SYSTEM tablespace is at 58.777 of 60.000 MB, which surprises me, we use the DB for about

two months, but not thast heavy, but OK.

My first question is:I have been told that I need to rebuild two tables but how do I know in

what tablespace they are? And if I know the tablespace, can I safely give the command ALTER

INDEX tablespace_name REBUILD?
The db is backup up daily.

Then, when I do this query (see query 1 in below post) it seems to indicate that there is plenty of space.

Also, is it normal you have to weekly rebuild the index on heavily used tables?
And if yes, how do I do that?

On the disk itself we have plenty of space.

If I run the following query (see query 2 in below post)

That shows me the extends should be set OK, correct? So it cannot be a space issue, am I correct?

Anything else I should look at?
I also have been told I should set up a job to monitor the statistics, that should also

automatically tell me when I run out of space, or where I start to run into issues, is this

true?
And if yes, where can I find some documentation how to do this? Is there a good website, I find some stuff at Oracle but it is all fairly complicated, I
will get there eventually but for now, any good tips?

And is there a way to create an ERD schema for the database (only 75 tables) for my own reference?

Thanks a million, and again, sorry if it is a silly Q.

Eduard de Vries

info_at_edrox.demon.nl Received on Thu Dec 06 2001 - 17:42:16 CST