| PLS-00123 [message #179150] |
Mon, 26 June 2006 01:32  |
h_shikha
Messages: 4
Registered: June 2006
Location: India
|
Junior Member |
|
|
Hi,
Database that I maintain is on Oracle 8.1.7 on Unix.
Out of the blue I have started getting the following error whenever I try to execute a particular procedure.
ORA-06550: line 1, column 1:
PLS-00123: program too large
No change has been made to this procedure at all and it had been working fine all these days.
I have no clue why suddenly it has started giving the above error. Any help on this one would be highly appreciated.
I have gone through many other sites(AskTom,Metalink) but there my understanding is one gets the above error due to limitations to the parsed tree size.
But I dont think that would apply in my case as all these days this procedure was executing absolutely fine and now its giving the error even when we have made no changes to it.
Thanks & Rgds,
Shikha
|
|
|
|
| Re: PLS-00123 [message #179155 is a reply to message #179150] |
Mon, 26 June 2006 02:18  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
|
I think that this is due to big segmentation of your shared pool. This can happen if there no continuous free memory, needed by your program. I can supose, that during weekend there was not so much workload in your database, and shared pool was free, but today things are changed.
|
|
|
|
| Re: PLS-00123 [message #179184 is a reply to message #179155] |
Mon, 26 June 2006 04:39 |
h_shikha
Messages: 4
Registered: June 2006
Location: India
|
Junior Member |
|
|
thanks for the reply but i had restarted the database in the hope of sorting out this problem.
Restarting the database does clean up the memory and should make the memory blocks contigious. But I am still facing the same problem.
|
|
|
|
|
|
| Re: PLS-00123 [message #179194 is a reply to message #179150] |
Mon, 26 June 2006 05:24 |
h_shikha
Messages: 4
Registered: June 2006
Location: India
|
Junior Member |
|
|
Hia,
sorry since its a production database I cannot restart it now, got the database restarted over the weekend.
meanwhile i am trying to figure out the shared_pool size.
Also any suggestions for the best way to figure out how badly the shared pool is fragmented ?
I got a script from net but the result is not very understanable.
|
|
|
|
|
|
| Re: PLS-00123 [message #179202 is a reply to message #179194] |
Mon, 26 June 2006 05:58 |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
I am find at metalink some information about this error and find some interesting. My version about small shared pool seems to be incorrect. See the doc.(About your size of shared pool - my shred pool have 380MB  and i think that at one day it will be small).
Metalink docuemnts are Proprietory to Oracle Corporation.
Attachment removed
[Updated on: Mon, 26 June 2006 06:35] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
