Application not coming up [message #346468] |
Mon, 08 September 2008 12:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
I am not able to bring my application up.I checked the v$session and it is showing me this wait:-cursor: pin S wait on X.So the application is keeping waithing instead of coming up.Dyou have any suggestions what can i do to resolve this.
Regards,
Varun Punj
|
|
|
|
|
|
Re: Application not coming up [message #346533 is a reply to message #346482] |
Mon, 08 September 2008 15:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
I have one basic question:-
Can we tune system tables.
There are 2000 queries being executed when we bring the application up.These queries takes very less time generally.But today some queries are taking 10 secs.So that could be one of the reason that application is not coming up.Most of these queries are using system tables.
Regards,
Varun Punj
[Updated on: Mon, 08 September 2008 23:20] by Moderator Report message to a moderator
|
|
|
|