Oracle Database Monitoring

• What is going on in the database?
• Version information
• List free and used space in database
• List session information
• List names and default storage parameters for all tablespaces
• List tablespace types, availability of data files
• List information about tablespace to which datafiles belong
• List data file information
• List tablespace fragmentation information
• Check the current number of extents and blocks allocated to a segment
• Check the extents for a given segment
• Extent information
• Extent information for a table
• List segments with fewer than 5 extents remaining
• List segments reaching extent limits
• List table blocks, empty blocks, extent count, and chain block count
• List rollback segments in the database
• List stats of the rollback segments currently used by instance
• List sessions with active transactions
• Active sorts in instance
• Index and constraint information
• Updating statistics for a table or schema
• List tables and synonyms
• Constraint columns
• Constraint listing
• Indexed columns listing
• Trigger listing
• Tuning: library cache
• Tuning: data dictionary cache
• Tuning: buffer cache
• Tuning: sorts
• Tuning: dynamic extension
• Tuning: rollback segments
• Tuning: physical file placement
• Killing Sessions
• Archive Logging Status
• Recovering an Instance
• Redo Log Information
• A Simple Monitoring Tool
• Connection Errors
• Explain Plan: syntax

Back to top page