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
- 5112 Views
- Intel, I also Faced
- E-Mail Answers
Answer Posted / avinash
Ask the DBA to update the Statistics for table PS_ABC_TAO .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the uses of psstatus table?
Where would you install connectivity software?
How can you configure sql trace?
Explain the architecture of peoplesoft.
How do you find app server / process scheduler are up and running ?
You want to enable debug mode in peoplesoft application server. How would you do it?
Given ma a sql statement, if you have been asked to check the right syntax?
Which crystal report does peoplesoft query tool create by default?
What are the valid values in peoplecode debugger?
Explain ren server?
What is distributed managed server definition in weblogic server?
Name a few third party tools / software required for ps to function.
Explain psstatus table?
Explain bb and bbl.
Explain about the Optimizer values passed in Oracle?
