Statistics in Oracle and SQL Server

The EM CLI (Enterprise Manager Command Line Interface) enables the administrator to access full EM12c functionality from the command line, (shell/command windows). This essential tool is incorporated with even more features with the newest release of the Enterprise Manager 12c and is important knowledge to possess when working within the EM12c environment.

This webinar will open the administrator up to the world of Enterprise Manager 12c's Command Line Interface. Discover advanced features that the EM CLI can manage, not just commands to manage/address the E12c environment, but custom scripts used in SQLPlus, shell and Perl which can also be utilized through this invaluable tool.

The session will demonstrate how EM CLI can ease the management when administering large database environments through by utilizing this tool and how the commands can address problems the GUI interface can not.
The better the information that Oracle and SQL Server have about the data in a database, the better choices they can make on how to execute the SQL. Statistics are Oracle’s and SQL Server’s chief source of information. If this information is out of date, performance of queries will suffer.

In their third live ‘Oracle vs. SQL Server’ discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server.

Does Oracle and SQL Server gather the same information?  What does each optimizer use this information for? And how can Oracle and SQL Server administrators override the defaults for better (or worse) performance? These are just some of the questions that Jonathan and Grant will try to answer in another not-to-be-missed session.

As before, this will be a live discussion with limited supporting slides, and will conclude with a Q+A session with Jonathan and Grant. Be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.

Register