Document ID:        45277.1
Subject:            Introduction to Oracle Intelligent Agents
Last Modified:      15 Apr 97
Author:             ASHRIVES


Introduction
~~~~~~~~~~~~

Oracle Intelligent Agents is a product released with Oracle Server version 7.3
It is a product which is used with Oracle Enterprise Manager to monitor, 
administer and tune Oracle databases.

Oracle Enterprise Manager runs on a Windows NT or Windows 96 console. The 
intelligent agent runs on the server machine.  

From within Enterprise Manager you can schedule jobs and record events against 
the database being maintained. There is however limited functionality 
that can be used against a database running on a VMS server.  

With Oracle version 7.3.2.3.2 on OpenVMS, only the following functionality
is supported from Enterprise Manager and all products which form part
of Enterprise Manager:

Jobs:
   Database:     
      - Run DBA Script  : Run DBA script task
      - Run SQL*Plus    : Run SQL*Plus task
   Listener:     
      - Shutdown Listener : Shutdown listener task
      - Startup Listener  : Startup listener task
   Node Jobs:    
      - Broadcast Message : Broadcast message task 

Events:
   Database:
      - Alert           : New errors are in the alert file
      - User Blocks     : Database users have been block other processes
      - UpDown          : Database is up or down
      - Probe           : A new database connection can be established
      - Buffer Cache    : Buffer cache hit ratio is low
      - Chain Row       : Chained rows exists
      - Data Dictionary : The data dictionary miss ratio is high
      - Disk I/O        : Disk i/o rate is high
      - Library Cache   : Library cache miss ratio is high
      - Net I/O         : SQL*NetI/O rate is high
      - SysStat Table   : Value of V$SYSSTAT parameter is too high
      - SysStat Table   : Difference between V$SYSSTAT is too high
      - Response        : Response time of user program is too low
      - DataFile Limit  : Exceeds datafile limit
      - Lock Limit      : Exceeds lock resource limit
      - Process Limit   : Exceeds process limit
      - Session Limit   : Exceeds session limit
      - User Limit      : Exceeds user limit
      - Archive Full    : The archive device is full
      - Chunk Small     : Contiguous free space is too small
      - Dump Full       : The dump destination device is full
      - Maximum Extents : Segments are reaching maximum
    Listener:
      - UpDown          : SQL*Net listener is up or down
    Node:
      - UpDown          : Node is up or down
      - CPU Utilization : CPU utilization is high
      - CPU Paging      : Paging rate is high
      - Disk Full       : Disk is full

Commands:
    Node: 
      - Host            : Execute 'host' command on destination Node. 

No other functionality is supported or will work.

The next release of the Intelligent Agent (giving more functionality) will 
come with Oracle Version 7.3.3 on OpenVMS.