| delay in oracle [message #467232] |
Thu, 22 July 2010 17:21  |
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  |
 |
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
