event-icon
Description

Session ID: 283

Abstract:

Learn how to easily run SQL, PL/SQL, and shell scripts on a large number of databases and hosts.  The open source program Method5 provides agentless remote execution, built entirely inside Oracle.  Remote execution lets us find, fix, and prevent problems that could never be solved one-database-at-a-time.  Querying and controlling all our databases starts with this one line of code, and can grow to solve many complex problems: SELECT * FROM TABLE(M5(p_code => 'SELECT * FROM DUAL', p_targets => 'DEV'));

Objective 1: Learn how to quickly run SQL, PL/SQL, and shell scripts on a large number of databases and hosts.

Objective 2: Learn how relational remote execution can change the way you work.

Objective 3: Identify tasks that can benefit from rapid SQL automation.

Audience: Introductory

Tags