Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A tablespace with 400,000 free extents
Hi Vsevolod,
IF you are not planning to effectively reuse all these extents in the nearish future and IF you only have a few tables AND assuming it's a dictionary managed tablespace, I would recommend:
You've got to keep yourself busy somehow :)
Good Luck
Richard
"Vsevolod Afanassiev" <vafanassiev_at_aapt.com.au> wrote in message
news:4f7d504c.0207200257.ef5396b_at_posting.google.com...
> I "inherited" a database that has about 400,000 free extents in users
> tablespace. It works just fine, but all queries that display
> space are very slow.
>
> My first idea was to coalesce it (ALTER TABLEPACE users COALESCE).
> Unfortunately, this database has a daily batch job the involves
> plugging in some tablespaces (using IMP utility). For some strange
> reasons, IMP was "stuck" when coalesce was running, so I had to kill
> coalesce.
>
> I am thinking about moving all tables (just a few) from this tablespace
> and then using ALTER DATABASE <name> DATAFILE OFFLINE DROP.
> Any suggestions?
>
> Thanks
>
> (Database - 8.1.6.3.0 on Sun Solaris 2.8)
Received on Sat Jul 20 2002 - 09:11:26 CDT