Introduction to Oracle 11g Tutorials
Tools & Configuration / Oracle Enterprise Manager (OEM)
Subtitles of the Movie (Introduction to Oracle 11g / Tools & Configuration / Oracle Enterprise Manager (OEM))
So far in this chapter on tools, we've looked at netca and used it again, we've looked at Net Manager and used it again as well as the DBCA Tool. If you can remember from the last movie, we got a local intranet address and this is actually an address for my database that I just created for Oracle Enterprise Manager. What I'm going to do is I'm going to go into a browser on my local Windows XP machine and paste it into there. What this is going to give me is access to a tool, another Oracle Tool, a little bit advanced for this course called Oracle Enterprise Manager and I'm just going to show you basically what's in it. And voila, here we have Oracle Enterprise Manager with a number of different windows, so we could click on Performance, we get a Performance Window and it might take awhile to refresh. It basically gives you graphs and tells you when have spikes of activity. That's a big spike, a lot of activity. Um, it's actually if we drill down into that by clicking on it, it might give me some clue as to what was going on at that time. What I'm seeing here is Sysman and DBSNMP Users. These are the users that control Oracle Enterprise Manager and the statistics generation that it's based on. So this was probably the process of creating the database and, or possibly the first initial statistics generation after the database was created. I can go back again and sometimes it might take a little time and I'll go back again, it goes back to the main window. If there's some activity I should see some activity in here so what I could do, is I could go into there, I could go into SQL Plus and I could say Select well, Set Wrap Off. What I don't want to do is have a lot of data spreading across the screen and going across the network. So I'm just going to stay Select Star from DBA Tables. I'm turning the wrap off because I don't want SQL Plus to wrap the lines around and basically report 20 lines for each row or just one line. I just want one line per row as you can see here and it just chops it off. It's quicker, trying to reduce the network traffic but we might get lucky and see some kind of spike here. See this, that went up a tiny bit, not much, I mean, it's not, it's not anything you can really see. Click on Performance and we might have a tiny bump there as well. You can see the database well there's, that's probably the bump that we're looking at. I could do something a lot more complicated and really give you too much information this early in the course, all I'm trying to show you here is this tool exists. So you've got the home screen, you got the Performance Window, you can drill down, availability gives you basically backup and recovery access. The Server Window gives you the architecture of the database, Security, Scheduler, Configuration, Resources, Statistics, Storage, the way that Oracle is architected storage wise. We'll go into that later, Schema, the contents of Schemas, the database objects within Schemas, Tables, Indexes and so on and so forth. Again, not too much detail at this point in the course. Data movement, typically used in data warehouses to load data into databases and pull data out of databases. Software and support is support screen, click back on Home, that is Oracle Enterprise Manager very useful but don't get too detailed with it in a course of this introductory nature because this is very advanced. But it is a useful tool that you may find useful later on, it's important that you know it's there.
Tutorial Information
| Course: | Introduction to Oracle 11g |
| Author: | Gavin Powell |
| SKU: | 34312 |
| ISBN: | 978-1-61866-042-8 |
| Release Date: | 2012-04-28 |
| Duration: | 11.5 hrs / 139 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
