Hello and welcome for this short educational video using Toad for Oracle DB Admin Module. 8 Ways to increase your database power and flexibility. In this short video, I will discuss the eight Ways to increase your database power flexibility by monitoring and optimizing the database, gain visibility into your database quickly compare and deploy changes from test to production, production back to test, easily diagnose issues analyze all your database objects, simplified database or data management, streamline change management and get real time alerts.
Let's jump to the live demo. I have Toad for Oracle with the DB Admin Module. This is Toad for Oracle expert and I have the license for the DB Admin Module here. And we will start off with optimize and monitor and optimize. From there I would use database, monitor and the database monitor is very nice and then the Database Browser. We're going to look at these two. So the database monitor comes up. Gives me quick information on all these areas here on the left here. A little pinned in here shortly gives me alerts on things that probably need my attention quickly.
This is a rather idle database. So not a lot of research probably going to pop up here for us today. And then the other one would be the database browser, diagnose. I'm sorry monitor and database browser. And then it comes up in between these two, we can see a variety of information. So the monitor maybe indicates what's wrong the Database Browser allows me to drop into things such as tablespaces here. And maybe we're the alert as we're about to run out of space and a tablespace we can easily see our percent used.
Add space. Just click on the database and right mouse click. Let's see double click on it. That's what it is. And brings us in and we can edit altered data file add more space if we need to. But we can see a lot of stuff that's going on at the tablespace level. At any of these levels using the database monitor. To gain visibility into the database, I already ran the database health check just takes a few minutes to run. I didn't want to waste your time this short video. But it goes through all of these 120 different health checks.
Monitoring the alert log we're going to take a look at the alert viewer here in a moment. But watch for Oracle errors. Or different kinds of Oracle errors, trace files and the like most importantly, we're going to talk about analyzing your objects. Again this health check we'll take a look at what tables indexes, partitions and Flit. Excuse me that have not been analyzed.
This is key this differences since the last one. We'll tell you all of the differences anything new that comes up between the last time you run it. Like those alerts. Those Oracle errors. And that alert log will pop up in here, then you can go into the alert viewer. These pieces all blend together and work closely together with one another. And this of course can all be emailed to you as well.
So the next spot is quickly compared to deploy and its database compare and here we can compare data. We can compare schemas, databases, we can look for duplicates. We can compare schemas. We can get right down to the single objects. This not only will do the compare, but it will build us a script, that we can turn around and run, but it will build a script that will sync one with the other and you tell it which way you want to synchronize to.
So this would be very helpful. And I not only identifying the changes from test to production, but helping you install them without error and getting everything right the first time. Easily diagnose we would look at the alert log. So maybe in our health check, some alerts have shown up perhaps. We can go into the database, diagnose. And there is the alert blog viewer. And this thing is major cool as well.
Let's go ahead and run it and it's going to come up and populate this with. And we can tell in the database and started all these different types of things background processes started and more importantly, we can sort this Microsoft foundation. So we can sort by these headers. So we can drop right in here. And then drop roll down and see if we have any alerts and when they happen and what they're about very easily.
So easy to diagnose. We saw in the health check again about analyzing your objects. Having objects that were not analyzed, . Again using Toad database monitor or database Admin Module. Very easy to do the-- Analyze management. So database, optimize, analyze objects. So we go into this and again very easy to use. We can see this is a process system but we can change the tables for example. Let's go ahead and load my tables. Tables by a particular user.
What did that health check tell us needed analyzing? We can go pick those and make sure that those get analyzed. But our production system, our application, schema owners, you can do the whole thing. You can manage it very well. And once you run the-- Let's go in here and pick our student environment and say, OK, and it brings up there's my amp and dep table, all we can see when it was last analyzed and what's going on there.
The other thing that we can do is, like in a test environment, we can edit the stats manually edit the stats and change them to whatever we want to take the cost-based optimizer out to make explain plans that might be advantageous to whatever it is we're trying to test. The simplified database management, that's be the export and import feature so it's database export. Get database. Data Pump export.
We can export to table as a flat file. We can brings up this brings up a wizard we walk through. So we can export data. Set it up for the SQL loader. And a SQL load or direct path option so it's very fast load time does all the work for it does all the syntax. Likewise on the import side. We have a wizard to do that for us to if we can import just the table data. But we can import a variety of things using Data Pump import and then there's our Data Pump job manager.
So we can see our imports when if there were any issues and the like. Change management. We want to make our export generate database script, generate schema script. These will generate all of the DDL for whatever we point this out. We can pick particular like a particular schema. We can drop in here and take a quick look at this. And I want to change, I want to add a schema, I want to add the student schema.
I'll go ahead and find it here real quick, and double click on that, and I want to add. I want to take this one out. Take this one out. Yes or next. And these are all the different types of things that I can generate DDL for in a single script. So again very easy to promote changes from test to production, test to development, test to a QA type environment and make sure that you get everything right the first time.
And then the very last thing in our eight ways is, real time alerts. So that would be database monitor. And it is the database probe. This allows you to see all kinds of alerts that are going on in your database. Any kind of Warning you might have. You can just hover over it is going to tell you what the problem might be. And you can add your own alerts to this.
Well those are the 8 Ways to increase your database power, did the live demo, eight ways the Toad for Oracle DB Admin Module rich with features that assist the DBA in maintaining database stability by being able to quickly identify and solve issues. It also allows you to quickly and easily adjust important settings in the database, configure and manage changes to schemas and even monitor vital areas, including alert logs.
Check out the Quest Toad for Oracle datasheet. Toad DB. Toad for Oracle DB Admin Module. Check out my blog. My related blog posts in this series the database health check. Goes into a lot more detail than what I went into here. And also check out the related blog post or Toad for Oracle six benefits for maintaining database health and stability. Shameless plug for my book. I am a regular on Toad world I do have datapoint training available. And I use Toad often in my training courses. And I want to thank you for your time today on this short educational video.
12:26