one particular query taking long time how to reduce that time
Answer Posted / ashok
Check the index and execution plan was recently changed or not.If its not changed let tune the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?
What is peoplesoft server process logs?
You want to upgrade a peoplesoft tool. How would you do it?
Explain the architecture of peoplesoft.
How do you uninstall the weblogic server?
Explain load balancing?
What are the default values for psappsrv and other servers when application designer starts?
Suppose if you want to log into datamover in bootstrap mode, you would login as?
Explain what are the components which form the part of integration broker?
Why do we use weblogic server in peoplesoft?
Explain the different menu types available.
How can you configure sql trace?
Which events get fired after db update?
How to get a single ouptut by combining two or more queries?
What are various ways to trace a process / application in peoplesoft? Explain them.