FULL TABLE SCAN and DB FILE SEQUENTIAL READ
Oracle 11.2.0.3.0.
We UPDATE a column of a table to a static value. This table have 442 368 blocks, 237 extents and uses 3456 MB and 0 chained rows. When we trace the execution of this UPDATE statement we have the following trace file:
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Trace file: orcl_ora_1604.trc
Sort options: prsela exeela fchela
********************************************************************************
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)