Hi Lisa,
I worked on a very large database in Mexico City and found that the reuse
statement with existing files took 3 times longer than starting from
scratch. Maybe some of the internals people could shed some light on this
phenom.
- Lisa_Koivu_at_gelco.com wrote:
>
> My large db that I hosed yesterday has 6 properly sized tablespaces -
> ~8GB each.
> We are using Veritas quick i/o on Solaris 2.6, E10000 domain.
> Still, one create tablespace statement, with all 4 2GB datafiles in the
> datafile
> clause with reuse, takes about 15 minutes.
> This is no wimp machine and right now it's at my disposal.
>
> Does creating a tablespace with large datafiles always take this long?
> I'm
> curious what Oracle is doing in the background - is it formatting the
> blocks to
> it's liking? Scanning everything? Any insights are appreciated.
>
> Thanks
> Lisa
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Thu May 25 2000 - 13:21:44 CDT