Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
ORA-04021: timeout occurred while waiting to lock object

784227
Member Posts: 344
Hi,
DB 10.2.0.4
while trying to compile a package getting below error on every time,Ther are no locking.
ORA-04021: timeout occurred while waiting to lock object
Thanks
DB 10.2.0.4
while trying to compile a package getting below error on every time,Ther are no locking.
ORA-04021: timeout occurred while waiting to lock object
Thanks
Best Answer
-
The package was in use. There are a couple of ways to find who is using a package at any given moment.
You can join v$session to dba_ddl_locks or you can use v$acess but you can see who is executing the package. The code cannot be recompiled while the code is in use.
HTH -- Mark D Powell --
Answers
-
The package was in use. There are a couple of ways to find who is using a package at any given moment.
You can join v$session to dba_ddl_locks or you can use v$acess but you can see who is executing the package. The code cannot be recompiled while the code is in use.
HTH -- Mark D Powell -- -
Hi;
For can root cause please see:
How to analyze ORA-04021 or ORA-4020 errors? [ID 169139.1]
Hope it helps
Regard
Helios -
Hi,
Thanks for reply.
There are two session id which are access same package in dba_ddl_locks, do i need to kill that session id?
Thanks -
do i need to kill that session id?I would first try to find out, WHO is behind this id.
-
It would have been nice if you had posted your query and results so we could make suggestions on how to improve the query or what you should check next.
Generally speaking if you submit a create or replace on a package and it takes longer than expected you can open a second session and query for usage. Depending on what you find determines your action.
If may be you just need to re-submit immediately or wait till a batch job completes. There could be a daemon (continuously running batch) job that you have stopped and re-started right after you make the change. It depends on your environment.
HTH -- Mark D Powell --
This discussion has been closed.