Skip to main content
Question

Database parameter container_data

  • September 23, 2026
  • 1 reply
  • 6 views

Forum|alt.badge.img+4

We have run into a performance issue where IFS code queries USER_VIEWS (SELECT view_name
      FROM   user_views
      WHERE  view_name = view_name_)

In a test environment we have changed database parameter container_data from the default ALL to CURRENT_DICTIONARY and that makes a huge difference and solves the performance issue.

I have not found anything about IFS Applications and this parameter and it looks safe to change also in production.

Anyone with experience about this parameter, things to consider before changing?

1 reply

Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • September 23, 2026

We are currently running IFS Cloud 24.2.14, Oracle 19c (19.32.0.0.0)