1Z0-054 Exam Dumps | The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7 database instance. The space

<< Prev Question Next Question >>

Question 35/180

The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7 database instance. The space consumption has significantly increased by the automatically captured plan baselines.
You are suggested to run the following block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
After a few weeks of work, you observe warnings on exceeding space usage by SQL Management Base (SMB) in alert log file. Which two actions can be solutions for this? (Choose two.)

A. increasing the size of the SYSTEM tablespace

B. increasing the AWR retention period

C. purging the older SQL management objects

D. increasing the size of the SYSAUX tablespace

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...

Question 35/180

LEAVE A REPLY

Download PDF File