While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.(a) Set the PRE_PAGE_SGA parameter to TRUE(b) Set the LOCK_SGA initialization parameter to TRUE(c) Implement Automatic Shared Memory Management(d) Set the SGA_TARGET initialization parameter to zeroThe question was posed to me in exam.Asked question is from Installing Oracle Database 11g and Creating a Database topic in chapter Oracle Database 11g Architecture Options of Oracle

While the database instance is up and running, you receive an out-of-m

1.	While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.(a) Set the PRE_PAGE_SGA parameter to TRUE(b) Set the LOCK_SGA initialization parameter to TRUE(c) Implement Automatic Shared Memory Management(d) Set the SGA_TARGET initialization parameter to zeroThe question was posed to me in exam.Asked question is from Installing Oracle Database 11g and Creating a Database topic in chapter Oracle Database 11g Architecture Options of Oracle
Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> choice is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) Implement Automatic Shared Memory Management<br/><br/>For explanation: Cause: More shared memory is needed than was allocated in the shared pool.Action : If the shared pool is out of memory, either use the DBMS_shared_pool package to pin large packages, reduce your use of shared memory, or increase the <a href="https://interviewquestions.tuteehub.com/tag/amount-374803" style="font-weight:bold;" target="_blank" title="Click to know more about AMOUNT">AMOUNT</a> of available shared memory by increasing the <a href="https://interviewquestions.tuteehub.com/tag/value-1442530" style="font-weight:bold;" target="_blank" title="Click to know more about VALUE">VALUE</a> of the INIT.ORA <a href="https://interviewquestions.tuteehub.com/tag/parameters-11881" style="font-weight:bold;" target="_blank" title="Click to know more about PARAMETERS">PARAMETERS</a></body></html>

Discussion

No Comment Found

Related InterviewSolutions

While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.(a) Set the PRE_PAGE_SGA parameter to TRUE(b) Set the LOCK_SGA initialization parameter to TRUE(c) Implement Automatic Shared Memory Management(d) Set the SGA_TARGET initialization parameter to zeroThe question was posed to me in exam.Asked question is from Installing Oracle Database 11g and Creating a Database topic in chapter Oracle Database 11g Architecture Options of Oracle
You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.(a) Set the TRACE_ENABLED parameter to TRUE(b) Set the threshold for the Current Logons Count metric(c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE(d) Set the SESSIONS_PER_USER limit in the profiles used by usersThis question was addressed to me in quiz.My query is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle
You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?(a) Increase the size of the redo log files(b) Decrease the number of redo log members(c) Set LOG_CHECKPOINT_TO_ALERT to TRUE(d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameterThe question was asked by my school teacher while I was bunking the class.This key question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle
Which operations can be performed using the Data Recovery Ad-visor?(a) Diagnosing data failure(b) It is a percentage of rows in which the statistics are collected incrementally for partitions(c) Presenting appropriate repair options(d) Generating reports for possible causes of failureThe question was asked during an interview.Question is from Installing Oracle Database 11g and Creating a Database in portion Oracle Database 11g Architecture Options of Oracle
Which statement is correct regarding undo management?(a) The database can have more than one undo tablespaces(b) The undo data must be purged manually when the transaction is over(c) The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF(d) Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULLI had been asked this question at a job interview.Asked question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle
What SYSTEM VARIABLE is used to refer DATABASE TIME ?(a) $$dbtime$$(b) $$time$$(c) $$datetime$$(d) None of the MentionedThis question was posed to me in an interview.The origin of the question is Installing Oracle Database 11g and Creating a Database in chapter Oracle Database 11g Architecture Options of Oracle
Oracle server configuration is dedicated for(a) One server process – Many user processes(b) Many server processes – One user process(c) One server process – One user process(d) Many server processes – Many user processesThis question was addressed to me in an interview.This interesting question is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle
What is the result of the following‘PAN’NULL’KAJ’?(a) Error(b) PAN KAJ(c) PANKAJ(d) NULLThe question was asked in exam.My question is from Programmatic Oracle Structures in division Oracle Database 11g Architecture Options of Oracle
Which of the following statement is false ?(a) Any procedure can raise a error and return an user message and error number(b) Error number is ranging from 20000 to 20999 are reserved for user defined messages(c) Oracle checks Uniqueness of User defined errors(d) Raise_Application_error is used for raising an user defined errorThis question was posed to me in final exam.The doubt is from Programmatic Oracle Structures in section Oracle Database 11g Architecture Options of Oracle
What is SQL * FORMS ?(a) SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application(b) SQL * FORMS is a 3GL tool for connecting to a Database(c) SQL * FORMS is a reporting tool(d) None of the MentionedThis question was addressed to me during an internship interview.My doubt stems from Programmatic Oracle Structures in division Oracle Database 11g Architecture Options of Oracle

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment