truncate has execessive row cache wait
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Thu, 18 Sep 2008 22:32:49 -0400
Message-ID: <f30139790809181932g69e4ac08obb4e396b6bf26d5c@mail.gmail.com>
Date: Thu, 18 Sep 2008 22:32:49 -0400
Message-ID: <f30139790809181932g69e4ac08obb4e396b6bf26d5c@mail.gmail.com>
well it was a truncate table drop storage.
is that a known result of running a truncate with the "drop storage" option ?
took 15 minutes to do a simple truncate on a 2.4 GB table. 1 mb extent
sizes. not alot going on.
was waiting on row cache wait ?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 18 2008 - 21:32:49 CDT