-
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?
-
-
Re: space used by the database
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
-
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?
-
Originally posted by slimdave
WTF is this?
Sounds like he and a couple of big "friends" are going to duff you up.
-
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!
-
-
Originally posted by theworm
No friends needed
Heh heh heh. A true professional.
-
Database space.....
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|