Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pages to Module

2990225Feb 4 2019

I need to know if there is away to find all pages associated with a module. For example, If I knew the pages associated with the Accounts Payable module, I can run a query to bring up all the Roles or Permission List we associated with AP. Although our roles are mostly named to associate with the module, there are cases with Permission List which cross over modules within a role.. 

I would need to know where I can find this module association, if applicable.

Comments

Prabodh
Answer
Hi Jan,
I'm wondering what exactly is apex.jdbc.MaxStatementsLimit parameter for and if/how the value should be adjusted.
Documentation says only: Specify the maximum number of statements to cache for each connection. Default = 10>

These are JDBC parameters detailed here http://docs.oracle.com/cd/B19306_01/java.102/b14355/concache.htm#CDEBCBJC

You may change the Max numbers to higher values, but do not reduce them. These have a impact on the memory used, and may not necessarily result in improved performance. You may need to find the right set with some trial and error.

Cheers,
Marked as Answer by jan.navratil · Sep 27 2020
1 - 1

Post Details

Added on Feb 4 2019
#advanced-queueing, #database-key-features
0 comments
112 views