space used by the database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: space used by the database

  1. #1
    Join Date
    Jan 2002
    Posts
    38

    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?

  2. #2
    Join Date
    May 2001
    Posts
    73
    Check dba_free_space
    OCP 7.3,8.0,8i,9i

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jan 2002
    Posts
    38
    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

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by slimdave
    WTF is this?
    Sounds like he and a couple of big "friends" are going to duff you up.

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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!
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Jan 2002
    Posts
    38
    No friends needed

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by theworm
    No friends needed
    Heh heh heh. A true professional.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    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
  •  



Click Here to Expand Forum to Full Width