Managing Oracle Behavior
Oracle can be monitored and managed with Oracle Enterprise Manager (OEM), a powerful GUI-based tool that allows detailed monitoring of all aspects of database behavior and that supports database management. Oracle also provides access to the database information stored in its memory-resident performance tables (often referred to simply as system tables). This information can be retrieved either with SQL or supplied scripts. In this section we discuss these monitoring methods, explore ways of displaying and changing Oracle tunable parameters, and consider explain plans (query execution plans).
Running Administrative Commands
Starting and shutting down Oracle require special privileges, as do alter system statements. ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
