OraFAQ Forum: SQL & PL/SQL » ORACLE Instance Terminate

Home » SQL & PL/SQL » SQL & PL/SQL » ORACLE Instance Terminate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE Instance Terminate [message #2566]

Fri, 26 July 2002 21:39

Velu Natarajan
Messages: 16
Registered: July 2002

Junior Member

Dear Sir/Madam
We handle large volume of data in oracle database. when processing utilization was high Oracle Instance Terminate very ofen. As the solution we
reduced the No. of user as 20 and Server Configuration was also upgraded to
HD - 56GB
RAM - 1 GB
Processor - PIII - 832MHz
But still the problem continues.

Please mail, your suggestion to me. I to afraid if this problem continues one day
the Database itself will be crashed.
Error Message:
ORA-01092: ORACLE instance terminated. Disconnection forced

Help me as earliest.

Velu N

Report message to a moderator

Re: ORACLE Instance Terminate [message #2575 is a reply to message #2566]

Mon, 29 July 2002 04:50

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

SIR,

PLEASE GIVE YOUR PARAMETER FILE AND SIZE OF DATA(SELECT (SUM(BYTES)/1024/1024) FROM DBA_SEGMENTS;

K.SREENIVASAN

Report message to a moderator

Previous Topic:	Re: Regarding INDEX
Next Topic:	Need your immediate reply.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 13:33:23 CDT 2024