one particular query taking long time how to reduce that time
- 2 Answers
- 5133 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
How many Message nodes are possible for a database?
Differentiate between dddaudit and sysaudit?
You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?
A Customer wants to use a new Image in HRMS, where it is stored?
What are the common elements in peoplesoft configuration manager?
In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHED ULER.PRCSTYPEDEFN.GBL which one is the component definition?
All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is not bounced?
How will you get a single ouptut by combining two or more queries?
What is distributed managed server definition in weblogic server?
What event gets fired after DB Update?
DB is in windows, application server can be configured in Windows or Unix or Anyone?
PeopleSoft HRMS 
