Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table move
1.2 GB is not that much. If you estimate your subsystem IO speed with 10 MB/s
read and 2 MB/s write performance you should be able to finish within 615 s or
about 11 min.
Please consider the following:
Martin
Krzysztof Kryczka wrote:
>
> ok - if you want detail you can have it:
> handware Dell PowerEdge6400
> OS is Win2000AS
> large for me is:
> sum(bytes) from dba_extents is about 1.2G
> sum(blocks) from dba_extents is about 7000
> any more details?
>
> i have about 4 tables like that and have to reorganize their storage online
>
> > "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
> > news:3CC47F8D.CA549024_at_exesolutions.com...
> > > What hardware?
> > > What operating system?
> > > What version of Oracle?
> > > What is 'large'?
> > >
> > > The group's crystal ball is broken today.
> > >
> > > Daniel Morgan
> > >
> > And tomorrow and the day after tomorrow.
> > It might be repaired after a coca cola refill, but then again it will shut
> > itself down at the first FAQ
> >
> > ROFL
> >
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
Received on Tue Apr 30 2002 - 10:23:54 CDT