Log on to the database instance DEMODB.
You can use the system tableCACHE STATISTICS to determine the following database information, among other things:
· Displaying all caches whose hit rate is below 90%
SELECT name, accesscount, hitrate
WHERE hitrate < '90'
· Displaying the caches that show more failed accesses than successful ones
WHERE successfulaccesscount < unsuccessfulaccesscount