课程第39次
$ srvctl addlistener -l L2 -o /u01/app/oracle/product/11.2.0/grid -p "TCP:1522"$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station76
ora.FRA.dg ora....up.type ONLINE ONLINE station76
ora.L2.lsnr ora....er.type OFFLINE OFFLINE
ora....ER.lsnr ora....er.type ONLINE ONLINE station76
ora.apple.db ora....se.type OFFLINE OFFLINE
ora.asm ora.asm.type ONLINE ONLINE station76
ora.cssd ora.cssd.typeONLINE ONLINE station76
ora.dbtest.dbora....se.type OFFLINE OFFLINE
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE station76
ora.ons ora.ons.type OFFLINE OFFLINE
ora.orcl.db ora....se.type ONLINE ONLINE station76
ora.rcat.db ora....se.type ONLINE ONLINE station76
$ netstat -lntp | grep :1522
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
$ srvctl start listener -l l2
$
上监听器是有问题的：
EM
select* from v$circuit;
selectterminal fromv$session where saddr='00000000BC81B880';
select* from v$dispatcher;
select substr( t.table_name, 3,1), count(*)
from dba_tables t
where t.table_name like 'WR_$\_%' escape '\'
group by substr( t.table_name, 3,1);
select * from dict where table_name like 'DBA_HIST\_%'escape '\';
selectv.text from dba_views v where v.view_name='DBA_HIST_ACTIVE_SESS_HISTORY';
select* from v$active_session_history;
v$视图“抄写”成了数据字典视图（底表倒不是在system表空间上，而是在sysaux表空间上）。
解剖AWR：
select substr( t.table_name, 3,1), count(*)
from dba_tables t
where t.table_name like 'WR_$\_%' escape '\'
group by substr( t.table_name, 3,1);
select substr( t.table_name, 3,1), count(*)
from dba_tables t
where t.table_name like 'WR_$\_%' escape '\'
group by substr( t.table_name, 3,1);
SUBSTR(T.TABLE_NAME,3,1)COUNT(*)
1H125
2R31
3I96
4M10
H就是案例系统I/M就是专家系统，以及建立在改专家系统上的神经元网络。
10g的时候只有以上这3种。
由于AWR中有案例系统（H）-->就可以把工作负载记录下来（像录像机），进而可以重新播放，所以在11g里就引入了31个R，用来做重演。
页:
[1]