Create a Ram Disk in Exalytics (LINUX)

So you have all your data in memory, how can you make it even faster. You can create what you call a RAM Disk, this is when you have allocated part of the memory to be used as a file system, then configure BI to use the ram filesystem for caching. 1. Check the amount you have free ram you have left on your machine, by using the command free –g, you can see we have 1tb ram. 2. Create a folder to use as a mount point for your RAM disk. mkdir /mnt/ramdisk 3. Add the following into the /etc/fstab file in the size add the size you want, we are using 1g: tmpfs /mnt/ramdisk tmpfs nodev,nosuid,noexec,nodiratime,size=1024M 0 0 4. Enter the following to mount it : mount /mnt/ramdisk 5. To check all mounted df-k 6. On the BI Server edit the NQSConfig.INI 7. Update the DATA_STORAGE_PATHS as below, don’t update anything else. [CACHE] ENABLE = YES; # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control # A comma separated list of pair(s). # These are relative to the process instance directory. # e.g. DATA_STORAGE_PATHS = "nQSCache" 500 MB; # resolves to # $(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/nQSCache #DATA_STORAGE_PATHS = "cache" 500 MB; DATA_STORAGE_PATHS = "/mnt/ramdisk" 500 MB; 8. Lets set up OBIEE to use ramdisk for the presentation cache by doing the following in the OBIEE 11g EM console: FMW Control > Business Intelligence > CoreApplication > Capacity Management tab 9. Then click the Performance tab, tick ‘cache enabled’ under ‘Enable BI Server Cache’ 10. Restart the BI Services. Next time I will show you how to automatically clear the cache.
Posted in Blog

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)