Home » Developer & Programmer » Forms » Got Error ORA-00028 When Form 6i's Process Going on (merged)
icon8.gif  Got Error ORA-00028 When Form 6i's Process Going on (merged) [message #245855] Tue, 19 June 2007 01:29 Go to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Dear all,
In my developement environment, There is D2K 6i Form. Which contain long process. In execution of this form, many time I got following error.
"ORA-00028 Your Session has been killed."
So how can I remove error from this form.
Due to this error all users have to login again, and again have to repet same process.
So please help me step by step process to solve problem.
Also let me know, is it D2k 6i side problem or Oracle 9i Database side?

Thanks
Brijal
Re: ORA-00028 Error come when use perticular Form [message #245858 is a reply to message #245855] Tue, 19 June 2007 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not an error.
Your DBA seems to estimate your process last too long and has killed your session.

Regards
Michel
icon5.gif  Re: ORA-00028 Error come when use particular Form [message #245867 is a reply to message #245858] Tue, 19 June 2007 01:59 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Thanks Michal,
I got this error in only one form. And it is too important form contain sales transaction.
So can u suggest any steps at server side like Increase memory or other steps.
Regards
Brijal
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245879 is a reply to message #245855] Tue, 19 June 2007 02:46 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
see configuration of profile DEFAULT and the profile which have uses. Possible that due to setting of profile, session cannot exists more that some period of time, or cannot consume more that some number of CPU units.
Re: ORA-00028 Error come when use particular Form [message #245882 is a reply to message #245867] Tue, 19 June 2007 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to not kill the session.
Nothing to do with server or parameters.

Regards
Michel

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245886 is a reply to message #245879] Tue, 19 June 2007 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When it is a disconnection from profile the message is:
Quote:
exceeded session limit on ... usage, you are being logged off

and not
Quote:
Your Session has been killed

ora-00028: your session has been killed
 *Cause:  A privileged user has killed your session and you are no longer
          logged on to the database.
 *Action: Login again if you wish to continue working.

Regards
Michel
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245890 is a reply to message #245886] Tue, 19 June 2007 03:08 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
1)If You make audit of connections, You can see audit logs from sys.aud$. This can help.
2)You can start trace on your session. And You will see fix point when Your connection are killed and what he are executing.
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245902 is a reply to message #245879] Tue, 19 June 2007 03:44 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
I check Profile in Enterprice Manager of ORACLE 9i Database. There is only one Profile in Database "DEFAULT" and it has all values set to "UNLIMITED".
So now what can be reason? Do I have to changes in server like Increase RAM or etc? Currently On server there is 1GM RAM.
Regards
Brijal
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245907 is a reply to message #245902] Tue, 19 June 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


FOR THE FOURTH TIME:
THE REASON IS THAT YOUR DBA HAS KILLED YOUR SESSION(S).


Regards
Michel
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #246097 is a reply to message #245907] Tue, 19 June 2007 22:08 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Thank michal,
U r right. But here i am DBA of Server. So I have to take some action to solv this problem. Only one form get this type of error. all other forms work very fine.
Regards
Brijal
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #247187 is a reply to message #246097] Mon, 25 June 2007 00:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How long is your form running before this happens? I suggest you review the code in the Form and fix the performance issue that is giving rise to the long response time.

David
Re: Got Error ORA-00028 When Form 6i's Process Going on [message #247193 is a reply to message #247187] Mon, 25 June 2007 00:39 Go to previous message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
thanks djmartin for reply

After user click on Save button, too many time pass and form will remain "Not Responding" at that time. and few time it will done but many time error come.

This form will update many tables, also insert many records. So I think u r right. I start reviewing that form and let see I can reduce Database round trip. Then i will tell u

Reagrds
Previous Topic: PDE-PER001 Internal error (scaba 18)
Next Topic: how use loop in from for two block
Goto Forum:
  


Current Time: Sun Dec 11 03:58:33 CST 2016

Total time taken to generate the page: 0.08520 seconds