<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8518548532118031835</id><updated>2024-11-05T18:45:43.823-08:00</updated><category term="http://www.blogger.com/img/blank.gif"/><title type='text'>Oracle Startup</title><subtitle type='html'>Scripts e Dicas de Administração Oracle</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>73</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-2024969074440777663</id><published>2013-07-21T11:17:00.001-07:00</published><updated>2013-07-21T11:17:54.177-07:00</updated><title type='text'>Upgrade para Oracle 11 G Release 2</title><content type='html'>&lt;br /&gt;
&amp;nbsp;Esta imagem fornecida pela Oracle mostra o caminho seguro a ser seguindo no caso de upgrade para a versão 11.2 do oracle 11g.Fica a Dica.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkqXKGj3tiYald1lJsX2wRd7kifHDpBGYhEUft2v5FQ9xglH1buycDE4is_xu8P-RyYahL6f6qqPFuvEoDavOUPK3oGaRU9GS4xgFYc61qIwP4EIuu9Vjv9obwht-TwY9ccRWR3g7_VwDx/s1600/UpgradeTo11gr2.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;277&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkqXKGj3tiYald1lJsX2wRd7kifHDpBGYhEUft2v5FQ9xglH1buycDE4is_xu8P-RyYahL6f6qqPFuvEoDavOUPK3oGaRU9GS4xgFYc61qIwP4EIuu9Vjv9obwht-TwY9ccRWR3g7_VwDx/s400/UpgradeTo11gr2.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/2024969074440777663/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2013/07/upgrade-para-oracle-11-g-release-2.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2024969074440777663'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2024969074440777663'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2013/07/upgrade-para-oracle-11-g-release-2.html' title='Upgrade para Oracle 11 G Release 2'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkqXKGj3tiYald1lJsX2wRd7kifHDpBGYhEUft2v5FQ9xglH1buycDE4is_xu8P-RyYahL6f6qqPFuvEoDavOUPK3oGaRU9GS4xgFYc61qIwP4EIuu9Vjv9obwht-TwY9ccRWR3g7_VwDx/s72-c/UpgradeTo11gr2.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-6576178269725682609</id><published>2013-05-16T07:52:00.003-07:00</published><updated>2013-05-16T07:52:44.380-07:00</updated><title type='text'>Archivelog no banco de dados Oracle - Como Habilitar/Desabilitar </title><content type='html'>&lt;span style=&quot;background-color: white; color: #666666; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white;&quot;&gt;Segue uma dica que me ajudou hoje .&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4;&quot;&gt;==&amp;gt; &lt;b&gt;Habilitando na sua instancia o modo Archive log do oracle via comando.&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4;&quot;&gt;SQL&amp;gt; select log_mode from gv$database;&lt;/span&gt;&lt;br /&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
SQL&amp;gt; shutdown immediate;&lt;br /&gt;SQL&amp;gt; startup mount exclusive;&lt;br /&gt;SQL&amp;gt; alter database archivelog;&lt;br /&gt;SQL&amp;gt; alter database open;&lt;br /&gt;SQL&amp;gt; select log_mode from gv$database;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
==&amp;gt; &lt;b&gt;Desabilitando modo Archive &amp;nbsp;Log&lt;/b&gt;.&lt;/div&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
SQL&amp;gt; startup mount&lt;br /&gt;SQL&amp;gt; alter database noarchivelog;&lt;br /&gt;SQL&amp;gt; alter database open;&lt;/div&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-6175044431965725146&quot; itemprop=&quot;description articleBody&quot; style=&quot;background-color: white; font-family: &#39;Trebuchet MS&#39;, Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 1.4; position: relative; width: 546px;&quot;&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
O que é o modo Arquive Log ?&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;b style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;Archivelog&lt;/b&gt;&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;&amp;nbsp;é gerado pelo banco de dados em todas as operações de transações no banco de dados como:&amp;nbsp;&lt;/span&gt;&lt;i style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;INSERT, DROP, ALTER&lt;/i&gt;&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;,&amp;nbsp;&lt;/span&gt;&lt;i style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;ETC&lt;/i&gt;&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;. No Oracle versão 9i para frente a Oracle recomenda o uso do Backup com&amp;nbsp;&lt;/span&gt;&lt;i style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;RMAN&lt;/i&gt;&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;, isto implica dizer que você precisa do seu banco em modo de&amp;nbsp;&lt;/span&gt;&lt;i style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;Archive&lt;/i&gt;&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;.&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;mais informações em :&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;a href=&quot;http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12007.htm&quot;&gt;http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12007.htm&lt;/a&gt;&amp;nbsp;&amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;a href=&quot;http://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo002.htm&quot;&gt;http://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo002.htm&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: &#39;Times New Roman&#39;; font-size: medium; line-height: normal;&quot;&gt;
&lt;span style=&quot;color: #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.890625px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/6576178269725682609/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2013/05/archivelog-no-banco-de-dados-oracle.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6576178269725682609'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6576178269725682609'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2013/05/archivelog-no-banco-de-dados-oracle.html' title='Archivelog no banco de dados Oracle - Como Habilitar/Desabilitar '/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-4854248681067489670</id><published>2013-04-10T09:28:00.001-07:00</published><updated>2013-04-10T09:28:31.195-07:00</updated><title type='text'>Verificar Procedures que utilizam Cursos - ERRO ORA-01000 MAXIMUM OPEN CURSORS EXCEEDED</title><content type='html'>&amp;nbsp;Segue uma dica para quem possa estar passando pelo erro&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;ERRO ORA-01000 MAXIMUM OPEN CURSORS EXCEEDED&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Verifique as procedures do seu SGDB que utilizam CURSOR e que possam estar esquecendo de fechar o cursor.Para descobrir as procedures ,utilize o script abaixo.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM DBA_SOURCE U&lt;br /&gt;
WHERE U.TYPE = &#39;PROCEDURE&#39;&lt;br /&gt;
AND U.OWNER = :Powner&lt;br /&gt;
AND U.TEXT LIKE &#39;%CURSOR%&#39;&lt;br /&gt;
&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/4854248681067489670/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2013/04/verificar-procedures-que-utilizam.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4854248681067489670'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4854248681067489670'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2013/04/verificar-procedures-que-utilizam.html' title='Verificar Procedures que utilizam Cursos - ERRO ORA-01000 MAXIMUM OPEN CURSORS EXCEEDED'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-7663620605254904274</id><published>2013-03-07T06:18:00.001-08:00</published><updated>2013-03-07T06:18:58.687-08:00</updated><title type='text'>Oracle - SAFE - Simple Algorithm for Fragmentation </title><content type='html'>&amp;nbsp;Leitores.Segue um material que não foi escrito por mim mas que já me ajudou tanto que acho interessante a leitura de todos.&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&amp;nbsp;&lt;a href=&quot;https://rapidshare.com/files/1664176855/Oracle%20-%20SAFE%20-%20Simple%20Algorithm%20for%20Fragmentation%20Elimination.pdf&quot;&gt;Oracle - SAFE - Simple Algorithm for Fragmentation Elimination&lt;/a&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/7663620605254904274/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2013/03/oracle-safe-simple-algorithm-for.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7663620605254904274'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7663620605254904274'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2013/03/oracle-safe-simple-algorithm-for.html' title='Oracle - SAFE - Simple Algorithm for Fragmentation '/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-1674485329527148113</id><published>2012-12-27T17:42:00.003-08:00</published><updated>2012-12-27T17:42:57.958-08:00</updated><title type='text'>Bloquear e desbloquear usuário</title><content type='html'>&lt;br /&gt;
Essa foi um pedido de ajuda que recebi hoje e achei legal publicar.Me pediram um sql que mostrasse a lista dos usuários do nosso banco e o seu status atual.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Segue um querie para ajudar :&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&amp;nbsp;select&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;username &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; as usuario&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;,&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;account_status status as status&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;,&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;created &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;as data_de_criacao&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;,&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;default_tablespace &amp;nbsp; &amp;nbsp; as &amp;nbsp;tablespace&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;from&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;dba_users&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;order&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;by username&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Para bloquear um usuário ou desbloquear o login deste usuáro , segue abaixo o exemplo :&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;alter user &amp;lt;nome_do_usuário&amp;gt; account lock;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;
&lt;b&gt;alter user &amp;lt;nome_do_usuário&amp;gt; account unlock;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/1674485329527148113/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/12/bloquear-e-desbloquear-usuario.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/1674485329527148113'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/1674485329527148113'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/12/bloquear-e-desbloquear-usuario.html' title='Bloquear e desbloquear usuário'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-1938600235732979225</id><published>2012-12-27T17:32:00.003-08:00</published><updated>2012-12-27T17:32:47.637-08:00</updated><title type='text'>Verifique o tamanho dos Schemas no seu SGDB</title><content type='html'>&lt;br /&gt;
&amp;nbsp;Seu SGDB cresceu e você não entende o porque ? Procure &amp;nbsp;o Schema que está ocupando mais espaço nas tablespaces do seu SGDB.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
select&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;obj.owner as &quot;Schema&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; obj_cnt as &quot;Qtd_Objects&quot;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; decode(seg_size, NULL, 0, seg_size) &quot;size MB&quot;&lt;br /&gt;
from (select owner, count(*) obj_cnt from dba_objects group by owner) obj,&lt;br /&gt;
&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt; (select owner, ceil(sum(bytes)/1024/1024) seg_size&lt;br /&gt;
&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt; &amp;nbsp; &amp;nbsp;from dba_segments group by owner&lt;br /&gt;
&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt; &amp;nbsp;) seg&lt;br /&gt;
where &lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;obj.owner &amp;nbsp;= seg.owner(+)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/1938600235732979225/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/12/verifique-o-tamanho-dos-schemas-no-seu.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/1938600235732979225'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/1938600235732979225'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/12/verifique-o-tamanho-dos-schemas-no-seu.html' title='Verifique o tamanho dos Schemas no seu SGDB'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-5558781955011174863</id><published>2012-10-14T05:42:00.001-07:00</published><updated>2012-10-14T05:42:32.945-07:00</updated><title type='text'>ANALISAR INDICES FRAGMENTADOS</title><content type='html'>&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;Pessoal.Segue uma dica para analise de fragmentação dos indices .&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;(1) -- CRIAR A TABELA ONDE ARMAZENAMENTOS AS INFORMAÇÕES&lt;/b&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; CREATE TABLE SGDB_INDICE_STATUS (INDEX_NAME VARCHAR(100),PCT_DELETED NUMBER,PCT_USED NUMBER,BLOCK NUMBER,DTEXECUAO DATE DEFAULT SYSDATE) ;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; ALTER TABLE SGDB_INDICE_STATUS ADD CONSTRAINT PK_MMED_IND_STATUS PRIMARY KEY (INDEX_NAME,DTEXECUAO) ;&lt;/span&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;(2) -- RODAR A QUERY ABAIXO E PEGAR O RESULTADO DELA PARA EXECUAR&amp;nbsp;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; SELECT COMM&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; FROM(&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; SELECT 1 AS ID,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ROWNUM AS ID2,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt; &#39;ANALYZE INDEX &#39; ||INDEX_NAME || &#39; VALIDATE STRUCTURE ; &#39; AS COMM&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; FROM DBA_INDEXES&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE OWNER = &#39;DBA_CLINICA&#39;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;UNION ALL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;SELECT 2 AS ID,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ROWNUM ID2,&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&#39;INSERT INTO SGDB_INDICE_STATUS SELECT NAME,TRUNC(100*(NVL(DEL_LF_ROWS,1)/NVL(LF_ROWS,1))) PCT_DELETED, PCT_USED ,BLOCKS ,SYSDATE FROM INDEX_STATS ;&#39; AS COMM&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM DBA_INDEXES&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;WHERE OWNER = &#39;DBA_CLINICA&#39; AND&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; ORDER BY ID2,ID&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;) &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;(3) -- EXECUTAR O RESULTADO DO PASSO 3 E DAR COMMIT .&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; COMMIT ;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;(4) -- VERIFICAR OS&amp;nbsp;ÍNDICES&amp;nbsp;COM MAIS DE 30 % DE FRAGMENTAÇÃO&amp;nbsp;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; SELECT DISTINCT A.* ,B.TABLE_NAME&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM &amp;nbsp;SGDB_INDICE_STATUS A&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; JOIN &amp;nbsp;DBA_INDEXES B ON B.INDEX_NAME = A.INDEX_NAME&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;WHERE PCT_DELETED &amp;gt; 20&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;AND PCT_DELETED &amp;lt; 100&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;ORDER BY PCT_DELETED DESC&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;&amp;nbsp;(5) -- AJUSTA OS&amp;nbsp;ÍNDICES&amp;nbsp;QUE FORAM ENCONTADOS COM FRAGMENTAÇÃO MAIOR QUE 20 %&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; -- RODAR A QUERY ABAIXO E DEPOIS EXECUTAR O RESULTADO&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;SELECT DISTINCT &#39;ALTER INDEX &#39; || A.INDEX_NAME || &#39; REBUILD TABLESPACE TSP_CLINICA_INDEX ; &#39; AS RESULTADO&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; FROM &amp;nbsp;SGDB_INDICE_STATUS A&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; JOIN &amp;nbsp;DBA_INDEXES B&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt; &amp;nbsp;ON B.INDEX_NAME = A.INDEX_NAME&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp;WHERE PCT_DELETED &amp;gt; 20&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;AND PCT_DELETED &amp;lt; 100&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/5558781955011174863/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/analisar-indices-fragmentados.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/5558781955011174863'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/5558781955011174863'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/analisar-indices-fragmentados.html' title='ANALISAR INDICES FRAGMENTADOS'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-6424062659313505175</id><published>2012-10-10T16:34:00.001-07:00</published><updated>2012-10-10T16:34:35.275-07:00</updated><title type='text'>Mover um Datafile de sua Tablespace</title><content type='html'>&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;segue um exemplo simples de uma das formas seguras de movermos um datafile .&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;(1) Caso de sgdb em modo sem Archive Mode :&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp; &lt;b&gt;Pare seu banco&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp; shutdown immediate;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;b&gt;&amp;nbsp;Depois faça a copia do datafile &lt;/b&gt;:&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;copy &amp;nbsp;d:&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;/u01/data/datafile.dbf &amp;nbsp;e:/u01/data/datafile_novo.dbf &amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;&lt;b&gt;Inicie o banco em modo mount&amp;nbsp;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;startup mount;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;&lt;b&gt;faça o rename datafile&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;ALTER DATABASE RENAME FILE ‘d:/u01/data/datafile.dbf’ TO ‘e:/u01/data/datafile_novo.dbf’;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;b&gt;&amp;nbsp;Inicie o banco em modo open ;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;ALTER DATABASE OPEN;&lt;/span&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;(2) Caso de sgdb em modo Archive Mode :
&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;b&gt;&amp;nbsp;coloque o seu datafile como offline :&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&amp;nbsp;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;ALTER DATABASE DATAFILE ‘/u01/data/datafile.dbf’ OFFLINE;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;b&gt;&amp;nbsp;Depois faça a copia do datafile :&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;copy &amp;nbsp;d:&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;/u01/data/datafile.dbf &amp;nbsp;e:/u01/data/datafile_novo.dbf &amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;&lt;b&gt;faça o rename datafile&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;ALTER DATABASE RENAME FILE ‘d:/u01/data/&lt;/span&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;datafile&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;.dbf’ TO ‘e:/u01/data/datafile_novo.dbf’;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;b&gt;Fazer o recover do datafile:&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;RECOVER DATAFILE ‘e:/u01/data/&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;datafile_novo&lt;/span&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;.dbf’;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;&lt;b&gt;Colocar online o datafile:&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &#39;Courier New&#39;, Courier, monospace;&quot;&gt;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;ALTER DATABASE DATAFILE ‘&lt;/span&gt;
&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;e:/u01/data/datafile_novo.dbf&lt;/span&gt;&amp;nbsp;&lt;span style=&quot;background-color: white; line-height: 17px;&quot;&gt;’ ONLINE;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: white; color: #555555; font-family: Verdana, &#39;BitStream vera Sans&#39;, Helvetica, sans-serif; font-size: 12px; line-height: 17px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;background-color: white; color: #555555; font-family: Verdana, &#39;BitStream vera Sans&#39;, Helvetica, sans-serif; font-size: 12px; line-height: 17px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/6424062659313505175/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/mover-um-datafile-de-sua-tablespace.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6424062659313505175'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6424062659313505175'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/mover-um-datafile-de-sua-tablespace.html' title='Mover um Datafile de sua Tablespace'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-4571294729376955825</id><published>2012-10-02T11:13:00.000-07:00</published><updated>2012-10-02T11:13:07.437-07:00</updated><title type='text'>Oracle Critical Patch Update</title><content type='html'>&amp;nbsp;Pessoal.Segue um link onde de forma unificada a Oracle informa o Criticals Paths de seu produtos (incluindo os databases) :&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.oracle.com/technetwork/topics/security/alerts-086861.html#CriticalPatchUpdates&quot; style=&quot;background-color: white; color: #2970a6; font-family: Verdana, &#39;BitStream vera Sans&#39;, Helvetica, sans-serif; font-size: 12px; line-height: 17px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;&quot;&gt;http://www.oracle.com/technetwork/topics/security/alerts-086861.html#CriticalPatchUpdates&lt;/a&gt;
&lt;br /&gt;
&lt;br /&gt;
Fica a Dica.</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/4571294729376955825/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/oracle-critical-patch-update.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4571294729376955825'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4571294729376955825'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/10/oracle-critical-patch-update.html' title='Oracle Critical Patch Update'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-3180622452428685688</id><published>2012-09-09T04:55:00.000-07:00</published><updated>2012-09-09T04:55:05.027-07:00</updated><title type='text'>Eliminar sessões bloqueadores por comandos DDL</title><content type='html'>Segue uma dica para momentos difíceis como os lock por ddl :&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Eliminar sessões maléficas :&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;select &#39;alter system kill session &#39;&#39;&#39; || ddl.session_id || &#39;,&#39; || ses.serial# || &#39;&#39;&#39; immediate;&#39;
from dba_ddl_locks ddl
, v$session ses
where owner like &#39;%userid%&#39;
and ddl.session_id = ses.sid&lt;/pre&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;Rode o resultado da query .&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Identificar o lock por ddl :&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;select decode(lob.kglobtyp, 
  0, &#39;NEXT OBJECT&#39;, 1, &#39;INDEX&#39;, 2, &#39;TABLE&#39;, 3, &#39;CLUSTER&#39;,
  4, &#39;VIEW&#39;, 5, &#39;SYNONYM&#39;, 6, &#39;SEQUENCE&#39;,
  7, &#39;PROCEDURE&#39;, 8, &#39;FUNCTION&#39;, 9, &#39;PACKAGE&#39;,
  11, &#39;PACKAGE BODY&#39;, 12, &#39;TRIGGER&#39;,
  13, &#39;TYPE&#39;, 14, &#39;TYPE BODY&#39;,
  19, &#39;TABLE PARTITION&#39;, 20, &#39;INDEX PARTITION&#39;, 21, &#39;LOB&#39;,
  22, &#39;LIBRARY&#39;, 23, &#39;DIRECTORY&#39;, 24, &#39;QUEUE&#39;,
  28, &#39;JAVA SOURCE&#39;, 29, &#39;JAVA CLASS&#39;, 30, &#39;JAVA RESOURCE&#39;,
  32, &#39;INDEXTYPE&#39;, 33, &#39;OPERATOR&#39;,
  34, &#39;TABLE SUBPARTITION&#39;, 35, &#39;INDEX SUBPARTITION&#39;,
  40, &#39;LOB PARTITION&#39;, 41, &#39;LOB SUBPARTITION&#39;,
  42, &#39;MATERIALIZED VIEW&#39;,
  43, &#39;DIMENSION&#39;,
  44, &#39;CONTEXT&#39;, 46, &#39;RULE SET&#39;, 47, &#39;RESOURCE PLAN&#39;,
  48, &#39;CONSUMER GROUP&#39;,
  51, &#39;SUBSCRIPTION&#39;, 52, &#39;LOCATION&#39;,
  55, &#39;XML SCHEMA&#39;, 56, &#39;JAVA DATA&#39;,
  57, &#39;SECURITY PROFILE&#39;, 59, &#39;RULE&#39;,
  62, &#39;EVALUATION CONTEXT&#39;,&#39;UNDEFINED&#39;
 ) object_type
