DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: tablespace growth and freespace

  1. 09-19-2006, 04:45 PM #1
    cabruntz
    cabruntz is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 09-19-2006, 04:49 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    Reply With Quote Reply With Quote
  3. 09-19-2006, 04:58 PM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
    Reply With Quote Reply With Quote
  4. 09-19-2006, 07:20 PM #4
    yxez
    yxez is offline Advisor
    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
    Reply With Quote Reply With Quote
  5. 09-20-2006, 04:35 AM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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