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
- 5207 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 |
Tell us about web servers.
Differentiate between rowclass and rowset?
Given ma a sql statement, if you have been asked to check the right syntax?
In which platform does Crystal and Psnvision works?
Why do we use weblogic server in peoplesoft?
You just started a new application server. What problems you may encounter?
What statuses are available in peoplesoft domain status menu?
The Security Administrator is not available. You are in a hurry to grant a user the ability to start an application server, and you decide to make the change in the actual application server configuration file, rather than using the Security Administrator. Referring to the above information, how would you grant a user the ability to start an application server using the application server configuration file, PSAPPSRV.CFG?
Which tree types is NOT supported in the PeopleSoft tree manager?
Update and Fixes: R-* files refers to what?
If you want to log into DataMover in Bootstrap mode, How would you login?
you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
PeopleSoft HRMS 
