Oracle has introduced significant management automation features in its flagship database product and has described the new Oracle Database 10g release as "The self-managing database." Given that achievement and direction, it would make sense to talk about how to write one's PL/SQL application so that it is also self-managing. This paper offers several suggestions for ways to write code so that the application is, as much as possible, self-managing, requiring the absolute minimum amount of attention and adjustment to keep it running, even in the face of data structure modifications.
Did you find this white paper useful?
18 out of 33 users found this white paper useful
Related white papers
Top 10 Secrets for DBA Career Success
Over the years, Confio Software has had the opportunity to learn many tips from the hundreds of DBAs that it has worked with. These tips are based on its experiences...
SQL Server 2005 for Developers
Leverage the power of SQL Server 2005 for database and application development. Description: Get the knowledge and skills to implement a Microsoft SQL Server 2005 database in this course. Learn to use...
SQL Server 2005 Administration
Learn to administer and tune SQL Databases and Servers. Description: Get the knowledge and skills you need to maintain a Microsoft SQL Server 2005 database in this 5-day course. Learn how to...
Initial Experience With Database Applications
The Spallation Neutron Source (SNS) Project relies on a single relational database as its main repository for accelerator information. Every hardware component is represented in this repository with data ranging...
IBM Informix Dynamic Server, Version 9.4 Boosts Revenues, Improves Business Efficiencies
For more than a decade, IBM Informix Dynamic Server (IDS) has been a favorite database for companies with enterprise-class OnLine Transaction Processing (OLTP) and OnLine Analytical Processing (OLAP) systems. With...
Database Application for Control System Hardware Management
The Paul Scherrer Institute (PSI) is operating at present two accelerator facilities, and a third one is under construction. The control system hardware for these facilities is managed by a...
Customer Data Privacy Solution: Can We Afford to Compromise It?
This paper highlights one of the effective ways to establish Privacy solutions at the database level for the big retail giant who is working with VLDBs (Very Large DataBases).It explains...