, lob.kglnaobj object_name
, pn.kglpnmod lock_mode_held
, pn.kglpnreq lock_mode_requested
, ses.sid
, ses.serial#
, ses.username
from v$session_wait vsw
, x$kglob  lob
, x$kglpn  pn
, v$session ses
where vsw.event = &#39;library cache lock&#39;
and vsw.p1raw = lob.kglhdadr
and lob.kglhdadr = pn.kglpnhdl
and pn.kglpnmod != 0
and pn.kglpnuse = ses.saddr&lt;/pre&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/3180622452428685688/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/eliminar-sessoes-bloqueadores-por.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3180622452428685688'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3180622452428685688'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/eliminar-sessoes-bloqueadores-por.html' title='Eliminar sessões bloqueadores por comandos DDL'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-5070482893661062400</id><published>2012-09-09T04:49:00.003-07:00</published><updated>2012-09-09T04:49:34.898-07:00</updated><title type='text'>Trabalhando com Triggers</title><content type='html'>Segue algumas dicas para quem trabalha com triggers no seu schema .&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Listar as triggers do SGDB por Schema :&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;set lines 100 pages 999
select trigger_name
, trigger_type
, table_name
, status
from dba_triggers
where owner = &#39;&amp;amp;owner&#39;
order by status, table_name&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;
&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;&lt;b&gt;Listar as triggers relacionadas a uma tabela do seu schema :&lt;/b&gt;&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;set lines 100 pages 999
select trigger_name
, trigger_type
, status
from dba_triggers
where owner = &#39;&amp;amp;owner&#39;
and table_name = &#39;&amp;amp;table&#39;
order by status, trigger_name&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;
&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;&lt;b&gt;Habilitar/desabilitar um trigger :&lt;/b&gt;&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;
&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;alter trigger &amp;lt;trigger_name&amp;gt; enable&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;alter trigger &amp;lt;trigger_name&amp;gt; disable&lt;/pre&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;color: blue; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;&lt;/pre&gt;
&lt;span style=&quot;color: blue;&quot;&gt;
&lt;/span&gt;&lt;/pre&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/5070482893661062400/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/trabalhando-com-triggers.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/5070482893661062400'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/5070482893661062400'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/trabalhando-com-triggers.html' title='Trabalhando com Triggers'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-2511657230684164650</id><published>2012-09-09T04:38:00.000-07:00</published><updated>2012-09-09T04:38:30.678-07:00</updated><title type='text'>Tempo que seu SGDB está Ativo</title><content type='html'>Segue uma dia de como você verificar o tempo que o seu SGDB oracle está ativo.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre class=&quot;qcode&quot; style=&quot;font-size: 13px; margin-right: 10px; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;select startup_time - sysdate
  from v$instance&lt;/pre&gt;
