SnapDBA
  • 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 "package"

Tag Archives: package

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

  • Using SQL Developer to connect to SQL Server databases
  • Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4
  • SSH X-11 forwarding and magic cookies
  • How to recompile a PL/SQL package locked by another user
  • DBMS_SCHEDULER jobs running an hour late - DST/BST 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 © 2018 SnapDBA.com
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OKPrivacy policy