Re: HELP ! ! ! temp tablespace

Check the waits:

if you waits on 'rdbms ipc reply' it means that the process doing the drop is asking the DBWR to flush all the buffers in that extent DBA range to disk.
if you see waits on 'log ' related events, you most likely waiting on some form of checkpointing, although the amount of redo generated will increase with the number of extents that you drop (used -> free).

Anjo.

Jonathan Lewis wrote:

> Another option is to increase the size of the
> redo log files dramatically to reduce the number
> of logswitches and checkpoints - although if you
> try Kyle's trick this may not make much difference.
>
> (I think the extent-based checkpoint disappeared
> late in 7.3.4, Kyle, but I'm not sure about that;
> it certainly went by 8.0).
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> kyle hailey wrote in message ...
> >To speed up the process you could try reducing your
> >
> > db_block_buffers
> >
> >to as small as you can to get the database open, 100 or so. At least
> >in v7 this made a huge difference in dropping tons of extents because
> >alot of the work had to do with verifying blocks that were in the
> >buffer cache against the extents being dropped.
> >
> >Kyle Hailey
> >
Received on Sun Feb 25 2001 - 06:18:02 CST