Displays information about the specified cache. For example:

    SQL> SHOW CACHE
    Cache Objects in database with filename sample
            CACHE1
            CACHE2
    SQL> SHOW CACHE cache1

         CACHE1
            Cache Size:            1000 rows
            Row Length:            256 bytes
            Row Replacement:       Enabled
            Shared Memory:         Process
            Large Memory:          Disabled
            Window Count:          100
            Reserved Rows:         20
            Sweep Rows:            3000
            No Sweep Thresholds
            Allocation:            100 blocks
            Extent:                100 blocks