High Availbility

OS & Virtualization

Thursday, October 25, 2018

ORATOP - Top process for Oracle databases


Key
description
t
display tablespace information.
a
displays the database's ASM information
s
toggle the fourth section between showing session information, the default, and showing SQL statements
x
lets the database administrator see the Explain Plan for a given SQL identifier.
h
help
m
Module/process
k
File#, block#
f
Long format
i
Interval display
d
Real time processing

RED




Values flagged and highlighted in red color are merely a warning or to emphasize importance