ITPub博客

Steps for Creating New Control FilesComplete the following steps to create a new control file.Make a list of all datafiles and redo log files of the database.If you follow recommendations for control file backups as discussed in "Backing Up Control Files" , y...

Oracle 自10g 以后，企业管理器（Oracle Enterprise Manager：OEM）变成了网页形式。 OEM 分两种：Grid Control(网格控制) 和 Database Control（数据库控制）。 Grid Control 是具有完整功能的全企业Oracle 生态系统管理工具。 Dat...

Monitoring Errors with Trace Files and the Alert LogEach server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is int...

summarizes the various memory management methods. If you do not enable automatic memory management, then you must separately configure one memory management method for the SGA and one for the PGA.Note:When automatic memory management is not enabled, the default method for the instance PGA...

Oracle Database Background ProcessesProcess NameDescriptionDatabase writer (DBWn)The database writer writes modified blocks from the database buffer cache to the datafiles. Oracle Database allows a maximum of 36 da...

一.  官网说明       在DBCA 建库的时候，有提示让我们选择连接类型，这里有两种类型：专用服务器模式和共享服务器模式。默认使用专用模式。如下图：  Oracle 官方文档对这两种文档的说明如下：About Dedicated andShared Server Processeshtt...

Quiescing a DatabaseOccasionally you might want to put a database in a state that allows only DBA transactions, queries, fetches, or PL/SQL statements. Such a state is referred to as a quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements a...

一．  OHASD 说明Oracle 的Restart 特性是Oracle 11g里的新特性，在讲这个特性之前先看一下Oracle 11g RAC的进程。之前的Blog 有说明。Oracle 11gR2RAC 进程说明http://blog.csdn.net/tianlesoftware/article/details/6009962 Oracle 11gR2 中对CRSD资源进行了重新分类： Local ...

Oracle Database provides generally appropriate values in a sample text initialization parameter file. You can edit these Oracle-supplied initialization parameters and add others, depending upon your configuration and options and how you plan to tune the database.The sample text initializati...

CREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY system_password LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log','/u02/logs/my/redo01b.log') SIZE 100M BLOCKSIZE 512, GROUP 2 ('/u01/logs/my/redo02a.log','/u02/logs/my/redo02b.log') SIZE 100M BLOCKSIZE 512...

Creating a Database with Noninteractive/Silent DBCASee Appendix A of the installation guide for your platform for details on using the noninteractive/silent mode of DBCA.The following example creates a database by passing command-line arguments to DBCA:dbca -silent -createDatabase -templ...

[oracle@cj emp_imp]$ exp scott/tiger@cj01 tables=scott.dept, file='/db/ora11g/test/emp_imp/dept.dmp', log='/db/ora11g/test/emp_imp/dept.log';Export: Release 11.2.0.1.0 - Production on Wed Feb 26 21:41:22 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.EXP...

Stream 是Oracle 的消息队列(也叫Oracle Advanced Queue)技术的一种扩展应用。 Oracle 的消息队列是通过发布/订阅的方式来解决事件管理。流复制(Stream replication)只是基于它的一个数据共享技术，也可以被用作一个可灵活定制的高可用性方案。 它可以实现两个数据库之间数据库...

 数据处理大致可以分成两大类：联机事务处理OLTP（on-line transaction processing）、联机分析处理OLAP（On-Line Analytical Processing）。OLTP是传统的关系型数据库的主要应用，主要是基本的、日常的事务处理，例如银行交易。OLAP是数据仓库系统的主要应用，支持复杂的分析操作，侧重决策支持...

Oracle Label Security (OLS)Oracle Label Security (OLS) is an extension of the Virtual Private Database (VPD) technology introduced in Oracle 8i. OLS allows access control down to individual rows based on attached labels. Similar functionality can be reproduced using Fine Grained Access Contr...

Virtual Private Databases (VPD) and Fine-Grained Access ControlVirtual Private Databases (VPD) allow multiple users to access a single schema whilst preventing them from accessing data that is not relevant to them. Although this type of access can be controlled by the application, access vi...

Overviewof the System Global Area The SGA is a read/write memory area that,along with the Oracle background processes, make up a database instance. Allserver processes that execute on behalf of users can read information in theinstance SGA. Several processes write to the SGA durin...

Introductionto Oracle Database Memory Structures When an instance isstarted, Oracle Database allocates a memory area and starts backgroundprocesses. The memory area storesinformation such as the following:     Program code   &nbsp...