Re: Too slow to delete a long raw table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Dec 1999 10:32:52 -0000
Message-ID: <944131054.1590.0.nnrp-03.9e984b29@news.demon.co.uk>

make sure that timed_statistics = true

start a session to do this,
find the sid,do the delete,
then report from v$session_wait
for that session. Send us the
output. have a look, in particular
at the redo synch times.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Éric Dantie wrote in message <38463687.0_at_news.ll.iac.es>...
>I'm working with Oracle8.1.5 on solaris sparc.
>To delete a row of a table with a long raw column, it takes half a minute.
>The long raw data is no more than 1Mb!
>
>So I've tried to update the long raw data to null before deleting it, but
>it's the update which is so long...
>
Received on Thu Dec 02 1999 - 04:32:52 CST