Shapira starts with the architecture of SSH and how it secures both the communication channel and user authentication. She explains both basic and advanced SSH capabilities with examples of how they can be used in various ways to achieve common DBA goals.

Malcher outlines how the new security and compliance enhancements in Oracle Database 11g make a default install more secure. Thomas adds more information on the steps needed to ensure the audit trail is proactively managed.

Tips from COLLABORATE10 and Two Freebies

Wright offers effective ways to monitor database activity from a security point of view.

Burleson gives readers a taste of the important SQL changes in 11g. He explains how changing hardware affects how users tune SQL.

By Michael Tefft Tefft gives a practical overview of SQL Plan Management and SQL Plan Baselines. He also describes an approach that uses them to reduce risks when upgrading to Oracle 11g.

With edition-based redefinition, Oracle Database offers real support for implementing online upgrades. In this article, Antognini provides an overview of this new feature.

In this contribution of SELECT Star, we’ll find out what’s new with Oracle’s SQLTXPLAIN and the information about Oracle Database Appliance that you should know.

Carol provides advice on direct upgrades to Oracle Database 11gR2 using either the Database Upgrade Assistant (DBUA) or the manual upgrade (catupgrd.sql or command line script). She provides numerous best practices, most of which involve upgrade preparation.

Gwen discusses what big data is, how it is used specifically inside an Oracle Big Data Appliance and how you can use it effectively.