Re: HELP ! ! ! temp tablespace

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 24 Feb 2001 08:10:07 -0000
Message-ID: <983001984.5699.0.nnrp-02.9e984b29@news.demon.co.uk>

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 Sat Feb 24 2001 - 02:10:07 CST