Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Oracle Apps Dba Tutorial
→
Oracle Apps Dba Interview Questions in Oracle Apps Dba Tutorial
→
If The User Is Experiencing Performance Issues, H...
1.
If The User Is Experiencing Performance Issues, How Will You Go About Finding The Cause?
Answer»
TRACE
his session (with waits) and use
TKPROF
to analyze the trace file.
Take a statspack report and analyze it.
o/s
MONITORING
USING
top/iostat/sar/vmstat.
Check for any network bottleneck by using basic tests like ping
RESULTS
.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
How You Will Avoid Your Query From Using Indexes?
What Is Difference Between .xml File And Autoconfig?
If We Run Autoconfig Which Files Will Get Effected?
How Frequent You Run Gather Schema Statistics Program & With What Option? Why You Need To Run It? What Is Cost Based Optimizer?
If You Want To Change Concurrent Manager Log And Out File Location, Is It Possible, If Yes, How? If No, Why Not?
Where And How You Update Workflow Notification Mailer Configuration Setting?
What Are The Request Incompatibilities? How Conflict Resolution Concurrent Manager Solve Them?
Limitation With Shared Appl_top And Application Tier?
What Is Shared Application Tier?
How You Will Troubleshoot If Concurrent Request Is Taking Long Time?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies