Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: slow truncate, "db file parallel write" waits
in-line
PS. I thought of something and checked after my original post: the tablespace where the table resides is ASSM. Maybe that makes a difference.
At 09:19 PM 5/24/2004, zhu chao wrote:
>Hi,
> can you try:
> 1. truncate table xxx reuse storage.
Makes no difference
> 2. use global temporary table if possible.
Not possible
> 3.place this table into a dedicated small tablespace and do truncate
> again.
I don't see where that would make any difference and for the application where the problem occurs that wouldn't be a realistic option, but I'll try it just for curiosity.
>Regards
>Zhu Chao.
regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue May 25 2004 - 05:41:32 CDT
![]() |
![]() |