(Scott Wesley) If you’re using dynamic SQL to source your menus and you’re utilising the apex_application_pages dictionary view to build you list of menu options – I suggest you consider using Materialized Views.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help