If you are trying to grant execute on a package and getting ORA-04021 'timeout occurred while`
waiting to lock object' try the following:
Check who else is using the packages:
SQL> select * from v$access where object = 'PACKAGE_NAME';
If you see another session accessing the package ask the user to logout or kill them.
Alternatively you can try:
SQL> alter system flush shared_pool;
Good Luck !
waiting to lock object' try the following:
Check who else is using the packages:
SQL> select * from v$access where object = 'PACKAGE_NAME';
If you see another session accessing the package ask the user to logout or kill them.
Alternatively you can try:
SQL> alter system flush shared_pool;
Good Luck !
No comments:
Post a Comment