tablespace growth and freespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: tablespace growth and freespace

  1. #1
    Join Date
    Apr 2006
    Posts
    1

    tablespace growth and freespace

    We have an 8i database. This is a third party setup so I don't have a lot of control. One of the schemas is a 37GB now. I cannot find a answer to this question. If I delete rows from one table in the schema, is the freed up space available for all tables in the schema or just the table where the rows are deleted?
    I do run the ALTER TABLESPACE "" COALESCE after the deletes.

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Quote Originally Posted by cabruntz
    We have an 8i database. This is a third party setup so I don't have a lot of control. One of the schemas is a 37GB now. I cannot find a answer to this question. If I delete rows from one table in the schema, is the freed up space available for all tables in the schema or just the table where the rows are deleted?
    I do run the ALTER TABLESPACE "" COALESCE after the deletes.

    thanks
    What do you think ALTER TABLESPACE "" COALESCE does?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    If I delete rows from one table in the schema, is the freed up space available for all tables in the schema or just the table where the rows are deleted?
    The freed space is available to the table in which the row was deleted. It will not be available to other table/index.

    You need to study how pctfree and pctused parameters work in Oracle blocks.

    Tamil

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    wow, i really find guys cute, who ask questions like this. looks so
    innocent, its like i want to teach him some lessons (oracle dba at least)

    Cab, what u really be concerned of is your FREESPACE if you
    think it falls on the treshold then add more, anyways disks are
    cheap now adays. At least its a control u got on this
    application/database. But still, deleting unwanted rows works
    fine for the table itself.
    Last edited by yxez; 09-19-2006 at 07:26 PM.
    Behind The Success And Failure Of A Man Is A Woman

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by yxez
    wow, i really find guys cute, who ask questions like this. looks so
    innocent, its like i want to teach him some lessons (oracle dba at least)

    Cab, what u really be concerned of is your FREESPACE if you
    think it falls on the treshold then add more, anyways disks are
    cheap now adays. At least its a control u got on this
    application/database. But still, deleting unwanted rows works
    fine for the table itself.
    you have a real nack of not answering the question asked at all

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