</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/2511657230684164650/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/tempo-que-seu-sgdb-esta-ativo.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2511657230684164650'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2511657230684164650'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/09/tempo-que-seu-sgdb-esta-ativo.html' title='Tempo que seu SGDB está Ativo'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-3008975249719597722</id><published>2012-06-07T06:44:00.001-07:00</published><updated>2012-06-07T06:44:11.425-07:00</updated><title type='text'>Oracle 11G - Senhas Case Sensitive</title><content type='html'>Pessoal.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Ai vai uma dica boba para quem está migrando de uma versão inferior do Oracle 11 G para o mesmo e está tendo problema com o fato de &amp;nbsp;nesta versão o padrão ser que as senhas sejam &quot;CASE SENSITIVE&quot;.segue o comando para retirar esse padrão .Tratasse de um novo&amp;nbsp;parâmetro.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;&quot; name=&quot;PAGETOP&quot; style=&quot;background-color: #eeeeee; font-family: arial, helvetica, sans-serif; font-size: 12px;&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;table align=&quot;center&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; height=&quot;70%&quot; id=&quot;t18PageBody&quot; style=&quot;background-color: white; empty-cells: show; font-size: 9pt;&quot; summary=&quot;&quot;&gt;&lt;tbody style=&quot;font-size: 9pt;&quot;&gt;
&lt;tr style=&quot;font-size: 9pt;&quot;&gt;&lt;td height=&quot;100%&quot; id=&quot;t18ContentBody&quot; style=&quot;border-collapse: collapse; empty-cells: show; font-size: 1em;&quot; valign=&quot;top&quot; width=&quot;100%&quot;&gt;&lt;table style=&quot;empty-cells: show; font-size: 9pt;&quot;&gt;&lt;tbody style=&quot;font-size: 9pt;&quot;&gt;
&lt;tr style=&quot;font-size: 9pt;&quot;&gt;&lt;td style=&quot;border-collapse: collapse; empty-cells: show; font-size: 1em;&quot; valign=&quot;top&quot; width=&quot;100%&quot;&gt;&lt;table style=&quot;empty-cells: show; font-size: 9pt;&quot;&gt;&lt;tbody style=&quot;font-size: 9pt;&quot;&gt;
&lt;tr style=&quot;font-size: 9pt;&quot;&gt;&lt;td colspan=&quot;2&quot; style=&quot;border-collapse: collapse; empty-cells: show; font-size: 1em;&quot; valign=&quot;top&quot; width=&quot;100%&quot;&gt;&lt;div id=&quot;t18ContentMiddle&quot; style=&quot;font-size: 1em; padding-bottom: 0px; padding-left: 5px; padding-right: 5px; padding-top: 0px;&quot;&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;t18Region&quot; id=&quot;R6544425240409845&quot; style=&quot;border-bottom-style: none; border-color: initial; border-image: initial; border-left-style: none; border-right-style: none; border-top-style: none; border-width: initial; empty-cells: show; font-size: 9pt; margin-bottom: 5px; margin-left: 5px; margin-right: 5px; margin-top: 5px;&quot; summary=&quot;&quot;&gt;&lt;tbody class=&quot;ReportsRegion&quot; style=&quot;font-size: 9pt;&quot;&gt;
&lt;tr style=&quot;font-size: 9pt;&quot;&gt;&lt;td class=&quot;t18RegionBody&quot; colspan=&quot;2&quot; style=&quot;border-collapse: collapse; empty-cells: show; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px;&quot;&gt;&lt;pre&gt;&lt;b&gt;&lt;span style=&quot;font-size: large;&quot;&gt;alter system set sec_case_sensitive_logon=False&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size: 1em;&quot;&gt; &lt;/span&gt;&lt;/pre&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/3008975249719597722/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/06/oracle-11g-senhas-case-sensitive.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3008975249719597722'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3008975249719597722'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/06/oracle-11g-senhas-case-sensitive.html' title='Oracle 11G - Senhas Case Sensitive'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-239389684187079946</id><published>2012-04-07T15:03:00.000-07:00</published><updated>2012-04-07T15:06:07.954-07:00</updated><title type='text'>Monitoramento de uso de Indices.</title><content type='html'>&lt;br /&gt;
Deseja verificar se os&amp;nbsp;índices&amp;nbsp;do Schema estão sendo utilizados ? Siga estes passas&lt;br /&gt;
&lt;br /&gt;
(1) Coloque os indices para ser monitorados :&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Rode a query abaixo,e depois pegue o resultado da mesma&lt;br /&gt;
e rode como um script.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;SELECT &#39;ALTER INDEX &#39;||INDEX_NAME||&#39; MONITORING USAGE;&#39; SQL&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp; FROM USER_INDEXES&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp;WHERE INDEX_TYPE = &#39;NORMAL&#39;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp;ORDER BY TABLE_NAME, INDEX_NAME;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
(2)Deixe por um período de tempo estes indices em monitoramento.Depois disso&lt;br /&gt;
você pode executar um select na view V$OBJECT_USAGE e verificar o uso do seu&lt;br /&gt;
indice.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;select INDEX_NAME, TABLE_NAME, MONITORING, USED, START_MONITORING, END_MONITORING&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp; from V$OBJECT_USAGE&lt;/b&gt;&lt;br /&gt;
&amp;nbsp;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;(3) Como toda monitoria tem custo,depois disso retire os mesmos indices do&lt;br /&gt;
&amp;nbsp;monitoramento.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp; Rode a query abaixo,e depois pegue o resultado da mesma&lt;br /&gt;
e rode como um script.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;SELECT &#39;ALTER INDEX &#39;||INDEX_NAME||&#39; NOMONITORING USAGE;&#39; SQL&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp; FROM USER_INDEXES&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp;WHERE INDEX_TYPE = &#39;NORMAL&#39;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&amp;nbsp;ORDER BY TABLE_NAME, INDEX_NAME;&lt;/b&gt;&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/239389684187079946/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/04/monitoramento-de-uso-de-indices.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/239389684187079946'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/239389684187079946'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/04/monitoramento-de-uso-de-indices.html' title='Monitoramento de uso de Indices.'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-7962459165506669192</id><published>2012-03-19T09:17:00.000-07:00</published><updated>2012-04-01T12:48:39.729-07:00</updated><title type='text'>Dependência entre Funções/Procedures</title><content type='html'>Pessoal

 Segue uma query que me ajuda muito para identificar a dependência 
