| general view is also takin long time, all of sudden... [message #605722] |
Mon, 13 January 2014 19:48  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear All,
user are using UATODS for MIS purpose. Nothing changes have done at ODS, data were fatchin smoothly through views but all of sudden it seems to be hang.
There are nothing in locked,nothing in jobs. Gather stat was not running so i made it schedule.
please let me know how can i simulate the issue ?
[Updated on: Mon, 13 January 2014 19:53] Report message to a moderator |
|
|
|
|
|
| Re: general view is also takin long time, all of sudden... [message #605738 is a reply to message #605723] |
Tue, 14 January 2014 02:51  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear BlackSwan,
Thanks for highlighting the link to me.
Actually, problem was due to procedure which were deleting the rows from tables and during the execution of procedure, its not inserting the data into respective tables.
And there were no commits between the transactions. This things I came to know when user simulating the same infront of me.
Now issue is resolved.
Thanks
Ishika
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
