【题目示意】
要查看最新的自动SQL优化指导任务的结果,你应该遵循哪些步骤?
【解析】
1. 关于em;
1.1 Em提供了通过图形化界面操作oracle数据库的一种工具。
1.2 启动em;
(数据库打开状态;启动监听,并保证数据库已经在监听上注册)
启动命令:
[oracle@ENMOEDU ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://ENMOEDU:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/ENMOEDU_ENMOEDU/sysman/log
1.3 进入em;
https://ENMOEDU:1158/em
2. 验证b选项
Home界面
点击software and support
点击advisor central
点击sql advisors
点击sql tuning advisor 即可,
c选项同理,不再验证。
【答案】D
相关参考
http://docs.oracle.com/cd/E11882_01/server.112/e40540/cncptdba.htm#CNCPT1445
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmblock.htm#BRADV89786
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29438052/viewspace-1146945/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29438052/viewspace-1146945/