truncate has execessive row cache wait

  • From: "Dba DBA" <oracledbaquestions@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 18 Sep 2008 22:32:49 -0400

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 ?

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2008