want to understand the sys_cache_flush table

[Priyanka Pawar]

Hello Team,

I am trying to understand the sys_cache_flush table, how to read this table.
I do see catalog, Key, Sequence, system ID different columns there but not able to read what kind of information this table do provide us.
I only get that it is recording the all the flushes which has been done in the instance, but how to read this table correctly, what these deferent columns stands for?

Regards,
Priyanka Pawar

[Community Alums]

Hi @Priyanka Pawar ,

Let's understand the basic use of this table, 

To Flush the ServiceNow cache memory just like you do for your browser we use cache flush.

When you face issue with the UI display.taking too much time to load or if you have done some changes but it is not reflecting in your form.

You can flush the cache by typing cache.do in the navigation for filter.

When? When things don't seem to be going right   and you can verify you did everything right.   Avoid doing this in production instances as it may impact performance as people rebuild items in the cache.

It is not added in OOB Module .If you want ,you can create a Module which will open sys_properties Table.

Open "Modules" from left navigation. Click on create new.

Select the table as sys_propeties. Add modules in a application like in System Definition.

If you want to create a New application then your can create a application then add this module in with that application.

Also, read this blog : https://www.servicenow.com/community/now-platform-blog/you-don-t-always-need-to-clear-the-cache/ba-p...

[Kristen Ankeny]

This will also provide context for sys_cache_flush and diagnosing reasons for cache flushes: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0755182

[jaheerhattiwale]

@Priyanka Pawar Just for understanding the cache flush i have one example:

Some times even after adding the new fields to the form layout those fields does not reflect on the form because of the cache.

If we flush the cache then the system will show the newly added fields properly.

Please mark as helpful if this has helped you