Oracle Is Slow, Is There Anything Wrong With Database?

Whenever there is any application slowness or any other performance issue, regardless of source of the problems, the first question comes to DBA that Oracle is slow, is there anything wrong with database?

As a DBA we use to face this situation day to day. This doesn't mean there is no problem from database but many times it could be a server, storage or network bottleneck. May be issue with application coding.

Linux Server Performance Analyzer Utilities

If there is any Linux performance issue we mostly go to Google and find commands to analyze the performance but multiple time it's difficult to find it when we required some specific details so, we have tried here to place all the Linux performance utility which can help you to analyze the Linux server performance.

There are multiple utilities available to analyse Linux server. Which includes CPUs, Memory, I/O, disk, network analysis.

Utility	Discription
free	Displays free and used memory.
iostat	Displays disk I/O statistics.
netstat	Reports on network statistics.
mpstat	Reports CPU statistics.
vmstat	Monitors processes, CPU, memory, or disk I/O bottlenecks.
ps	Identifies highest CPU- and memory-consuming sessions. Used to identify Oracle
sar	Displays CPU, memory, disk I/O, and network usage, both current and historical
top	Identifies sessions consuming the most resources.
watch	Periodically runs another command.
du	Displays disk usage.
df	Reports on free disk space.

                                              How to calculate IOPS in Exadata ?