Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different tools that are provided by oracle to assist performance monitoring?
- 1 Answers
- 6 Views
- I also Faced
- E-Mail Answers
Answer / Atul Goel
Oracle provides several tools for performance monitoring, including AWR (Automatic Workload Repository), ASH (Active Session History), Statspack, and SQL Trace. AWR collects historical performance statistics, ASH provides real-time performance data, Statspack is an older tool that provides performance statistics on instance and session level, and SQL Trace allows you to capture detailed information about SQL statements.
| Is This Answer Correct ? | 0 Yes | 0 No |
How is rman better than user-managed backup recovery process?
What are the file storage options provided by oracle database for oracle rac?
What do you understand from cache fusion?
What is an explain plan and how does it help in optimizing the sql query?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
What is required by oracle rac database to connect to a network?
What is the functionality and features provided by oracle clusterware?
What are the benefits of oracle rac?
What is the difference between restoring a database and recovering a database?
What is rac?
What are the provisions and resources provided in the oracle’s cloud server?
What is a system tablespace and why do we need it?
Oracle General 
