Interested to Buy Any Domain ? << Click Here >> for more details...
Your Onsite DBA has called you up and told you that one of
the tables PS_ABC_TAO has grown very big in size. Based on
the standard naming convention, you have determined that
the record is a temporary record since it ends with _TAOYou
look into the database and decide that that the data is not
required any more. You ask the DBA to delete the data in
the table.Next day you get a call from an irritated user
who says that a daily process that took only 1 minute to
run is taking about 2 hours today. You look into his
process and find that it uses PS_ABC_TAO as a temporary
table.What would you suggest the DBA to do ?
- 2 Answers
- 5340 Views
- Intel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
Ask the DBA to update the Statistics for table PS_ABC_TAO .
| Is This Answer Correct ? | 1 Yes | 0 No |
Which commands can be run in Bootstrap mode?
You want to enable debug mode in peoplesoft application server. How would you do it?
What are the status available in PeopleSoft Domain Status Menu?
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 to get a single ouptut by combining two or more queries?
Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?
You want to upgrade a peoplesoft tool. How would you do it?
DB is in windows, application server can be configured in Windows or Unix or Anyone?
You want a single output by comining two or more queries. How would you do that?
Explain compare reports?
You want to authenticate a user in peoplesoft. How would you do that?
What is peoplesoft configuration manager?
PeopleSoft HRMS 
