Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: truncate command internal behavior
>>>Third, a bit of curiosity: Does the time to truncate vary
...hoping JL will comment, but I can recall from experience that in 8i (can't remember if R1,R2 or R3), a VLM size SGA would take forever to truncate a table as the server process had to walk all the chains to invalidate the buffers ... that smoked a single CPU for a long time on a large SGA....
I routinely use 20+ GB SGAs and have not seen that in 9i or 10g.
FWIW
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 17 2006 - 16:06:49 CDT
![]() |
![]() |