July 2015 archive

Oracle ACFS files systems are typically configured for clusterwide access. File systems, files, and directories are visible and accessible from all cluster members and can be referenced by users and applications using the same path names from any cluster member. This is a good way to also implement a unique Oracle Database Home shared in …

Continue reading

An ASM instance is automatically created when you configure a fresh grid infrastructure. In this topic, what I understand is that you need to practice the following items: Alter the ASM parameters (like initially automounted DGs / power limit / diag / etc) Change the spfile place by using spset / spcopy inside "asmcmd" tool. Start …

Continue reading

So, finally here we start the grid control! I won't teach you here how to install grid control as you can find 266k results in less than 0.5 seconds using Google. There are several ways of doing so and you must be prepared to perform all of them: runInstaller using GUI (preferable). runInstaller using CLI …

Continue reading

I've never heard about this expression "instance caging" until I came across this topic. So, I made a quickly search in the official documentation and it was a single page to explain everything. Fast to learn. "Instance caging is a method that uses an initialization parameter to limit the number of CPUs that an instance can …

Continue reading

SQL Plan Management is a new feature introduced with Oracle DB 11g that enables the system to automatically control SQL plan evolution by maintaining SQL plan baselines. With this enabled, a newly generated SQL plan can integrate a SQL plan baseline only if it has been proven that doing so will not result in performance regression. During …

Continue reading