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?
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.
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
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
Rick
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
Reply With Quote
Bookmarks