space used by the database

Hello,
We currently run a nightly report that gives us some information about our customers databases. Some of the info is the total amount of space being used by the database. For this number I query on the sys.dba_data_files. We also try to see what tables have a large number of rows. For this I query num_rows from dba_tables. We started to do a large number of deletes from our database. The problem is were not seeing the amount of space being used decreasing. Is there any thing that we need to do to reclaim that space?

Check dba_free_space

Quote:

---

Originally posted by theworm
We started to do a large number of deletes from our database. The problem is were not seeing the amount of space being used decreasing. Is there any thing that we need to do to reclaim that space?

---

The problem is that you have not read the Oracle documentation, and you don't understand how Oracle works.

This is very basic stuff. Go and read the Concepts Guide before your customer figures out that you are not very good at managing oracle databases.

Hey Slim. Thanks for the kind words. Colorado Springs is not that far from my work, what don't we meet in person so I can thank you personally

Quote:

---

Originally posted by theworm
Hey Slim. Thanks for the kind words. Colorado Springs is not that far from my work, what don't we meet in person so I can thank you personally

---

WTF is this?

Quote:

---

Originally posted by slimdave
WTF is this?

---

Sounds like he and a couple of big "friends" are going to duff you up.

Quote:

---

Originally posted by DaPi
Sounds like he and a couple of big "friends" are going to duff you up.

---

Fisticuffs, eh? Meet you behind the bike sheds after school, Wormy!

No friends needed

Quote:

---

Originally posted by theworm
No friends needed

---

Heh heh heh. A true professional.

If my general presumption is correct, factoring in what I perceive the ages to be, I think each rotating, buying the other a round at the local pub would be in order.
This could become quite time consuming and fruitless.

You folks keep me in stitches at time, that and I do get good information here.

Rick