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
- 5238 Views
- Intel, I also Faced
- E-Mail Answers
Answer Posted / praveen
Update statistics on the table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain compare reports?
What are the analytic servers?
You are receiving an error "application server is down at this time" but hthe application server is running. What could be the problem? How will you debug it?
What are peopletools utilities?
Can you give an example of peoplesoft server process logs?
What is psadmin in peoplesoft?
Which peopletools system table is used to track object changes?
Is it ok to install two different peoplesoft versions on same machine?
How to login into bs mode?
What are peopletools utilities and what it contains?
Explain the architecture of peoplesoft.
What peopletools contains?
What is idda logging?
Explain psstatus table?
Explain environment hub?
