Also see whether anyone is cleaning any temp directory or any other directories.īest way to find issue quickly other than going to above steps is getting AWR for time frame and investigating on AWR. Please help me in defining table types / indexes and tuned PLSQL / query. Then use 1,2,3 and also find any huge jobs like payroll or some other programs are running in database. Identify top SQL in tkprof and tune that.Ĥ & 5 steps are only when user complained saying that if he is facing issue in particular functionality. Bulk Update Performance Tuning Hi Tom,i have a requirement where i need to update 2 million records in 120 tables (ORACLE).i have created indexes on each table since the same column is referred in where clause and in update statement.Each table has 1 lakh records on an average. If you don’t have EBS, try getting trace from DB and collect trace from udump dir and collect tkprof. Turn off trace once after user tried his performance issue area. If you have Oracle EBS, you can go to “Help=>Diagnostics=>Trace=>Trace with binds and waits”. Enable trace at session level for the complained user. See whether complained user and top consuming session is sharing same kind of data, If not, go for step 4 4. Find out percentage of CPU consumption of that process 3. Follow below steps every time when you heard about performance issue from user.ġ.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |