![]() The next 2 tabs are where you can view and manage your user connections and see what they are doing. Now let’s look at some Session information. They basically show the configuration of your database parameters as you can see below. There is useful information on all of these tabs, don’t get me wrong, but for now I will let you explore them on your own. I will go into more details on these in a future blog. I am going to skip over the next 4 tabs: Instance, Database, Options, and Parameters for now. This is a pretty powerful screen for managing your pluggable databases. If you have an xml file you can even plugin a database. This gives you a quick overview of the sga, shared pool, hit rates and event waits.Ĭlicking on the ‘Pluggable DBs’ tab will display any pluggable databases you may have as shown below.ĭepending upon your database permissions and setup you may be able to Open, Close, Save, Create a pluggable database or create a tnsnames entry for your database by using the icons at the top of this screen. That is what you see in the 2 screen-shots above. Regardless of the screen, the tabs are still at the top of the screen. ![]() It is your personal preference as to the screen view you want to use. This will change the display to a grid view as shown below. These are what I am going to focus on in today’s blog.Īlso notice that at the bottom of the graphs screen there is a ‘grids’ tab. On the right-side you see a row of tabs at the top of the screen. On the left-side of the screen you can see a list of items you can use Toad to monitor. Simply double-click on the database you want to work with and you will see the following screen: On the left side you will see your database connections. Once you choose the Database Browser menu item you will see the following screen: There are a lot of other options under the DATABASE dropdown and I will cover these in future blogs so stay tuned. We are going to focus on MONITOR – Database Browser. Under the DATABASE dropdown you will see several items. In this series of blogs I will show you how Toad® for Oracle can help you monitor database activity and report on these activities as well as many more. As a DBA there is a lot of activity that you are responsible for. These are just a few of the things that you are responsible for. ![]() Memory usage, database parameters and options, user session information, and rollback activity. ![]()
0 Comments
Leave a Reply. |