Monitor the V$SYSSTAT table to observe memory and disk activity.

Fetch the metrics concerning Program Global Area (PGA) memory using V$PGASTAT view.

• Aggregate PGA auto target
• Global memory bound
• Total PGA allocated
• Total PGA used for auto workareas

Fetch metrics concerning System Global Area (SGA) memory.

• Amount of free system global area (SGA) memory available in shared pool.
• Total amount of redo generated in bytes.
• Total elapsed time of the write from the redo log buffer to the current redo log file.
• Redo space requests ratio. this is the ratio of redo log space requests to redo log requests
• Redo log space wait time . Total elapsed time of waiting for redo log space request.
• Redo Writes (per second)

Performance metrics improvements (Existing) / SQL Tuning (new)