Valid 1Z0-054 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-054 Exam! ExamDiscuss.com now offer the newest 1Z0-054 exam dumps, the ExamDiscuss.com 1Z0-054 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-054 dumps with Test Engine here:
Access 1Z0-054 Dumps Premium Version
(192 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 159/180
You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings:
MEMORY_MAX_TARGET=600M
SGA_MAX_SIZE=500M
MEMORY_TARGET=600M
OPEN_CURSORS=300
SGA_TARGET=300M
PROCESSES=150
STATASTICS_LEVEL=BASIC
PGA_AGGREGATE_TARGET=0
When you tried to start the database instance with these parameter settings, you received the following error:
SQL> startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
You modified the parameter settings as shown below and the database instance started successfully.
MEMORY_MAX_TARGET=600M
SGA_MAX_SIZE=400M
MEMORY_TARGET=550M
OPEN_CURSORS=400
SGA_TARGET=300M
PROCESSES=200
STATASTICS_LEVEL=TYPICAL
PGA_AGGREGATE_TARGET=100M
Analyze the parameter settings and identify why the instance failed to start the first time?
MEMORY_MAX_TARGET=600M
SGA_MAX_SIZE=500M
MEMORY_TARGET=600M
OPEN_CURSORS=300
SGA_TARGET=300M
PROCESSES=150
STATASTICS_LEVEL=BASIC
PGA_AGGREGATE_TARGET=0
When you tried to start the database instance with these parameter settings, you received the following error:
SQL> startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
You modified the parameter settings as shown below and the database instance started successfully.
MEMORY_MAX_TARGET=600M
SGA_MAX_SIZE=400M
MEMORY_TARGET=550M
OPEN_CURSORS=400
SGA_TARGET=300M
PROCESSES=200
STATASTICS_LEVEL=TYPICAL
PGA_AGGREGATE_TARGET=100M
Analyze the parameter settings and identify why the instance failed to start the first time?
Correct Answer: A
- Question List (180q)
- Question 1: The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID a...
- Question 2: Identify the correct statements about the SYSTEM_MOVING_WIND...
- Question 3: Which statement is correct about server-generated alerts?...
- Question 4: Examine the output of the following query: SQL> SELECT c....
- Question 5: View the Exhibit and examine the result of Automatic SQL Tun...
- Question 6: View the Exhibit.Which statement is true about applying the ...
- Question 7: View the Exhibit and examine the statistics of a SQL stateme...
- Question 8: You work as a DBA for a company and manage an online transac...
- Question 9: You are a DBA in ABC Corp. You are working on an online tran...
- Question 10: You are working on an online transaction processing (OLTP) s...
- Question 11: Identify situations in which collecting statistics at the se...
- Question 12: As a DBA, you notice a change in the performance of your dat...
- Question 13: A user session executes a query and the plan for the query i...
- Question 14: You are managing an online transaction processing (OLTP) app...
- Question 15: View the Exhibit exhibit1 to examine the series of SQL comma...
- Question 16: You enabled tracing for a session by executing the following...
- Question 17: View the Exhibit and examine the content of the V$PGA_TARGET...
- Question 18: View the Exhibit and examine the partial output from the que...
- Question 19: Examine the initialization parameter values for the instance...
- Question 20: You are working as a DBA in ABC Corp. You are working on an ...
- Question 21: You observed in your database that the queries formerly exec...
- Question 22: View the Exhibit and examine the output for the WRC command-...
- Question 23: You query the V$SYSSTAT view and notice a significantly high...
- Question 24: You plan to use adaptive thresholds as part of the performan...
- Question 25: You want to capture the performance statistics during a syst...
- Question 26: You analyze an Automatic Database Diagnostic Monitor (ADDM) ...
- Question 27: Identify the type of recommendation that can automatically b...
- Question 28: You are working on an online transaction processing (OLTP) s...
- Question 29: Your database has the ACCTG service configured for an accoun...
- Question 30: Identify two correct statements about the Active Session His...
- Question 31: Which two statements are true about the database buffer cach...
- Question 32: Examine the SQL statement given below: SQL> EXPLAIN PLAN ...
- Question 33: Your database supports many applications running on the midd...
- Question 34: What indicates that the rate of writing data blocks to the d...
- Question 35: The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to...
- Question 36: Which three statements are true about Statspack usage? (Choo...
- Question 37: What is the purpose of running the statspack.snap script dur...
- Question 38: After an Automatic Database Diagnostic Monitor (ADDM) run, y...
- Question 39: You have the automatic optimizer statistics gathering enable...
- Question 40: A batch workload that historically completed in the maintena...
- Question 41: You created two services HR and FINANCE on a single instance...
- Question 42: You want information in the form of charts for throughput an...
- Question 43: View Exhibit1 to examine the description of the CUSTOMERS ta...
- Question 44: You are working as a DBA for a DSS system, on which applicat...
- Question 45: You upgraded database from the Oracle Database 10g to Oracle...
- Question 46: You work as a database administrator to manage an online tra...
- Question 47: The OS administrator in your company informed you about the ...
- Question 48: After running SQL Performance Analyzer (SPA), you observe a ...
- Question 49: You are working on an online transaction processing (OLTP) s...
- Question 50: You notice that two wait events, Latch:cache buffer chains a...
- Question 51: You are working on a database that was upgraded to Oracle Da...
- Question 52: You are a DBA in ABC Corp. You are working on an online tran...
- Question 53: You queried V$SYSTEM_EVENT in your online transaction proces...
- Question 54: You work for a small manufacturing company as a DBA. The com...
- Question 55: There are 500 users of an online transaction processing (OLT...
- Question 56: You queried V$SYSTEM_EVENT in your online transaction proces...
- Question 57: View the Exhibit and analyze a portion of the Active Session...
- Question 58: View the Exhibit and examine the partial output from the fol...
- Question 59: You are managing an online transaction processing (OLTP) sys...
- Question 60: As a DBA configuring a new instance, you want to run a repre...
- Question 61: View the Exhibit.You want to set the threshold for the numbe...
- Question 62: You work on an online transaction processing (OLTP) database...
- Question 63: Examine the output of the following query: SQL> SELECT c....
- Question 64: Which two activities can be identified as common unscalable ...
- Question 65: You are hired by ABC Pvt Ltd., and assigned the task of mana...
- Question 66: In your organization the Oracle Database 11g installation in...
- Question 67: On examining the Automatic Workload Repository (AWR) report,...
- Question 68: While diagnosing performance problems for a database, you fi...
- Question 69: You plan to collect statistics for an important table in you...
- Question 70: You receive a recommendation for a SQL statement through the...
- Question 71: Which three factors influence the optimizer's behavior while...
- Question 72: View the Exhibit and analyze the output of the query.What do...
- Question 73: View the Exhibit that shows your investigation of performanc...
- Question 74: While configuring the snapshot data capture for your databas...
- Question 75: You are working on an online transaction processing (OLTP) s...
- Question 76: Which two symptoms related to the database buffer cache toge...
- Question 77: Identify the situation in which you would use the Automatic ...
- Question 78: View the Exhibit and analyze the output of a query executed ...
- Question 79: The Automatic Workload Repository (AWR) snapshot interval is...
- Question 80: You work on an online transaction processing (OLTP) database...
- Question 81: View the Exhibit and examine the plans in the SQL plan basel...
- Question 82: You work for ABC Pvt Ltd. The company has recently upgraded ...
- Question 83: In a database, the values for transactions per second are hi...
- Question 84: Your system is upgraded from Oracle Database 10g to Oracle D...
- Question 85: You are working on a development database that was upgraded ...
- Question 86: You have the automatic optimizer statistics gathering enable...
- Question 87: View the Exhibit and examine the Instance Efficiency Percent...
- Question 88: You work as a DBA and have the responsibility of managing a ...
- Question 89: Which statement is true regarding the setting of the PCTFREE...
- Question 90: As part of a proactive tuning activity, you have the Automat...
- Question 91: You are working as a DBA in ABC Corp. You are working on onl...
- Question 92: You work as a DBA for a company and you have the responsibil...
- Question 93: You generate an AWR Compare Periods Report for two consecuti...
- Question 94: While reviewing the Top 5 Timed Events section in the Automa...
- Question 95: A user in a session executed the following SQL statement to ...
- Question 96: Your organization has purchased licenses for the Diagnostic ...
- Question 97: You received complaints from users about slow response time ...
- Question 98: The SALES table in your database undergoes frequent changes....
- Question 99: View the Exhibit and examine the partial output obtained whe...
- Question 100: In your organization, there are two key databases. One of th...
- Question 101: You observed very low cache-hit ratio in your database as sh...
- Question 102: View the Exhibit and examine the content of the V$SGA_RESIZE...
- Question 103: View the Exhibit.You decide to select the setting option in ...
- Question 104: View the Exhibit and analyze the content of V$BUFFER_POOL_ST...
- Question 105: As a DBA, you notice that the response time of your database...
- Question 106: In which case is the database buffer cache NOT used?...
- Question 107: During a proactive database performance monitoring routine, ...
- Question 108: You identified a SQL statement with SQL ID 9g485acn2n30m, wh...
- Question 109: The users in your online transaction processing (OLTP) envir...
- Question 110: Examine the following block: BEGIN DBMS_WORKLOAD_REPOSITORY....
- Question 111: Examine the output of the query given below: SQL> SELECT ...
- Question 112: View the Exhibit and note the workload type selected to quic...
- Question 113: You work as a DBA for a company and you have the responsibil...
- Question 114: You are working on an online transaction processing (OLTP) s...
- Question 115: The database application developers are planning to make som...
- Question 116: View the Exhibit and examine the Load Profile from the AWR r...
- Question 117: You noticed a high number of SQL statements with the same PL...
- Question 118: View the Exhibit and examine the content of the V$SGA_RESIZE...
- Question 119: Identify the reason why chained or migrated rows in a table ...
- Question 120: What type of redundancy would you recommend for the Automati...
- Question 121: You are working as a DBA on an online transaction processing...
- Question 122: View the Exhibit and examine the query based on the DBA_THRE...
- Question 123: You work as a consultant DBA for various clients. A performa...
- Question 124: You work in an online transaction processing (OLTP) environm...
- Question 125: View the Exhibit and examine the Automatic Database Diagnost...
- Question 126: You work in an online transaction processing (OLTP) environm...
- Question 127: You observe that suboptimal execution plans for the queries ...
- Question 128: You work as a DBA in ABC Corp. You are working on an online ...
- Question 129: You are a DBA in ABC Corp. You are working on an online tran...
- Question 130: You work as a consultant DBA for various clients. A performa...
- Question 131: View the Exhibit and examine a portion of the output obtaine...
- Question 132: Examine the initialization parameter values for the instance...
- Question 133: View the Exhibit.You decide to quickly configure the adaptiv...
- Question 134: View the Exhibit and examine the details of the Top 5 Timed ...
- Question 135: You used SQL Tuning Advisor for a long-running SQL statement...
- Question 136: A user, SCOTT, complains that his database session, SID 249,...
- Question 137: You are managing an online transaction processing (OLTP) sys...
- Question 138: View Exhibit1 to examine the description of the CUSTOMERS ta...
- Question 139: View the Exhibit and examine portions of two ASH reports gen...
- Question 140: You want to review a summary of all the wait events in an in...
- Question 141: You work as a DBA and you have the responsibility of managin...
- Question 142: You are a DBA in ABC Corp. You are working on a DSS system.....
- Question 143: You work as a DBA for a company and as a performance improve...
- Question 144: Identify the two direct sources from where SQL plans can be ...
- Question 145: Examine the values for the following initialization paramete...
- Question 146: You identified poorly performing SQL by analyzing the V$SQL ...
- Question 147: View the Exhibit and examine the content of the V$MEMORY_RES...
- Question 148: You find that in the Top 5 Timed Events section of the Autom...
- Question 149: In which two scenarios would you recommend using RAID level ...
- Question 150: Which two inferences are correct about the CPU time and the ...
- Question 151: View the Exhibit and examine the content. (Exhibit) ALLOCATE...
- Question 152: You used SQL Tuning Advisor for a long-running SQL statement...
- Question 153: You work as a DBA for a company and as a performance improve...
- Question 154: View Exhibit1 and examine the indexes on the CUSTOMERS table...
- Question 155: View the Exhibit and examine the content. ALLOCATED_SPACE an...
- Question 156: You have a range-partitioned table in your database. Each pa...
- Question 157: View the Exhibit that shows your investigation on degraded p...
- Question 158: You are working on an online transaction processing (OLTP) d...
- Question 159: You are asked to implement Automatic Memory Management (AMM)...
- Question 160: You observed that some of the queries are performing poorly ...
- Question 161: Examine the following query and its output: SQL>SELECT na...
- Question 162: Your database has the HR and Reporting applications. The HR ...
- Question 163: The Service-Level Agreement for the production database incl...
- Question 164: You are working on an online transaction processing (OLTP) s...
- Question 165: You find that the OS utilization is over 40% in your databas...
- Question 166: The users in your online transaction processing (OLTP) envir...
- Question 167: Your database has the ACCTG service configured for an accoun...
- Question 168: Your company wants to migrate a single instance Oracle 11g R...
- Question 169: View the Exhibit and examine the sample Automatic Database D...
- Question 170: You are working in an online transaction processing (OLTP) e...
- Question 171: You are working for a company that uses huge applications to...
- Question 172: The users in your online transaction processing (OLTP) envir...
- Question 173: You look at the Top 5 Timed Events section of the Automatic ...
- Question 174: You are working on a single node database. The storage for t...
- Question 175: Examine the following block that executes a SQL Performance ...
- Question 176: Which is the correct description of SQL profiling while usin...
- Question 177: Examine the following information from the AWR report: Top 5...
- Question 178: You are working on the Database using file system RAID level...
- Question 179: You identified poorly performing SQL statements that use bin...
- Question 180: View Exhibit1 and examine a portion of Active Session Histor...
