Temos o seguinte status:[oracle@svr2342 ~]$ emctl status agentOracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.---------------------------------------------------------------Agent Version : 11.1.0.1.0OMS Version : 11.1.0.1.0Protocol Version : 11.1.0.0.0Agent Home : /u00/app/oracle/product/agent11g/svr2342Agent binaries : /u00/app/oracle/product/agent11gAgent Process ID : 1553Parent Process ID : 1522Agent URL : https://svr2342:3872/emd/mainRepository URL : https://svr2078.adm.infra:4900/em/uploadStarted at : 2012-11-05 12:13:48Started by user : oracleLast Reload : 2012-11-05 12:14:21Last successful upload : (none)Last attempted upload : (none)Total Megabytes of XML files uploaded so far : 0.00Number of XML files pending upload : 109Size of XML files pending upload(MB) : 6.15Available disk space on upload filesystem : 83.36%Last attempted heartbeat to OMS : 2012-11-05 12:13:54Last successful heartbeat to OMS : unknown---------------------------------------------------------------Agent is Running and ReadyAo tentar fazer upload manual, temos o seguinte erro:[oracle@svr2342 ~]$ emctl upload agentOracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.---------------------------------------------------------------EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet. If this issue persists check trace files for ping to OMS related errors.Ao verificar o log, fica claro o problema:ERROR pingManager: Did not receive valid response to ping "ERROR-Agent is blocked. Blocked reason is: Agent is out-of-sync with repository. This most likely means that the agent was reinstalled or recovered. Please contact an EM administrator to unblock the agent by performing an agent resync from the console. Please contact EM adminstrator to unblock the agent" Para corrigir, basta entrar no agent pelo EM ( SETUP >> AGENT ) e fazer o "Agent Resynchronization". --total cursors open, by sessionselect a.value, s.username, s.sid, s.serial#from v$sesstat a, v$statname b, v$session swhere a.statistic# = b.statistic# and s.sid=a.sidand b.name = 'opened cursors current';--total cursors open, by username & machineselect sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,s.username, s.machinefrom v$sesstat a, v$statname b, v$session swhere a.statistic# = b.statistic# and s.sid=a.sidand b.name = 'opened cursors current'group by s.username, s.machineorder by 1 desc;select max(a.value) as highest_open_cur, p.value as max_open_curfrom v$sesstat a, v$statname b, v$parameter pwhere a.statistic# = b.statistic#and b.name = 'opened cursors current'and p.name= 'open_cursors'group by p.value;Fonte: http://orafaq.com/node/758 Procedimento para atualizar uma sequence que esta com valores desatualizados:-- Pegar valor da sequenceselect seq_audit_log.nextval from dual; --190382-- Pegar valor do maximo campo da tabela onde a aplicacao usa a sequenceselect max(idt_audit_log) - 190382 from audit_log;-- Alterar incremento e atualizar sequencealter sequence SEQ_AUDIT_LOG increment by 741;select SEQ_AUDIT_LOG.nextval from dual;alter sequence SEQ_AUDIT_LOG increment by 1;select seq_audit_log.currval from dual; --191123 -- Move regular indexes:select 'alter index '||owner||'.'||index_name||' rebuild tablespace &index_tbs;' from dba_indexes where owner=upper('&owner');-- Move LOB indexesselect 'alter table '||table_name||' move LOB ('||column_name||') store as '||segment_name||' (tablespace &index_tbs);'from dba_lobs where owner=upper('&owner'); SabedoriaEu amo aquele que me ama;e quem me procura acha .Temer o senhor Deus e odiar o mal.Tenho riquezas e honras,prosperidade e justica.O que eu ofereco vale mais do que o ouro fino e e melhor do que a prata mais pura. O coracao do homem pode fazer planos, mas a resposta certa dos labiosvem do Senhor.Todos os caminhos do homemsao puros aos seus olhos,mas o Senhor pesa o espirito.Confia ao Senhor as tuas obras,e os teus designiosserao estabelecidos.(Proverbios 16) Cristao nao sao poupados de sofrimentos, mas