This article is about oracle daily maintaince, mainly contains
dba_profilesthe three parts.
Sometimes, varity business data need create restore point for differ performance test. So how to manange restore point and how to flashback, see the below ->
materialized view, or
snapshotas 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 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 AQalso provides functionality to preserve, track, document, correlate, and query messages in queues.
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.
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
最近一直在学nodeJS, npm package manager 这是必不可少的。原因挺简单，在国内访问外网太慢。。。大家都懂得~