• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Posts tagged "compile"

Tag Archives: compile

How to recompile a PL/SQL package locked by another user

Posted on March 8, 2013 by Garth

I’ve hit this problem a couple of times lately where a developer is trying to recompile a PL/SQL package and their session hangs until  they eventually get this error: SQL> @new_pkg CREATE OR REPLACE PACKAGE BODY test_package * ERROR at line 1: ORA-04021: timeout occurred while waiting to lock object Basically, whilst someone or something else (a

Read More…

Posted in Database, General | Tags: compile, lock, package, timeout | 19 Comments |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
Copyright © 2020 SnapDBA.com