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 5135Post New Intel PeopleSoft Administration Interview Questions
What is globalization?
What is the agent in artificial intelligence?
What is load?
What are your long-term goals or career plans? : insurance sales
What is a lambda in programming?
Draw the flow of F.O. diagram from service tank to Main Engine?
How do you check if a stack is empty or not?
What are the features and characteristics of Apache Spark?
What are keys in reactjs and why are they important?
What are dangling pointers in c?
To integrate factsheets with geographical maps, connection is set up between the abap back-end server and the map provider. What is communication channel?
Are marketing skills inherent? Can they be nurtured and developed?
Respected sir, Please send me technical questions related to oracle apps..
what are the different index configurations a table can have? : Sql dba
What is endpoint in wcf?