Listing cache policy details for the database

Use this procedure to list caching policies for the specified database object, including a datafile, partition or tablespace.

To list caching policies for the database