We are on IFSv9 (Oracle 12c) and have yet to utilise the In-Memory functionality. Our database is roughly 500Gb in total size, with 470 global users. We have 300Gb of free RAM on our physical database host waiting to be used.
I would love to know if you have made use of In-Memory. Did you see a measurable improvement on performance within IFS and more importantly if there are known pitfalls I should avoid.
Would love to hear your experience of this feature, good and bad.
Best regards
Mike
Best answer by Srikanth
Hi Mike,
Oracle In-Memory (IM) is a vast topic but let me try my best to add info pertaining to its usage in IFS Applications:
IFS Applications enable users to leverage Oracle In-Memory columnar store introduced in Oracle 12C Enterprise Edition. With In-Memory acceleration, users will be able to run analytical queries against IFS Applications several magnitudes faster than before.
the Oracle parameter inmemory_size controls the total IM allocation for an instance. If this set to 0, then IM is technically disabled for the database.
INMEMORY_QUERY is used to enable or disable in-memory queries for the entire database at the session or system level
Type of queries that will mostly benefits from In-Memory are:
Queries that contain filters, group by, inner joins
Queries that are filtering on non-indexed columns
Queries that scans many rows, and only select few columns and rows
Queries that contain aggregate functions such as MAX, MIN, SUM in their select closure
There are two screens in IFS Apps 9 under In-Memory sub-folder: IM Acceleration Package and IM Acceleration Packages
The In-Memory Acceleration Packages window displays all the In-Memory Acceleration Packages that are installed in IFS Applications. There are few pre-defined packages available out of the box in IFS Apps 9 which aren’t enabled by default.
In the list there is ALL TABLES IN IFS APPLICATIONS which has all the IFS tables. You can RMB to Esitmate Usage or load IM Advisor Lobby for more details.
You must ensure the estimate isn’t > inmemory_size Oracle parameter.
In the In-Memory Acceleration Package window user can view and edit database objects related with a In-Memory Acceleration Package
Example of IM usage in IFS: We are using this feature for couple of clients and they noticed improved performance for example Projects screen where is loads lot of sub-projects with calculations.
Please let me know if you have any additional questions. There is lot of IFS Technical documentation covering this area too.
Oracle In-Memory (IM) is a vast topic but let me try my best to add info pertaining to its usage in IFS Applications:
IFS Applications enable users to leverage Oracle In-Memory columnar store introduced in Oracle 12C Enterprise Edition. With In-Memory acceleration, users will be able to run analytical queries against IFS Applications several magnitudes faster than before.
the Oracle parameter inmemory_size controls the total IM allocation for an instance. If this set to 0, then IM is technically disabled for the database.
INMEMORY_QUERY is used to enable or disable in-memory queries for the entire database at the session or system level
Type of queries that will mostly benefits from In-Memory are:
Queries that contain filters, group by, inner joins
Queries that are filtering on non-indexed columns
Queries that scans many rows, and only select few columns and rows
Queries that contain aggregate functions such as MAX, MIN, SUM in their select closure
There are two screens in IFS Apps 9 under In-Memory sub-folder: IM Acceleration Package and IM Acceleration Packages
The In-Memory Acceleration Packages window displays all the In-Memory Acceleration Packages that are installed in IFS Applications. There are few pre-defined packages available out of the box in IFS Apps 9 which aren’t enabled by default.
In the list there is ALL TABLES IN IFS APPLICATIONS which has all the IFS tables. You can RMB to Esitmate Usage or load IM Advisor Lobby for more details.
You must ensure the estimate isn’t > inmemory_size Oracle parameter.
In the In-Memory Acceleration Package window user can view and edit database objects related with a In-Memory Acceleration Package
Example of IM usage in IFS: We are using this feature for couple of clients and they noticed improved performance for example Projects screen where is loads lot of sub-projects with calculations.
Please let me know if you have any additional questions. There is lot of IFS Technical documentation covering this area too.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
