What is the default ASM memory allocation in Oracle 10g, 11g, and 12c?
Since you used the acronym ASM in one of your earlier answers, the interviewer has earned the right to ask you about it. Interviewers will make notes of your answers and the terminology you use and then use this information for subsequent questions. Since few interviews are completely scripted, interviewers use this methodology to navigate through the interview and explore your qualifications.
Every time you answer an interviewer's question, you provide them with the information they can use later in the interview. Knowing this enables you to direct the interview towards areas that you are familiar with and comfortable discussing. Intentionally providing the interviewer with information in your answers will prompt them to ask follow-up questions about topics you are competent in. This is one of the more useful strategies you can implement during an interview.
"The Oracle Automatic Storage System or ASM memory allocation is different for each version of Oracle RAC. In version 10g, the default System Global Area or SGA size is 1G. In 11g, it is set to 256M, and in 12c ASM it is set to 1G, similar to 11g."
