drop sql execute very slow from 10046 top wait event DFS lock handle
i meet a problem : drop one table very slow ,this table only have 3 rows .drop sql execute is normal but after 10min wait for drop sql complete.below is this 10046 trace.please analyze
KPROF: Release 11.1.0.6.0 - Production on 星期二 5月 21 16:15:07 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Trace file: anadb1_ora_29580_drop.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)