entre funções/procedures no seu schema.



&lt;b&gt;SELECT UO.OBJECT_NAME,
       UD.NAME
   FROM USER_OBJECTS UO 
   LEFT JOIN USER_DEPENDENCIES UD 
          ON UO.OBJECT_NAME = UD.REFERENCED_NAME
  WHERE UO.OBJECT_TYPE  IN (&#39;FUNCTION&#39;,&#39;PROCEDURE&#39;)
    AND UD.REFERENCED_OWNER = :pSchema
   AND UD.REFERENCED_TYPE IN (&#39;FUNCTION&#39;,&#39;PROCEDURE&#39;)
ORDER BY UO.OBJECT_NAME&lt;/b&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/7962459165506669192/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/03/dependencia-entre-funcoesprocedures.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7962459165506669192'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7962459165506669192'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/03/dependencia-entre-funcoesprocedures.html' title='Dependência entre Funções/Procedures'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-9142761525679650127</id><published>2012-01-18T12:52:00.000-08:00</published><updated>2012-01-23T04:27:14.774-08:00</updated><title type='text'>Analise do seu SGDB com o pacote DBMS_STATS</title><content type='html'>&lt;span style=&quot;font-weight:bold;&quot;&gt;(1) Todo o seu SGDB Oracle (Tabelas e índices)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_database_stats;&lt;br /&gt;&lt;br /&gt;Utilizando somente X % das linhas para definição&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_database_stats(estimate_percent =&amp;gt; 15);&lt;br /&gt;&lt;br /&gt;Utilizando somente X % das linhas para definição e cascade nas estatisticas anteriores.&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_database_stats(estimate_percent =&amp;gt; 15, cascade =&amp;gt; TRUE);&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(2) Apenas um schema&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_schema_stats(&#39;SCOTT&#39;);&lt;br /&gt;EXEC DBMS_STATS.gather_schema_stats(&#39;SCOTT&#39;, estimate_percent =&amp;gt; 15);&lt;br /&gt;EXEC DBMS_STATS.gather_schema_stats(&#39;SCOTT&#39;, estimate_percent =&amp;gt; 15, cascade =&amp;gt; TRUE);&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(3) Apenas uma tabela do seu schema.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_table_stats(&#39;SCOTT&#39;, &#39;EMPLOYEES&#39;);&lt;br /&gt;EXEC DBMS_STATS.gather_table_stats(&#39;SCOTT&#39;, &#39;EMPLOYEES&#39;, estimate_percent =&amp;gt; 15);&lt;br /&gt;EXEC DBMS_STATS.gather_table_stats(&#39;SCOTT&#39;, &#39;EMPLOYEES&#39;, estimate_percent =&amp;gt; 15, cascade =&amp;gt; TRUE);&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;&lt;br /&gt;(4) Atualiação das estatisticas do dicionario de dados (data dictionary).&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_dictionary_stats;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(5) Somente os indices de um schema.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_index_stats(&#39;SCOTT&#39;, &#39;EMPLOYEES_PK&#39;);&lt;br /&gt;EXEC DBMS_STATS.gather_index_stats(&#39;SCOTT&#39;, &#39;EMPLOYEES_PK&#39;, estimate_percent =&amp;gt; 15);&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(6) Atualizar estatistica do System Stats&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_STATS.gather_system_stats;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(7) Outras formas de atualizar estatística (legado)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;ANALYZE TABLE employees COMPUTE STATISTICS;&lt;br /&gt;ANALYZE INDEX employees_pk COMPUTE STATISTICS;&lt;br /&gt;&lt;br /&gt;ANALYZE TABLE employees ESTIMATE STATISTICS SAMPLE 100 ROWS;&lt;br /&gt;ANALYZE TABLE employees ESTIMATE STATISTICS SAMPLE 15 PERCENT;&lt;br /&gt;&lt;br /&gt;EXEC DBMS_UTILITY.analyze_schema(&#39;SCOTT&#39;,&#39;COMPUTE&#39;);&lt;br /&gt;EXEC DBMS_UTILITY.analyze_schema(&#39;SCOTT&#39;,&#39;ESTIMATE&#39;, estimate_rows =&amp;gt; 100);&lt;br /&gt;EXEC DBMS_UTILITY.analyze_schema(&#39;SCOTT&#39;,&#39;ESTIMATE&#39;, estimate_percent =&amp;gt; 15);&lt;br /&gt;&lt;br /&gt;EXEC DBMS_UTILITY.analyze_database(&#39;COMPUTE&#39;);&lt;br /&gt;EXEC DBMS_UTILITY.analyze_database(&#39;ESTIMATE&#39;, estimate_rows =&amp;gt; 100);&lt;br /&gt;EXEC DBMS_UTILITY.analyze_database(&#39;ESTIMATE&#39;, estimate_percent =&amp;gt; 15);&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight:bold;&quot;&gt;(8) Exemplo de criação de job para execução continua de análise.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;SET SERVEROUTPUT ON&lt;br /&gt;DECLARE&lt;br /&gt; l_jobEst  NUMBER;&lt;br /&gt;BEGIN&lt;br /&gt; DBMS_JOB.submit(l_jobEst,&lt;br /&gt;                 &#39;BEGIN DBMS_STATS.gather_schema_stats(&#39;&#39;SCOTT&#39;&#39;); END;&#39;,&lt;br /&gt;                 SYSDATE,&lt;br /&gt;                 &#39;SYSDATE + 1&#39;);&lt;br /&gt; COMMIT;&lt;br /&gt; DBMS_OUTPUT.put_line(&#39;Job: &#39; || l_jobEst);&lt;br /&gt;END;&lt;br /&gt;/&lt;br /&gt;&lt;br /&gt;EXEC DBMS_JOB.remove(X);&lt;br /&gt;COMMIT;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/9142761525679650127/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2012/01/analise-do-seu-sgdb-com-o-pacote.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/9142761525679650127'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/9142761525679650127'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2012/01/analise-do-seu-sgdb-com-o-pacote.html' title='Analise do seu SGDB com o pacote DBMS_STATS'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-4967331252970521663</id><published>2011-12-19T10:30:00.000-08:00</published><updated>2011-12-19T10:50:27.354-08:00</updated><title type='text'>Erro ORA-12899 em Import</title><content type='html'>Hoje tive participei da solução de um problema na execução do comando Imp.exe .No momento do import estávamos recebendo o seguinte erro.&lt;br /&gt;&lt;br /&gt;ORA-12899: valor muito grande para a coluna &quot;schema&quot;.&quot;tabela&quot;.&quot;coluna&quot; (real: 105, máximo: 100).&lt;br /&gt;&lt;br /&gt;Vale a pena observar a seguinte mensagem do log do import :&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;importação realizada nos conjuntos de caracteres WE8MSWIN1252 e NCHAR AL16UTF16&lt;br /&gt;o servidor de importação usa o conjunto de caracteres AL32UTF8 (conversão de charset possível)&lt;br /&gt;&lt;br /&gt;O nosso problema aconteceu pelo fato de o banco de origem ter um charset diferente do banco de destino.Qual a solução que tivemos ?No momento do export.exe devemos dizer o charset que queremos para garantir o import.&lt;br /&gt;&lt;br /&gt;NLS_LANG=&quot;AMERICAN_AMERICA.AL32UTF8&quot;&lt;br /&gt;&lt;br /&gt;fica a dica</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/4967331252970521663/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/12/erro-ora-12899-em-import.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4967331252970521663'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4967331252970521663'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/12/erro-ora-12899-em-import.html' title='Erro ORA-12899 em Import'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-532601470515489487</id><published>2011-10-12T12:26:00.001-07:00</published><updated>2011-10-12T12:26:39.547-07:00</updated><title type='text'>Configuração do modo ARCHIVELOG</title><content type='html'>&lt;div&gt;Configuração do modo ARCHIVELOG&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Para fazermos backups consistentes de um banco de dados Oracle aberto,precisamos que esta instancia esteja&lt;/div&gt;&lt;div&gt;no modo ARCHIVELOG ativado.Com isso conseguimos fazer o chamado BACKUP ON-LINE.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;O Oracle armazena os dados do redo log de forma ciclica.Quando o ultimo arquivo do redo log ativo for &lt;/div&gt;&lt;div&gt;preenchido o processo LGWR (log Write) irá substituir o conteúdo do primeiro arquivo redo.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Se a instancia do banco de dados estiver em modo ARCHIVELOG , o processo ARC (archive) irá fazer uma cópia&lt;/div&gt;&lt;div&gt;redo log depois do processo LGWR terminar de gravar o redo log.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Para fazer uso do modo ARCHIVELOG algumas configurações devem ser feitas.Vamos listar a recomendadas :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;(1) Configure o parametro db_recovery_file_dest&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; ex : log_archive_dest = &#39;c:\app\oracle\arch&#39; &lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;(2) Defina o parametro Log_arquive_dest_n (pelo menos 1 )&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; ex : log_archive_dest_1 = &#39;c:\app\oracle\arch&#39; &lt;/div&gt;&lt;div&gt;      log_archive_dest_2 = &#39;c:\app\oracle\arch\backup&#39;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;  log_archive_dest_3 = &#39;c:\app\oracle\arch\backup\bkp&#39;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;(3) Ative o modo ARCHIVELOG&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;sql&amp;gt; shutdown immediate ;&lt;/div&gt;&lt;div&gt;sql&amp;gt; startup mount&lt;/div&gt;&lt;div&gt;sql&amp;gt; alter database archivelog ;&lt;/div&gt;&lt;div&gt;sql&amp;gt; alter database open ;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/532601470515489487/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/10/configuracao-do-modo-archivelog.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/532601470515489487'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/532601470515489487'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/10/configuracao-do-modo-archivelog.html' title='Configuração do modo ARCHIVELOG'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-3168295386151555697</id><published>2011-09-08T13:16:00.000-07:00</published><updated>2011-09-08T13:37:40.786-07:00</updated><title type='text'>Materialized view</title><content type='html'>&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;São nada mais que objetos do banco de dados Oracle que contém dados locais de tabelas remotas ou são usadas pra criar uma agregação de tabelas em um determinado intervalo de tempo..Segue algumas dicas de uso de uma &lt;b&gt;Materialized View&lt;/b&gt; :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Criação : &lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;create materialized view Minha_mview&lt;/div&gt;&lt;div&gt;&lt;b&gt;refresh [fast | complete | force]&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;start with sysdate&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;next sysdate + 1/24&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;with primary key&lt;/b&gt;&lt;/div&gt;&lt;div&gt;as select * from dba_objects ;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Sendo : &lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;refresh [fast | complete | force]  as opções de refresh da view :&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;Fast = Somente alterações entre o intervalo.&lt;/div&gt;&lt;div&gt;Complete = Recria toda a estrutura da view materializada mesmo que não seja necessário.&lt;/div&gt;&lt;div&gt;Force = Faz o fast de ser for possível,caso contrário faz o processo complete. &lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;start with sysdate : &lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;Data de  primeira populacao da view materializada.&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal; &quot;&gt;&lt;b&gt;next sysdate + 1/24 :&lt;/b&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal; &quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;Data da próxima população da view .&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal; &quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(34, 34, 34); font-family: &#39;Lucida Grande&#39;, &#39;Lucida Sans Unicode&#39;, Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18px; background-color: rgb(255, 255, 255); &quot;&gt;&lt;b&gt;WIDTH PRIMARY KEY :&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(34, 34, 34); font-family: &#39;Lucida Grande&#39;, &#39;Lucida Sans Unicode&#39;, Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18px; background-color: rgb(255, 255, 255); &quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(34, 34, 34); font-family: &#39;Lucida Grande&#39;, &#39;Lucida Sans Unicode&#39;, Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18px; background-color: rgb(255, 255, 255); &quot;&gt;É utilizado para criar a Chave-Primária, que é baseada na chave-primária da tabela master.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(34, 34, 34); font-family: &#39;Lucida Grande&#39;, &#39;Lucida Sans Unicode&#39;, Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18px; background-color: rgb(255, 255, 255); &quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;   &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 18px;&quot;&gt;View para conhecer as Materialized view do seu database :&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;   &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;   &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 18px;&quot;&gt;&lt;div&gt;dba_mviews&lt;/div&gt;&lt;div&gt;dba_mview_refresh_times&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Outros comandos úteis :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Fazer manualmente o refresh fast da MV :&lt;/div&gt;&lt;/span&gt;&lt;/span&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;execute dbms_mview.refresh (&#39;&lt;owner.mv_table&gt;&#39;);&lt;/owner.mv_table&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(34, 34, 34); font-family: &#39;Lucida Grande&#39;, &#39;Lucida Sans Unicode&#39;, Helvetica, Arial, sans-serif; line-height: 18px; white-space: normal; font-size: small; &quot;&gt;Fazer manualmente o refresh Complete da MV :&lt;/span&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;execute dbms_mview.refresh (&#39;&lt;owner.mv_table&gt;&#39;,&#39;C&#39;);&lt;/owner.mv_table&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/pre&gt;&lt;pre class=&quot;qcode&quot; style=&quot;font-family: Arial; font-size: 13px; color: rgb(0, 0, 255); padding-left: 5px; padding-right: 5px; padding-top: 5px; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; margin-right: 10px; &quot;&gt;&lt;/pre&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/3168295386151555697/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/09/materialized-view.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3168295386151555697'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3168295386151555697'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/09/materialized-view.html' title='Materialized view'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-4859335239837267466</id><published>2011-09-06T14:55:00.001-07:00</published><updated>2011-09-06T15:02:45.739-07:00</updated><title type='text'>Create Tablespace</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4jCdIz158pF9pn2eWAjSCLE98wUIyDz8wF-lGsk5Cj4xZd9y9G0bB76vAYb1zDIpG8fHuJM1eDCmv_u7CBskKVNAN45up5vHnioisWYl6H1kk0yENDNDLHP2bEiAZjTwvCNAepsrispGb/s1600/create_tablespace.jpg&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 112px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4jCdIz158pF9pn2eWAjSCLE98wUIyDz8wF-lGsk5Cj4xZd9y9G0bB76vAYb1zDIpG8fHuJM1eDCmv_u7CBskKVNAN45up5vHnioisWYl6H1kk0yENDNDLHP2bEiAZjTwvCNAepsrispGb/s320/create_tablespace.jpg&quot; border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5649368759223125618&quot; /&gt;&lt;/a&gt;Muito importante na criação da sua Tablespace levar em consideração :&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;(1) O volume de informações que serão armazenado nela&lt;/div&gt;&lt;div&gt;(2) O volume de leituras e escritas que estas informações irão receber.&lt;/div&gt;&lt;div&gt;(3) informações sobre disco e armazenamento físico(Velocidade de disco e etc..)&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Digo isso pelo fato de ja ter visto um SGDB oracle com uma tablespace com datafile em um hdb 2.5&#39;&#39; conectado via porta ubs .Um tablespace que era acessada por +- 200 usuários em concorrencia.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Segue um exemplo básico da criação de um tablespace :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;create tablespace TSP_AUDT &lt;/div&gt;&lt;div&gt;            datafile &#39;C:\ORACLE\PRODUCT\11XE\TSP__AUDT.dbf&#39; &lt;/div&gt;&lt;div&gt;            size 128M &lt;/div&gt;&lt;div&gt;           autoextend on &lt;/div&gt;&lt;div&gt;           maxsize 1024M &lt;/div&gt;&lt;div&gt;           extent management local &lt;/div&gt;&lt;div&gt;           uniform size 64K&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;View para obter maiores informações sobre Tablespaces e Datafiles  :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;V$datafile &lt;/div&gt;&lt;div&gt;V$tablespace&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/4859335239837267466/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/09/create-tablespace.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4859335239837267466'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/4859335239837267466'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/09/create-tablespace.html' title='Create Tablespace'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4jCdIz158pF9pn2eWAjSCLE98wUIyDz8wF-lGsk5Cj4xZd9y9G0bB76vAYb1zDIpG8fHuJM1eDCmv_u7CBskKVNAN45up5vHnioisWYl6H1kk0yENDNDLHP2bEiAZjTwvCNAepsrispGb/s72-c/create_tablespace.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-2874246625092590238</id><published>2011-08-03T13:51:00.000-07:00</published><updated>2011-08-03T15:01:08.768-07:00</updated><title type='text'>Memory_Target</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZwdGK6smcK0N3u7Q6ZRFArX4nYWzvk5PuFi_JF1D7SymkaqeMUEcKdCIKqTm_ZEi-G_Qh9W2Zg-BDHxygiOGQ5ZorSZlKT2sPTiqiHZjz4g5vrl_QasVZvlqkwhjHFmdYfG67Oqzhykoy/s1600/memory+target.bmp&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 172px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZwdGK6smcK0N3u7Q6ZRFArX4nYWzvk5PuFi_JF1D7SymkaqeMUEcKdCIKqTm_ZEi-G_Qh9W2Zg-BDHxygiOGQ5ZorSZlKT2sPTiqiHZjz4g5vrl_QasVZvlqkwhjHFmdYfG67Oqzhykoy/s320/memory+target.bmp&quot; border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5636735844786364642&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Com as novas opções do Automatic Memory Management (AMM) do oracle 11g surgiu os novos para metros Memory_max_target eMemory_target.A estrutura dos paramentros de memória ficaram da seguinte forma hierarquica acima mostrada .&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Vale a pena pensar como essa novas opções irão influenciar os parametros PGA_AGGREGATE_TARGET ( chamarei de PAT)  e SGA_TARGET  (chamarei de SGAT)&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Considerando o Memory_Target definido com um valor acima de 0 :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Caso o SGAT e PAT estajam com valores definidos ,o comportamento do oracle será considerar o Memory_Target_max = SGAT + PAT&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Caso SGAT esteja definido e PAT nao esteja definido ,o comportamento do oracle será considerar a PAT = memory_target - SGAT.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Caso SGAT nao esteja definido e PAT esteja definido, o comportamento do oracle será considerar SGA_target inicialmente  min(memory_target - PAT , Sga_max_size) .&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Caso SGAT e PAT nao estejam definidos estes valores serão auto ajustado  para SGAT com  60 % da memory_target e PAT com 40 % da memory_target.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;como estaos meu parametros nesse momento ? Veja com a View abaixo :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Sql &amp;gt; &lt;b&gt;Show Parameter target&lt;/b&gt; ;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/2874246625092590238/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/08/memorytarget.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2874246625092590238'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2874246625092590238'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/08/memorytarget.html' title='Memory_Target'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZwdGK6smcK0N3u7Q6ZRFArX4nYWzvk5PuFi_JF1D7SymkaqeMUEcKdCIKqTm_ZEi-G_Qh9W2Zg-BDHxygiOGQ5ZorSZlKT2sPTiqiHZjz4g5vrl_QasVZvlqkwhjHFmdYfG67Oqzhykoy/s72-c/memory+target.bmp" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-2515753156250672646</id><published>2011-08-02T15:45:00.000-07:00</published><updated>2011-08-02T15:55:22.292-07:00</updated><title type='text'>ADR - Automatic Diagnostic Repository</title><content type='html'>&lt;div&gt;&lt;div&gt;Uma funcionalidade muito útil para um DBA que vejo ser pouco comentada é o ADR.Ele se trata de uma repositório automatico do Oracle (só utilizei na versao 11G) que guarda os log do seu SGDB.&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;Para descobrir as pastas onde ficam os seu log segue um select em uma view :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;&lt;b&gt;Select name,value from v$diag_info ;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Onde podemos considerar :&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home = endereco &lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home/trace - Arquivos que armazenam informações de processos de primeiro e segundo plano.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home/alert - Guarda os logs de alerta no formato XML.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home/trace - Guarda os logs de alerta no formato TXT.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home/cdump - informações sobre dumps de memória.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;adr_home/incident/incdir_n - guarda informamoes sobre dumps de incidentes.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;Existe uma ferramenta chamda ADRCI que você pode chamar pelo terminal do linux ou prompt do DOS que te auxilia a leitura dos arquivos existentes nestas pastas.Essa ferramenta fica para um post futuro.&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/2515753156250672646/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/08/adr-automatic-diagnostic-repository.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2515753156250672646'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/2515753156250672646'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/08/adr-automatic-diagnostic-repository.html' title='ADR - Automatic Diagnostic Repository'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-6698021298627886915</id><published>2011-07-29T12:57:00.000-07:00</published><updated>2011-07-29T13:22:36.589-07:00</updated><title type='text'>Cursor_Sharing</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; &gt;Nesta semana estive diante de um problema de uma aplicação com o uso de &quot;literais&quot; como parametros em alguns select como um exemplo :&lt;/span&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;Select COD_PAIS , DS_PAIS FROM PAISES WHERE COD_CONT = &#39;EU&#39; ;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;Com isso estou com problema de uma queries simples como essa acima ter para cada execução ,um plano de execução em memória no Oracle.Como não é fácil &quot;convencer&quot; a um desenvolvedor que esse tipo de escrita de select não é a melhor e que ao invés de usar uma literal como parâmetro ele poderia utilizar a nossa Bind variable  .Resolvi procurar algo que diminuísse o estrago que estava acontecendo.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;O parâmetro Cursor_Sharing trabalha nessa direção .Ele aceita 3 valores, sendo eles: FORCE, SIMILAR e EXACT.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;b&gt;EXACT&lt;/b&gt; – é o padrão para banco de dados Oracle. O parâmetro EXACT envia ao otimizador do Oracle que toda e qualquer instrução deve ser igual inclusive os valores literais.Este é o parametro do meu SGDB e com isso fico dependendo da boa vontade do desenvolvedor.&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;b&gt;FORCE&lt;/b&gt; – O parâmetro troca as variáveis literais por valores bind, em sua execução, fazendo com que o HARD-PARSE se transforme em SOFT. O valor FORCE no parametro CURSOR_SHARING, gera apenas 1 plano de execução.Porem não consegui identificar em que esta opção pode nos trazer problemas.Pense bem.Se ela fosse livre de riscos ,poque não seria a opção default ??&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;b&gt;SIMILAR&lt;/b&gt; – O parâmetro troca as variáveis literais por valores bind, em sua execução.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;O valor SIMILAR no parametro CURSOR_SHARING, parece agir da mesma forma que o valor FORCE,mas diferente do FORCE , o SIMILAR gera mais de um plano de execução (se a tabela estiver com a coleta de estatísticas atualizada).&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;div&gt;O &lt;b&gt;CURSOR_SHARING&lt;/b&gt; é um cara meio problemático. Se você fizer uma busca no&lt;/div&gt;&lt;div&gt;Metalink, vai ver vários problemas associados. Quando migramos para o 11g&lt;/div&gt;&lt;div&gt;onde eu trabalho, houve um ORA-0600 .Porem ,pode ser uma alternativa.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/6698021298627886915/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/cursorsharing.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6698021298627886915'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/6698021298627886915'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/cursorsharing.html' title='Cursor_Sharing'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-3532465962654385666</id><published>2011-07-13T11:09:00.000-07:00</published><updated>2011-07-13T11:13:00.714-07:00</updated><title type='text'>Lista de Processos Oracle em Execução na Instancia</title><content type='html'>Segue uma query para descobrirmos a lista de Processos Oracle em Execução na Instancia :&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;Select Sid,Serial#,Process,Name,Description&lt;/div&gt;&lt;div&gt;From V$session Ss&lt;/div&gt;&lt;div&gt;  Join V$bgprocess Bg &lt;/div&gt;&lt;div&gt;    On Bg.Paddr = Ss.Paddr&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/3532465962654385666/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/lista-de-processos-oracle-em-execucao.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3532465962654385666'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/3532465962654385666'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/lista-de-processos-oracle-em-execucao.html' title='Lista de Processos Oracle em Execução na Instancia'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8518548532118031835.post-7758266515649646826</id><published>2011-07-05T06:28:00.000-07:00</published><updated>2011-07-05T06:34:38.592-07:00</updated><title type='text'>Forma rápida de Eliminar Sessões Maléficas</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot;  &gt; Todos nós conhecemos a opção do commando &quot;KILL&quot;muito utilizado para eliminar sessões maléficas ou incoerentes num database.Mas que não executou um Kill numa sessão e depois disso recebe a seguinte resposta &lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;“session market for kill”&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;  e esta sessão continua por um determinado período perturbando ? Isto acontece porque existe toda um controle do Oracle para confirmar que realmente a sessão pode ser morta .&lt;/span&gt;&lt;/span&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;  Em contato com algums DBA venho vendo que um alternativa muito interessante vem sendo o uso do commando disconnect para estas sessões como no exemplo abaixo :&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;SQL&amp;gt; ALTER SYSTEM DISCONNECT SESSION &lt;b&gt;‘sid,serial#’&lt;/b&gt; IMMEDIATE;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;a Opção immediate pode ser modificada pela opção &lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;POST_TRANSACTION (esperar o fim da Transação corrente).Em momentos críticos ,pode ser um alternativa ao Kill Session .&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;  &gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 21px; &quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://oracle-startup.blogspot.com/feeds/7758266515649646826/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/forma-rapida-de-eliminar-sessoes.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7758266515649646826'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8518548532118031835/posts/default/7758266515649646826'/><link rel='alternate' type='text/html' href='http://oracle-startup.blogspot.com/2011/07/forma-rapida-de-eliminar-sessoes.html' title='Forma rápida de Eliminar Sessões Maléficas'/><author><name>Bruno Moreira</name><uri>http://www.blogger.com/profile/09665544790338702684</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYkBXQ67ww4ZP4xdPgK9mR68RPo0rk2x0I_LN8Q3r2QuBMJjU3erxgu-mlN326--y1grXdwo7ZtDOkp5ah0DNiojcg7o5j0hBFQj4bPiZ-Xm434cxn6_rdVmIrQhAdw/s220/bruno.jpg'/></author><thr:total>0</thr:total></entry></feed>