Posts Tagged ‘CACHE MANAGEMENT DATABASE TABLES in Fatwire / Oracle WebCenter Sites’

In an article written by me, a long time back, we have seen the information about various content server tables.

Now, for the next upcoming few articles, I’m going to share the detailed information about these tables.

In this article, we will see about the CACHE MANAGEMENT DATABASE TABLES in Fatwire / Oracle WebCenter Sites.

CacheManager manages these tables:

We already know about the CacheManager (the Page Caching Utility), and how it operates the CS Cache and SS Cache.

As the cache manager keeps track of the information about the PAGES that need to be cached, and the ASSETS that are referred by these CACHED PAGES, the CacheManager makes use of a few DataBase tables. They are as follows:

  • SystemPageCache
  • SystemItemCache

As and when the pages expire, or when the assets referred by these pages are modified, the CacheManager Adds / Removes the Pages / Assets to the tables specified above.

SystemPageCache Table:  When ever a new page is to be added to the cache, a new ROW is created in this table, by the CacheManager. Hence, ONE ROW FOR ONE PAGE. When the page expires, its corresponding row is removed from the table. Hence, depending on the pages in the cache, this table expands / contracts accordingly.

SystemItemCache Table:   We know that the page refers to other assets like images, pagelets, blobs, etc. For storing the information about those items which are referred by the CACHED PAGES, this table is used. Here also, the formula is same. ONE ROW FOR ONE ASSET. Depending on the assets referred by the cached pages, this table also expands / contracts accordingly.

For example, if a Page (Cached Page) is created from a page Asset that has associations to four article assets, there would be five rows for that cached page (One row for PAGE ASSET, and Four rows for Article assets), in the SystemItemCache table.

To view the content of these tables, just open the CS-EXPLORER, enter your log-in details. Expand the TABLES directory. You will be able to see the above stated tables, and their contents. Refer the below screen shot.


We will see the other Content Server Database tables in my upcoming articles.

Stay tuned….