Managing Users   «Prev 

Exploring Instance Manager

  1. You need to log into a database. Enter system in the username field and press tab to advance to the password field. Type dogtoad in the password field and press Tab to advance to the Service field. Next, tell Enterprise Manager the database to which you want to connect. Type coin in the service field and click the OK button.
  2. From here, you can click any of the items in the left pane, except for In-Doubt Transactions, to see information about that item. The sessions entry can be expanded. Just click the little + sign next to it. When the Database item is highlighted, you can click any of the tabs in the right-hand pane. The database window provides you with general information about your database. The most obvious thing you'll see is the traffic light showing you whether your database is opened, mounted, started or shutdown. Click the close box in the upper right corner to exit or click any of the items in the left pane to learn more.
  3. Here you see information about your database, such as whether or not it is in archivelog mode, what the archivelog destination is, and details about memory allocation in the SGA. From here, you can click any of the items in the left pane, except for In-Doubt Transactions, to see information about that item. The sessions entry can be expanded, just click the little + sign next to it. When the Database item is highlighted, you can click any of the tabs in the right-hand pane. Click the close box in the upper right corner to exit.
  4. This screen provides you with information about current resource usage within the database. From here, you can click any of the items in the left pane, except for In-Doubt Transactions, to see information about that item. The sessions entry can be expanded, just click the little + sign next to it. When the Database item is highlighted, you can click any of the tabs in the right-hand pane. Click the close box in the upper right corner to exit.
  5. This screen tells you the current setting of all the database initialization parameters. They are divided into four categories, and there is a tab for each. The categories are: Basic Tuning, Instance Specific, Advanced Tuning, and Derived. From here, you can click any of the items in the left pane, except for In-Doubt Transactions, to see information about that item. The sessions entry can be expanded, just click the little + sign next to it. Click the close box in the upper right corner to exit.
  6. Having clicked on the Sessions folder, you now see a list of database sessions on the right-hand side of the screen. These represent both user connections and background processes. From here, you can click any of the items in the left pane, except for In-Doubt Transactions, to see information about that item. The sessions entry can be expanded Just click the little + sign next to it. Click the close box in the upper right corner to exit.
  7. Now that you've expanded the sessions list, you can click the System session to see information about that session. Click the close box in the upper right corner to exit.
  8. Here, you can see information about the System user's current session. From here, you can click the Database, Initialization Parameters, and Sessions folders on the left side of the window.
    The sessions entry can be expanded. Just click the little + sign next to it.