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
- 5153 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 |
A Customer wants to use a new Image in HRMS, where it is stored?
Where do we need to install connectivity software?
Explain where are workflow work items found?
You can specifically trace the activity of the PSAPPSRV server process by setting which one?
Explain one to many relationship.
What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?
Explain the different menu types available.
What are various ways to trace a process / application in peoplesoft? Explain them.
What BEA product is used for DB transaction in PS?
What are menu types available in peoplesoft?
What are the differences between RowClass and RowSet in PeopleSoft?
How to login into bs mode?
PeopleSoft HRMS 
