Each report generation takes a few hours in Oracle 11g R2 and a few tens of reports has to be generated every day.
To reduce report generation time
a) "reports that used to take hours can now be executed in seconds using oracle in-memory database feature". (Reference: https://blogs.oracle.com/database/oracle-database-18c-%3a-now-available-on-the-oracle-cloud-and-oracle-engineered-systems?elq_mid=104407&sh=26961462026142651578242315&cmid=WWMK170418P00047)
b) The feature is introduced in Oracle 12c and is available in its later versions.
Please advise on:
a) how in-memory/cache table feature of 11g and database in-memory of 12c are related? former one can be used to improve report generation performance?
b) Procedure to enable the in-memory database feature in Oracle 11g R2?
c) Procedure to make standby database of 11g to 12c?