{"id":176651,"date":"2024-07-05T13:04:36","date_gmt":"2024-07-05T16:04:36","guid":{"rendered":"https:\/\/www.profissionaloracle.com.br\/?p=176651"},"modified":"2024-07-05T18:51:40","modified_gmt":"2024-07-05T21:51:40","slug":"utl_recomp-o-salvador-dos-objetos-invalidos-no-oracle","status":"publish","type":"post","link":"https:\/\/www.profissionaloracle.com.br\/2024\/07\/05\/utl_recomp-o-salvador-dos-objetos-invalidos-no-oracle\/","title":{"rendered":"UTL_RECOMP: O Salvador dos Objetos Inv\u00e1lidos no Oracle"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">UTL_RECOMP: O Salvador dos Objetos Inv\u00e1lidos no Oracle<\/h3>\n\n\n\n<p>Bem-vindos, administradores de banco de dados e entusiastas de PL\/SQL! Hoje, vamos explorar um pacote essencial para qualquer DBA Oracle: o <strong>UTL_RECOMP<\/strong>. Este pacote \u00e9 a ferramenta ideal para recompilar objetos inv\u00e1lidos no seu banco de dados Oracle, especialmente ap\u00f3s atualiza\u00e7\u00f5es ou mudan\u00e7as significativas que podem causar a invalida\u00e7\u00e3o de objetos dependentes.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">UTL_RECOMP: A Solu\u00e7\u00e3o para Objetos Inv\u00e1lidos<\/h4>\n\n\n\n<p>Primeiro, vamos entender o que faz o <strong>UTL_RECOMP<\/strong>. Esse pacote PL\/SQL permite recompilar todos os objetos inv\u00e1lidos no banco de dados de maneira eficiente. Antes de sua exist\u00eancia, a recompila\u00e7\u00e3o manual de objetos inv\u00e1lidos era um processo tedioso e propenso a erros. Agora, com <strong>UTL_RECOMP<\/strong>, podemos automatizar e agilizar essa tarefa.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Requisitos de Permiss\u00e3o<\/h4>\n\n\n\n<p>Para utilizar o <strong>UTL_RECOMP<\/strong>, \u00e9 necess\u00e1rio possuir certas permiss\u00f5es. As roles necess\u00e1rias para executar o <strong>UTL_RECOMP<\/strong> s\u00e3o:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DBA<\/strong>: Para recompilar objetos em todo o banco de dados.<\/li>\n\n\n\n<li><strong>EXECUTE_CATALOG_ROLE<\/strong>: Para executar o pacote <strong>UTL_RECOMP<\/strong>.<\/li>\n\n\n\n<li><strong>SELECT ANY DICTIONARY<\/strong>: Para selecionar a partir de qualquer dicion\u00e1rio de dados.<\/li>\n<\/ul>\n\n\n\n<p>Al\u00e9m disso, o usu\u00e1rio deve ter permiss\u00e3o para executar a fun\u00e7\u00e3o espec\u00edfica do pacote. Abaixo est\u00e3o os exemplos de como conceder essas permiss\u00f5es:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"GRANT DBA TO &lt;usuario&gt;;\nGRANT EXECUTE_CATALOG_ROLE TO &lt;usuario&gt;;\nGRANT SELECT ANY DICTIONARY TO &lt;usuario&gt;;\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">GRANT<\/span><span style=\"color: #D8DEE9FF\"> DBA <\/span><span style=\"color: #81A1C1\">TO<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&lt;<\/span><span style=\"color: #D8DEE9FF\">usuario<\/span><span style=\"color: #81A1C1\">&gt;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">GRANT<\/span><span style=\"color: #D8DEE9FF\"> EXECUTE_CATALOG_ROLE <\/span><span style=\"color: #81A1C1\">TO<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&lt;<\/span><span style=\"color: #D8DEE9FF\">usuario<\/span><span style=\"color: #81A1C1\">&gt;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">GRANT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> ANY DICTIONARY <\/span><span style=\"color: #81A1C1\">TO<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&lt;<\/span><span style=\"color: #D8DEE9FF\">usuario<\/span><span style=\"color: #81A1C1\">&gt;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Uso B\u00e1sico do UTL_RECOMP<\/h4>\n\n\n\n<p>Vamos come\u00e7ar com um exemplo simples de como utilizar o <strong>UTL_RECOMP<\/strong>. Suponha que voc\u00ea realizou uma atualiza\u00e7\u00e3o no banco de dados e agora possui alguns procedimentos e pacotes inv\u00e1lidos. Vamos corrigir isso rapidamente.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Passo 1: Criando um Objeto Exemplo<\/h5>\n\n\n\n<p>Primeiro, vamos criar um procedimento simples:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"CREATE OR REPLACE PROCEDURE simple_procedure AS\nBEGIN\n    DBMS_OUTPUT.PUT_LINE('Ol\u00e1, mundo!');\nEND;\n\/\n\nProcedure created.\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROCEDURE<\/span><span style=\"color: #D8DEE9FF\"> simple_procedure <\/span><span style=\"color: #81A1C1\">AS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">BEGIN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    DBMS_OUTPUT.PUT_LINE(<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Ol\u00e1, mundo!<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">END<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">\/<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">Procedure<\/span><span style=\"color: #D8DEE9FF\"> created.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Passo 2: Invalida\u00e7\u00e3o do Objeto<\/h5>\n\n\n\n<p>Imagine que, ap\u00f3s uma atualiza\u00e7\u00e3o no banco de dados, este procedimento ficou inv\u00e1lido. Para resolver isso, utilizamos o <strong>UTL_RECOMP<\/strong>.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Passo 3: Recompilando Objetos<\/h5>\n\n\n\n<p>Podemos recompilar todos os objetos inv\u00e1lidos no banco de dados de forma sequencial:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"EXEC UTL_RECOMP.recomp_serial();\n\nPL\/SQL procedure successfully completed.\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">EXEC<\/span><span style=\"color: #D8DEE9FF\"> UTL_RECOMP.recomp_serial<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">PL<\/span><span style=\"color: #81A1C1\">\/SQL<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">procedure<\/span><span style=\"color: #D8DEE9FF\"> successfully completed.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Passo 4: Verifica\u00e7\u00e3o<\/h5>\n\n\n\n<p>Ap\u00f3s executar o <strong>UTL_RECOMP<\/strong>, verifique o status do objeto para garantir que ele est\u00e1 v\u00e1lido novamente:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT object_name, status FROM user_objects WHERE object_name = 'SIMPLE_PROCEDURE';\n\nOBJECT_NAME                    STATUS\n------------------------------ -------\nSIMPLE_PROCEDURE               VALID\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> object_name, <\/span><span style=\"color: #81A1C1\">status<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> user_objects <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> object_name <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">SIMPLE_PROCEDURE<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">OBJECT_NAME                    <\/span><span style=\"color: #81A1C1\">STATUS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">------------------------------ -------<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">SIMPLE_PROCEDURE               VALID<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Se tudo correu bem, o status deve ser &#8216;VALID&#8217;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Exemplos Complexos de Uso do UTL_RECOMP<\/h4>\n\n\n\n<p>Agora, vamos ver um exemplo mais complexo, onde recompilamos objetos em um esquema inteiro. Isso \u00e9 especialmente \u00fatil em ambientes grandes onde m\u00faltiplos objetos podem ficar inv\u00e1lidos ap\u00f3s uma atualiza\u00e7\u00e3o de sistema.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Recompilando um Esquema Inteiro<\/h5>\n\n\n\n<p>Primeiro, vamos criar um pacote e seu corpo:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"CREATE OR REPLACE PACKAGE example_package AS\n    PROCEDURE example_procedure;\nEND example_package;\n\/\n\nCREATE OR REPLACE PACKAGE BODY example_package AS\n    PROCEDURE example_procedure AS\n    BEGIN\n        DBMS_OUTPUT.PUT_LINE('Exemplo de procedimento');\n    END example_procedure;\nEND example_package;\n\/\n\nPackage created.\n\nPackage body created.\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> PACKAGE example_package <\/span><span style=\"color: #81A1C1\">AS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">PROCEDURE<\/span><span style=\"color: #D8DEE9FF\"> example_procedure;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">END<\/span><span style=\"color: #D8DEE9FF\"> example_package;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">\/<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">REPLACE<\/span><span style=\"color: #D8DEE9FF\"> PACKAGE BODY example_package <\/span><span style=\"color: #81A1C1\">AS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">PROCEDURE<\/span><span style=\"color: #D8DEE9FF\"> example_procedure <\/span><span style=\"color: #81A1C1\">AS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">BEGIN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">        DBMS_OUTPUT.PUT_LINE(<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Exemplo de procedimento<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">END<\/span><span style=\"color: #D8DEE9FF\"> example_procedure;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">END<\/span><span style=\"color: #D8DEE9FF\"> example_package;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">\/<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Package created.<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">Package body created.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Ap\u00f3s uma grande atualiza\u00e7\u00e3o, v\u00e1rios objetos podem ficar inv\u00e1lidos. Vamos recompilar todos os objetos de um esquema espec\u00edfico utilizando o <strong>UTL_RECOMP<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"EXEC UTL_RECOMP.recomp_parallel(schema =&gt; 'EXAMPLE_SCHEMA', degree =&gt; 8);\n\nPL\/SQL procedure successfully completed.\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">EXEC<\/span><span style=\"color: #D8DEE9FF\"> UTL_RECOMP.recomp_parallel(<\/span><span style=\"color: #81A1C1\">schema<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=&gt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">EXAMPLE_SCHEMA<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">, degree <\/span><span style=\"color: #81A1C1\">=&gt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">8<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">PL<\/span><span style=\"color: #81A1C1\">\/SQL<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">procedure<\/span><span style=\"color: #D8DEE9FF\"> successfully completed.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Este comando recompilar\u00e1 todos os objetos inv\u00e1lidos no esquema &#8216;EXAMPLE_SCHEMA&#8217; utilizando 8 processos paralelos. Ap\u00f3s a recompila\u00e7\u00e3o, verifique se todos os objetos est\u00e3o v\u00e1lidos:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:1rem;font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">SQL<\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT object_name, status FROM dba_objects WHERE owner = 'EXAMPLE_SCHEMA' AND status = 'INVALID';\n\nno rows selected\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> object_name, <\/span><span style=\"color: #81A1C1\">status<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_objects <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">owner<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">EXAMPLE_SCHEMA<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AND<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">status<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">INVALID<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">no<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">rows<\/span><span style=\"color: #D8DEE9FF\"> selected<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Se n\u00e3o houver resultados, parab\u00e9ns! Todos os objetos no esquema est\u00e3o v\u00e1lidos novamente.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Conclus\u00e3o<\/h4>\n\n\n\n<p>O <strong>UTL_RECOMP<\/strong> \u00e9 uma ferramenta indispens\u00e1vel para qualquer DBA Oracle. Ele simplifica e acelera a tarefa de recompilar objetos inv\u00e1lidos, garantindo que o banco de dados funcione de maneira otimizada e sem problemas. Utilizando o <strong>UTL_RECOMP<\/strong> regularmente, voc\u00ea pode manter seu ambiente de banco de dados em perfeito estado, mesmo ap\u00f3s grandes atualiza\u00e7\u00f5es ou modifica\u00e7\u00f5es.<\/p>\n\n\n\n<p>Explore e utilize essa poderosa ferramenta, e mantenha seu banco de dados sempre em plena forma. Afinal, um banco de dados bem gerido \u00e9 fundamental para o sucesso de qualquer organiza\u00e7\u00e3o.<\/p>\n\n\n\n<p>Valeuuuuu !<\/p>\n\n\n\n<p><strong>Refer\u00eancias<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/arpls\/UTL_REF.html#GUID-DC7D405F-4A1A-45C8-A282-C12C5B5CAEA3\" target=\"_blank\" rel=\"noreferrer noopener\">PL\/SQL Packages and Types Reference &#8211; UTL_REF<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Descubra como o UTL_RECOMP pode ser o salvador de DBAs Oracle ao recompilar objetos inv\u00e1lidos de forma eficiente e automatizada.<\/p>\n","protected":false},"author":21995,"featured_media":171408,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"[\"content\",\"tags\",\"related-posts\",\"comments\",\"post-navigation\"]","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[6,7,19],"tags":[1581,222,2767,177,5759],"class_list":["post-176651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-artigos","category-artigo-bancodedados","category-oracle","tag-bd","tag-dba","tag-iniciante","tag-oracle","tag-utl_recomp"],"publishpress_future_action":{"enabled":false,"date":"2025-03-17 21:41:29","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category"},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/posts\/176651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/users\/21995"}],"replies":[{"embeddable":true,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/comments?post=176651"}],"version-history":[{"count":0,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/posts\/176651\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/media\/171408"}],"wp:attachment":[{"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/media?parent=176651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/categories?post=176651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.profissionaloracle.com.br\/wp-json\/wp\/v2\/tags?post=176651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}