Doubt about table defragmentation
Hello, my friends. I am running 11.70.FC2 on a linux_64 machine. I had to add some chunks, in order to enable my defragment scripts (I am running out of dbspaces). But I noticed one thing: after defragmenting some tables, my recently created chunks were not freed. Is that because: 1) pages were moved from its original location, to the new chunks, because of defrag operations? 2) it was not done an archive zero (yet)? 3) I´ve already tryed to do an "repack + shrink", but nothing changed... I tryed to understand and figure out how the defrag operation runs, internally, ok? Thanks a lot. Best regards.
you can always run an "oncheck -pe" to see what is on each individual =
chunk.
j.
On Aug 23, 2011, at 11:08 AM, ALEXANDRE MARINI wrote:
> Hello, my friends.=20
> I am running 11.70.FC2 on a linux_64 machine.=20
> I had to add some chunks, in order to enable my defragment scripts (I =
am=20
> running out of dbspaces).=20
> But I noticed one thing: after defragmenting some tables, my recently =
created=20
> chunks were not freed. Is that because:=20
> 1) pages were moved from its original location, to the new chunks, =
because of=20
> defrag operations?=20
> 2) it was not done an archive zero (yet)?=20
> 3) I=B4ve already tryed to do an "repack + shrink", but nothing =
changed...=20
>=20
> I tryed to understand and figure out how the defrag operation runs,=20
> internally, ok?=20
>=20
> Thanks a lot.=20
> Best regards.=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20