搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单选题】

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.<br /> What would you do with these SQL statements?()

A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

B、Capture the plans from the previous version using STS and then load them into the stored outline.

C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

更多“ Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.<br /> What would you do with these SQL statements?()”相关的问题
第1题

A、has a permissive interface that is used to monitor networks  B、is an active device in the traffic path  C、passively listens to network traffic  D、has a promiscuous interface that is used to monitor the network  

点击查看答案
第3题

A、 bee.wav  B、 bee.mid  C、 bee.avi  D、 bee.doc  

点击查看答案
第4题

A、adding small amounts of oil to the system  B、the system has been overheated  C、the system has been drained and then filled with new oil  D、the system has been idle for a long period of time  

点击查看答案
第5题

A、Compilation fails.  B、The file system has a new empty directory named dir.  C、The file system has a new empty directory named newDir.  D、The file system has a directory named dir, containing a file f1.txt.  E、The file system has a directory named newDir, containing a file f1.txt.  

点击查看答案
第8题

A、immediately anchor your vessel and arrange for repairs to the system  B、moor your vessel at the nearest dock available and arrange for repairs to the system  C、arrange for the repair of the system to be completed within 48 hours  D、exercise due diligence to restore the system at the earliest practicable time  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服