Tuesday, October 9, 2012

Review of Oracle Magazine-March/April 1998

The headline articles for the March/April 1998 edition of Oracle Magazine were on how the role of the DBA is increasing in importance, managing databases globally, how the DBA is an important strategic partner in an organisation. Oracle is being used by a number of health organisations including Norway’s national hospital system, Regence BlueCross BlueShield of Utah and Neuroclinical Trials Center.

image

Other articles included:

  • Oracle Applications 11was due for release during the first half of 1998 and has a number of key features including, Universal Access, Globalized Finance, Project Manufacturing and Flow Manufacturing.
  • Oracle’s Industry Applications division recently introduced new products including Oracle Public Budgeting, Oracle Sector Grants Management and the Oracle Energy Upstream solution .
  • 5 ways DBA’s can be strategic partners: Proactive systems management, systems design, change management, performance tuning and security.
  • Steve Lemme, DBA/systems manager for Motorola lists the following tasks for DBAs to keep them busy
    • Daily Duties : At a minimum monitor
      • Oracle ALERT file logs
      • Systems resources
      • Backups
      • Archive logs
      • Error logs
    • Weekly Watch : Check free space including:
      • Tablespaces
      • Tables
      • Indexes
      • Clusters
    • Monthly Monitoring : Do audits for fragmentation of :
      • Indexes
      • Clusters
      • Tables
  • Oracle Enterprise Toolkit comprises, Enterprise Manager, Diagnostics Pack, Tuning Pack and Management Pack.
  • Kenny Smith looks at a day in the life of a DBA working from home using Oracle Enterprise Manager that included a Data Load, Change View, Create stored function, Add a new user, Fix a database link, Send a size report to director, Fix a production slowdown, Helped an application developer and Averted a production crisis.
  • Migrating to Oracle 8: Quick Start on New Features:
    • Knowledge Collection and Consolidation
      • Learn about Oracle 8’s new features
      • Get help from someone who has implemented Oracle 8
      • Review the new features with your team
    • Application Analysis for New Features
      • Implement minor changes first
      • Define the table partitioning strategy
      • Define and indexing strategy
      • Identify the tables you can index organise
    • Database Design Analysis for New Features
      • Define the new physical layout
      • Define a partition maintenance strategy
      • Migrate to partitions
    • Backup and Recovery Strategy
      • Review your current backup and recovery strategy
      • Make as many tablespaces as possible read-only
      • Define a multitiered backup strategy using SMR
      • Make sure at least two independent restoration options exist
      • Ensure that you can do the restoration in an adequate time period
      • Define a plan for testing backup and recovery
  • Kevin Loney has an article on the new format for ROWID in Oracle 8, what it is and how to use it

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

No comments:

Post a Comment