AMM

AMM and ASMM derived parameters

By Franck Pachot . The latest DBA Essentials Workshop training I've given raised a question about PGA_AGGREGATE_LIMIT. The default depends on PGA_AGGREGATE_TARGET. So how is it calculated in AMM where PGA_AGGREGATE_TARGET is dynamic? Is it also(…)

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory(…)

Huge Pages and AMM is (not) possible with 11.2.0.2!

Running Linux servers configured with Huge Pages was not always adapted when both 10.2 and 11.2 databases had to be started in parallel. Since 11.2.0.2 this situation changed !(…)