Skip to main content
Question

Problem with Dictionary Cache

  • December 13, 2021
  • 2 replies
  • 305 views

Ragaventhan Sathananda
Superhero (Partner)
Forum|alt.badge.img+15

When running Refresh Cache the Cache Type “Dictionary” does not appear to be working entirely correctly. 

An example; I checked all Cache Types except Dictionary Cache at 08:09 11/08/2021, 

then checked Cache Type Dictionary at 08:29 on 11/08/2021 and it began running and this popped up, so I left it running

At 11:40 the same screen as above was running, I cancelled the session and then back in the Refresh cache screen this is the view…
 


Dictionary cache refresh is running more than 3 hours and keep running is the problem for the customer and they are on Apps10. Please share any thoughts on resolving this problem.

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+13
  • Hero (Partner)
  • December 13, 2021

Hi,

Dictionary cache can be refreshed from “New Permission Set” window as well as sqlplus/ plsql developer. have you tried those?

 

EXEC DICTIONARY_SYS.REBUILD_DICTIONARY_STORAGE_ (1,'FULL');


Ragaventhan Sathananda
Superhero (Partner)
Forum|alt.badge.img+15

Hi,

Dictionary cache can be refreshed from “New Permission Set” window as well as sqlplus/ plsql developer. have you tried those?

 

EXEC DICTIONARY_SYS.REBUILD_DICTIONARY_STORAGE_ (1,'FULL');

Not yet I will try that and get back