• 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 » Archive for category "Database" ( » Page 2)

Category Archives: Database

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 |

How to check which PSU is installed…if any

Posted on October 10, 2012 by Garth

How to check which PSU is installed…if any Oracle PSUs (Patch Set Updates) are referenced by their 5-place version number.  Unfortunately they do not change version numbers in the Oracle binaries, product banners and such though (see MOS 861152.1), so here’s how to identify which PSU your ORACLE_HOME is at… Database Server: To check the Oracle

Read More…

Posted in Enterprise Manager, General, WebLogic Server | Tags: psu, version | 5 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
  • Prev
  • 1
  • 2
Copyright © 2020 SnapDBA.com