Re: Importing several users

From: Lío <jgonzalezsuareNO_at_SPAMnexo.es>
Date: 2000/03/22
Message-ID: <epugdsk5j566cc9f07mr8jisgvgrkjtd1j@4ax.com>#1/1

Thanks for all.
The import process succeed, but I've got one more question. As my old database was quite fragmented (lots of rows in the user_free_space view), is it suposed that, after the import the fragmentation has dissappeared?
I mean, this query:
SELECT TABLESPACE_NAME, SUM(BYTES), MAX(BYTES), COUNT(*), AVG(BYTES)

        FROM USER_FREE_SPACE
        GROUP BY TABLESPACE_NAME

now returns me only one or two pieces per tablespace, what seems to be very good, but I'm not sure that this query is the good way to determine the fragmentation rate.

What I want to know is if there is any post-import task I can do to optimize my database performance.

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)

Received on Wed Mar 22 2000 - 00:00:00 CST