Oracle has added JSON support from 12.1.0.2. At various locations, e.g. Oracle XML DB Developer's Guide, JSON Developer's Guide, Oracle recommends "whenever you store JSON data in a BLOB or CLOB column you turn on the LOB cache option for that column. This option is turned off by default." So if a column of a … Continue reading Buffer Cache Usage for a lob segment if cached →