全部博文(4)
发布时间:2014-12-30 22:53:25
In OEM 11g, emctl status dbconsole shows error,[oracle@sptr ~]$ emctl status dbconsoleEnvironment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.[oracle@sptr ~]$ export ORACLE_UNQNAME=cloudapp[oracle@sptr ~]$ emctl status dbconsoleOC4J Configuration iss.........【阅读全文】
发布时间:2014-12-27 23:43:17
This test is about fixing execution plan by using sql profile. By default, the sql is using index unique scan. By adding sql profile, the sql will be forced to use full table step 1: create test table and indexSQL> conn cloudapp/cloudapp Connected..........【阅读全文】