Oracle Utilities Smart Grid Gateway Database Administrator’s Guide

Oracle Utilities Smart Grid Gateway Database Administrator’s Guide

Welcome to the Oracle Utilities Smart Grid Gateway Database Administrator’s Guide.

This guide provides instructions for installing and maintaining the Oracle Utilities Smart Grid Gateway database. The following topics are included:

• Database Overview

• Installing the Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and Data Archiving in SGG

• Sample SQL for Enabling ILM in SGG (Initial Installation)

• Sample SQL for Enabling ILM in SGG (Existing Installation)

• Sample SQL for Enabling ILM with Sub Retention in SGG (Existing Installation)

• Sample SQL for Periodic Maintenance

• Partitioning and Compression Recommendations

• Sample SQL Script for Interval Partitioning

• Database Changes in Oracle Utilities Smart Grid Gateway

• Upgrades to the Oracle Utilities Application Framework Database

• Oracle Application Framework System Table Guide

Privileges to Modify OUAF V4.5.0.0.0 Database

Note the following:

• Oracle Utilities Application Framework (OUAF) 4.5.0.0.0 database installation requires that schema owner (CISADM) has the execute privilege on dbms_crypto package.

Refer to the Enabling DBMS_CRYPTO Package section for details.

• Recommendation to interval partition tables, F1_MO_UPD, F1_MO_UPD_BACKLOG for performance reasons.

Refer to the Table Partitioning Recommendation section for more details.