[9631] in SAPr3-news

home help back first fref pref prev next nref lref last post

Re: How to be sure that a reorg is needed on an SAP Oracle database?

daemon@ATHENA.MIT.EDU (Pete)
Thu Jan 21 00:47:27 1999

To: sapr3-news@MIT.EDU
Date: Thu, 21 Jan 1999 00:35:26 -0500
From: Pete <pete@troll_fishing.org>
Reply-To: pete@troll_fishing.org

Have you deleted a lot of data, and need the space back ? Are your tables to
fragmented (many tables with 100 or more extents) ? dbspaces too fragmented
? Want to move high load tables to separate dbspaces ?

Then it's reorg time ! <g>

Pete

journel@videotron.ca wrote:

> Is there a way or a cookbook to be sure that a reorg is needed on an SAP
> Oracle database?
>
> Thanks in advance,
>
> Pierre.




home help back first fref pref prev next nref lref last post