Last-access time
The last-access time of a smart large object is the system time at which the database server last read or wrote to the smart large object. The last-access time records access to the user data and metadata of a smart large object. The database server stores this system time as number of seconds since January 1, 1970, in the metadata area of the sbspace.
Tip: The database server automatically tracks the last-change
and last-modification time for a smart large object in the status
information.
By default, the database server does not save the last access time.
You can choose to track the last-access time for a smart large object
as part of its storage characteristics.
Important: Consider
carefully whether to track last-access time for a smart large object.
To maintain last-access times for smart large objects, the database
server incurs considerable overhead in logging and concurrency.