Database Administration (MOSC)

MOSC Banner

Oracle serverspace wizard

Configuring Oracle Serverspace Wizard in Nagios .

Need recommendations for metrics - which one more usable, more makes sense to monitor/better practical thresholds. Please share experience. So far just setup Connected Users.

Connection Time

Connected Users

SGA Data Buffer Hit Ratio

SGA Library Cache Hit Ratio

SGA Dictionary Cache Hit Ratio

SGA Shared Pool Reload Ratio

SGA Shared Pool Free

PGA In Memory Sort Ratio

Soft Parse Ratio

Retry Ratio

Redo I/O Traffic

Roll Header Contention

Roll Block Contention

Roll Hit Ratio

Roll Wraps

Roll Extends

Flesh Recovery Area Usage

SGA Latches Hit Ratio

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center