2016大事记

转眼间2016就结束了,这一年发生了太多的事。有些感慨就写下来做个纪念吧。

Oracle - Materialized View

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialized views against remote tables is the simplest way to achieve replication of data between sites.

Oracle - ILM

ILM is mean Information Lifecycle Management. It’s practice of applying policies for effective management of information throughout its useful life.

Implementing ILM Using Oracle Database
The offical documentation see here

Oracle - Advanced Queue & Job

Advanced Queueing

Oracle Advanced Queueing (AQ), AQ provides a message queuing infrastructure as integral part of the Oracle server engine. It provides an API for enqueing messages to database queues. These messages can later be dequeued for asynchronous processing.
Oracle AQ also provides functionality to preserve, track, document, correlate, and query messages in queues.

Oracle - Instance - RAC, Memory - SGA, PGA

An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of the background processes and memory buffers is called an Oracle instance.

Oracle - Trouble Shooting & performance monitor by OEM

The goals of Oracle troubleshooting include:

  • Learn a troubleshooting methodology for use in analyzing any Oracle database
  • Understand ratio-based and bottleneck troubleshooting analysis
  • Learn troubleshooting techniques for monitoring and optimizing memory usage
  • Know how to quickly pinpoint and resolve I/O hotspots at the database, storage and object level
  • Using scripts to uncover session-related bottlenecks
  • Understand techniques for locating and fixing problem SQL