Home » RDBMS Server » Networking and Gateways » delay in oracle (10.2.0.4,Windows 2003)
delay in oracle [message #467232] Thu, 22 July 2010 17:21 Go to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Hi all,

I have a strange question.. We are having performance isssues on running a process via application to Oracle and CPU gets to 100%.. but sometimes the process keeps running and sometimes Oracle hangs.. Is there a setting in Oracle where it will wait because the CPU is 100%??

I've spent a lot of time on this but didnt get any answer.. please help

Thanks..
Re: delay in oracle [message #467233 is a reply to message #467232] Thu, 22 July 2010 17:32 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> but sometimes the process keeps running and sometimes Oracle hangs..
When this condition occurs, what happens if you try as below
sqlplus
/ as sysdba
select * from v$version;
exit

What clues exist within alert_SID.log for times around these "hangs"?
What do you do when hang occurs to restore better performance?

>Is there a setting in Oracle where it will wait because the CPU is 100%??
NO!
Previous Topic: Connect Remotely Database
Next Topic: Frequent disconnection between client and database
Goto Forum:
  


Current Time: Thu Mar 28 14:29:43 CDT 2024