problem in login the oracle user [message #294643] |
Fri, 18 January 2008 05:01 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi Experts,
When i am login in to oracle through test/test123 it is login to oracle.
But when i want to login through application then i am not able to login.
At the same time the trace file is starts to create untill i will not kill the session. And those trace files are upto 10G also.
Please let me know what might be the reason behind it?
Thanks in advacne.
|
|
|
|
|
Re: problem in login the oracle user [message #294691 is a reply to message #294671] |
Fri, 18 January 2008 08:09 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I got the query while login to application.
When i execute this query I got the following error.
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)
Please help on this.
I do not know anything about this error.
Thanks in advance.
|
|
|
|
|
Re: problem in login the oracle user [message #294762 is a reply to message #294695] |
Sat, 19 January 2008 00:55 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I am using Oracle Release 10.2.0.1.0 vesrion.
Actually everything is working fine from last 1.5 years.
Every parameter is set as per needs.
Its strange to me that this error comes.
Please explain me in details if anyone has information.
Quote: |
*Cause: Operating system process private memory has been exhausted
|
What need to do for this?
Please let me know.
Thanks in advance.
|
|
|
|
Re: problem in login the oracle user [message #294767 is a reply to message #294643] |
Sat, 19 January 2008 01:22 |
mkbhati
Messages: 93 Registered: February 2007 Location: Mumbai
|
Member |
|
|
Dear Ora_2007 Please post maximum details & following in particular. This will indeed help forum members to arrive on some conclusion.
(a) OS & Oracle Version
(b) Program being used for connection e.g sqlplus / custom application.
(c) if custom application than, provider version/platform being used
(d) Full error message [do not hide any thing]
(e) Connecting from local or remote system
(f) any other information which you think may help in pin pointing the cause.
Regards
Manjit Kumar [mkbhati]
|
|
|
Re: problem in login the oracle user [message #294769 is a reply to message #294643] |
Sat, 19 January 2008 01:24 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Thanks Michel for your reply,
oracle@me:~> ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
I tried to increase pga_aggregate_target by 100m
Kept Decrease sort_area_size and/or hash_area_size as it is.
But not useful.
pga_aggregate_target = 755M Previously 655M
sort_area_size = 65536 Bytes
hash_area_size = 131072 Bytes
Is any other information is required.
I got the following error for only one oracle user for other useres everything fine.
Please help me.
Thanks in advance.
|
|
|
Re: problem in login the oracle user [message #294771 is a reply to message #294643] |
Sat, 19 January 2008 01:27 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
More information
1. OS - UNIX
2. Oracle Release 10.2.0.1.0 vesrion.
3. sqlplus Demo/Demo
4. Connection from the aplication developed in ASP.
SELECT id
, name
, viewfunc.fGetLeadAndTestCountCampaign(id) LEADCOUNT ,
ROUND(DECODE(viewfunc.fGetLeadCountDeliveredNW(id),0,0,
viewfunc.fGetLeadCountResponse(id)/viewfunc.fGetLeadCountDeliveredNW(id)*100),2) RESPONSEPCT ,
viewfunc.fGetLeadCountResponse(id) RESPONSECOUNT ,
ROUND(DECODE(viewfunc.fGetLeadCountDelivered(id),0,0,
viewfunc.fgetleadcountopened(id)/viewfunc.fGetLeadCountDelivered(id)*100),2) OPENED ,
ROUND(DECODE(viewfunc.fgetleadcountopened(id),0,0,
viewfunc.fGetLeadCountResponse(id)/viewfunc.fgetleadcountopened(id)*100),2) CTROR
FROM CAMPAIGN WHERE id IN
( SELECT * FROM (
SELECT a.id FROM DEMO.CAMPAIGN a LEFT OUTER JOIN DEMO.iv_survey e ON a.id=e.campaign_id ,
DEMO.users b ,
DEMO.campaignstatus c ,
DEMO.campaigntype d
WHERE a.client_id = b.client_id
AND b.dbusername=USER AND a.campaignstatus_id=c.id
AND a.campaigntype_id=d.id
AND (viewfunc.fhascampaignright(a.id)=1
OR viewfunc.fhascampaignrightstat(a.id)=1)
AND a.launcheddate IS NOT NULL
AND c.internalname = 'LAUNCHED'
AND a.archiveddate IS NULL
AND viewfunc.fcampaignvisible(a.campaignfolder_id)=1
ORDER BY a.launcheddate DESC )
WHERE ROWNUM < 6 )
ORDER BY syscreated DESC
Error message is
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)
ORA-06512: at "DEMO.VIEWFUNC", line 1471
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512:
[Updated on: Sat, 19 January 2008 01:44] by Moderator Report message to a moderator
|
|
|
|
|
|
|
Re: problem in login the oracle user [message #294780 is a reply to message #294777] |
Sat, 19 January 2008 01:48 |
|
Michel Cadot
Messages: 68686 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Each day I buy 10 candies and give 2 to each of my 5 children.
It has been working for years.
Now I have 6 children, why I can't give 2 candies of them?
You call too many functions in your query.
Check your functions, check the space they allocate.
You think you can do it in minutes, no it will take weeks.
Regards
Michel
[Updated on: Sat, 19 January 2008 01:49] Report message to a moderator
|
|
|
Re: problem in login the oracle user [message #294791 is a reply to message #294643] |
Sat, 19 January 2008 04:12 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi Experts,
I got the cause of the problem.
The reason for the ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)
was because there was recursive call into the DEMO.VIEWFUNC function.
Thats why there was consumption of lot of memory.
Thanks for your time given to help me.
|
|
|
|
|