| cannot recompile package after a hang up compilation (merged) [message #427165] |
Wed, 21 October 2009 06:54  |
angelica
Messages: 7
Registered: October 2009
|
Junior Member |
|
|
We have a problem with a recompilation package.
4 days ago, we tried to recompile it because we did some changes but during the compilation there was a job execution pending associated with this package and our toad aplication just hang up. No messages, couldn't do anything, so we killed the toad process and turn it on again. We called the oracle administrator to killed all the sesions pending and he did it.
Afterwards we tried to compile it and it did nothing. The administrator said that there wasn't any object blocking it so it should compile but we couldn't manage to recompile it.
We have rename the package and compile it and change the public synonym to point to the new one. Everything worked.
Now we have recompile the old one, because no one is using it. there are no dependencies, but still doing the same thing, hangs up and doesn't recompile.
It seems like something in some part of oracle memory still doing something but it doesn't show it to the administrator.
Do you know how to solve the problem, so we have not to shut down the database to make it work it again?
Is there any bug in this version, that could provoke this?
Thanks for your advice.
|
|
|
|
|
|
|
|
| Re: cannot recompile package after a hang up compilation (merged) [message #427247 is a reply to message #427196] |
Wed, 21 October 2009 11:39  |
angelica
Messages: 7
Registered: October 2009
|
Junior Member |
|
|
What do you mean by some days?
The administrator said to me that he had killed all the active sesions and also killed not active sessions.
This happened on friday 24th of october.
Is it possible that it can be a "hidden session" pending since then, and the administrator is not able to see it?
We know that this issue occured again a month ago with another package. At that time, they stopped the database and opened it again. After that, they could recompile it again.
But this time we are trying to find a better solution, because stopped the database is not a good policy in these cases.
Thanks for the advice.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: cannot recompile package after a hang up compilation (merged) [message #427260 is a reply to message #427256] |
Wed, 21 October 2009 12:09 |
angelica
Messages: 7
Registered: October 2009
|
Junior Member |
|
|
BlackSwan wrote on Wed, 21 October 2009 19:01>The administrator said to me that he had killed all the active sesions and also killed not active sessions.
What is Operating System (OS) name & version?
Oracle 10.2.0.4.
If admin were 100% correct, you would be able to compile code?
select machine, program, trunc(logon_time), count(*) from v$session
where username <> 'oracle'
group by machine, program, trunc(logon_time)
/
I would post the result of the query tomorrow because I don't have permission por sys user. I'll ask the administrator.
post results from SQL above
|
|
|
|
|
|
|
|
|
|
| Re: cannot recompile package after a hang up compilation (merged) [message #427335 is a reply to message #427268] |
Thu, 22 October 2009 02:09 |
angelica
Messages: 7
Registered: October 2009
|
Junior Member |
|
|
Sorry if I my last answer seem unkind. I didn't want to transmit that. I didn't know that the operating system was important for this matter.
I'll start from the beginning.
I'm a developer and the database administrator told me to try to find an answer to our problem.
Well, I asked him from the version of the operating system and this is it:
AIX 5.3
|
|
|
|
| Re: cannot recompile package after a hang up compilation (merged) [message #427350 is a reply to message #427335] |
Thu, 22 October 2009 03:11 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
1) Have a look at v$access - see if any sessions have been using the package you're trying to recompile.
2) When you try to recompile the package, and it hangs, have a look at DBA_BLOCKERS to see which session is blocking you, and also at v$session_wait, which will tell you what the compiling session is waiting for.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
