-
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
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|