Hello, my name is Anju Gandhi, Product Manager for Toad for Oracle. Today we'll discuss new features in Toad Oracle which will be beneficial for DBAs. The new features to be discussed today are connected intelligence, comparing multiple schemas, jump search, private script repository, Oracle 12c support of container and pluggable databases, automatic deadlock detection in a trace file browser.
Let's review the feature for connected intelligence, also known as the forums window. This is accessible via Help menu, Toad World, Forums. Before you access this, you will need to have a registered account on toadworld.com, which is an online community of Toad users, of over three million users.
Once you're registered and signed in, you will gain access to all the user forums right from within Toad. At any time, you can click on any user forum, open it, browse it, you can reply to it. You can also ask your own questions, start your own discussions, and monitor the progress of your own thread as well.
While you post anything new, you can click on an option to be notified via email if anybody responds to your post as well. So there are many different ways to stay connected with the online community. Once you have browsed all the user forums, you can close them all in single step using Close All Toad World Content Windows.
Now when you are trying to perform comparison across different database environments, and if those database environments host multiple schemas, you will find our new feature in Toad for Oracle 12 very useful, which is available under Database, Compare, Multiple Schemas. Now, compare multiple schemas lets you choose your source and target databases. And the schemas that are automatically selected are matching in name.
However, if that needs to change, if your database environments have some naming terminology differences. Let's say you use underscore test and test environment and underscore prod and prod environments. So you may want to, in that scenario, append and maybe search for a test and replace with prod and then perform the mapping of schema names. So there are different ways you can manipulate the schema names if they don't match exactly.
Option Stay the Same As Single Schema Compare. In output, you can create your options and choose them. And in Results here you can review the differences in the lower tabs and, of course, look at the sync script as well. The different summary gives you a very high level overview of the differences and tells you how many objects are differing. And at any time you can choose to take a subset of the schema and then send the sync scripts to editor or you can recompare the selected schemas if there have been any recent changes.
A great improvement to also in the options has been if you want to save these settings as some name and then want to be able to reuse those settings across different comparison screens in Toad. So that is also available. So let's say you're constantly doing comparison only across certain objects, certain names that you have chosen. So all your customised search will be able to be saved by a name as well. So let me hide this forum window as well.
And a new feature that is available in Toad 12 is jump search feature. That is available on the upper right hand side corner. And this is a feature that lets you perform searches across multitude of places within Toad product. You can directly open windows, directly go to the menus and toolbars by any keyword search. And this also brings out the Toad World blogs and user forum articles and you can browse through them as well. So this is a great way to read anything technical, not just Toad, but anything Oracle or technical related and see what other users are discussing about it as well.
Now as DBAs, if you are keeping your scripts and storing them at a certain network location. However, if you want to store your scripts in, let's say, a schema, which is a more secure way of sharing your script, you can do that as well. And the way to configure that will be via Toad options online. And in the script repository, Toad World is the public repository.
So if you want to contribute to a public repository and share the scripts with other users, maybe remove some sensitive information, this is a great way to share your scripts with all of the users. And then you can also keep your scripts that have perhaps some more sensitive data in them in your private company network. And this can be shared only amongst users who need to have access to those scripts. So this is a great way to keep your scripts under the schema, which is in a more controlled environment.
How do you access these scripts? In a regular editor, in a File Open dialog, you will see an option for private script repository. This is after you have chosen private script repository in the Toad options that we just saw. You have an ability to categorize your scripts in multiple collections. And you can look at your script, preview it, see if anyone has posted any comments, how many times this script has been downloaded.
Anyone can open who has access to this private script repository can open this script and execute this script. So you don't have to be owner. Multiple people can share the same script. You as an owner, of course, have some more privileges. So this is a great way to share scripts amongst a group of users and keep it in a safe and secure place.
Oracle 12c comes with multi-tenant architecture, of course with the container and the pluggable databases. So if you open a database browser, which is a great tool for DBAs to watch out for any issues in the database at a high