Sep-15

16-Sep
Oracle LCM – CM cheet sheet
http://www.oracle.com/us/products/enterprise-manager/change-management-pack-11g-ds-068451.pdf

Top latch misses..

SELECT inst_id INT,
       latch#,
       level#,
       child#  "Child",
       addr    "Address",
       name    "Name",
       gets    "Gets",
       misses  "Misses",
       sleeps  "Sleeps"
FROM   gv$latch_children
WHERE  misses > 1000
ORDER  BY 1,6,2,3;

Object / block details of a latch addr

SELECT /*+ ordered */ e.owner
                      ||'.'
                      || e.segment_name         segment_name,
                      e.extent_id               extent#,
                      x.dbablk - e.block_id + 1 block#,
                      x.tch,
                      l.child#
FROM  sys.v$latch_children l,
      sys.x$bh x,
      sys.dba_extents e
WHERE l.name = 'cache buffers chains'
      AND i.addr='&latch_child_addr'
      AND x.hladdr = l.addr
      AND e.file_id = x.file#
      AND x.dbablk BETWEEN e.block_id AND e.block_id + e.blocks - 1;

OEM emcli reference
https://docs.oracle.com/cd/E24628_01/em.121/e17786/deploy.htm#EMCLI127
02-Sep

OEM 12c – agent commands

 
$ emctl config agent listtargets

Current blackout status

$ emctl blackout status

Agent status

$ emctl agent status

Agent directory

$ emctl getemhome

Pluggins installed

$ emctl listplugins agent

Setting blackout for all targets in a host

$ emctl start blackout <Blackout Name>  [ -nodelevel ] –d <Duration>
$ emctl start blackout Test -nodelevel -d 0:05

 

Advertisements
%d bloggers like this: