Using Instance Manager

Instance Manager Functionality

1. Start an instance
2. Shutdown an instance
3. View and change values for initialization parameters
4. Check the current state of archiving
5. Find out how much memory is being used by the SGA
6. List current database users
7. Look at information about a user
8. Forcibly terminate a user’s connection
9. Look at resource utilization by the instance

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 righ 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. 

   The sessions entry can be expanded. Just click the little + sign next to it.

Using Instancemanager - Exercise