公路甩挂运输试点专项资金管理暂行 ...ppt

LOB Internals Julian Dyke Independent Consultant Objectives Understand how LOBs use storage in the Oracle database Consider options to optimize LOB performance in terms of: Reads Writes Impact on physical I/O Impact on buffer cache Agenda Basic FilesOverview Introduced in Oracle 8.0 Known as Basic Files in Oracle 11.1 and above Intended to replace LONG columns Can be used to store large blocks of unstructured data e.g.: text graphics video clips sound waveforms XML documents Can store either character or binary data Can be stored within database (internal) outside database (external)