-
编辑 删除
quiesce,suspend
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...
-
编辑 删除
Oracle 11g 新特性 -- Oracle Restart 说明
一． OHASD 说明Oracle 的Restart 特性是Oracle 11g里的新特性，在讲这个特性之前先看一下Oracle 11g RAC的进程。之前的Blog 有说明。Oracle 11gR2RAC 进程说明http://blog.csdn.net/tianlesoftware/article/details/6009962 Oracle 11gR2 中对CRSD资源进行了重新分类： Local ...
-
编辑 删除
Sample Initialization Parameter File
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 a part
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 DBCA
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...
-
编辑 删除
EXP-00056: ORACLE error 12514 encountered解决方法
[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...
-
编辑 删除
oracle stream replication
Stream 是Oracle 的消息队列(也叫Oracle Advanced Queue)技术的一种扩展应用。 Oracle 的消息队列是通过发布/订阅的方式来解决事件管理。流复制(Stream replication)只是基于它的一个数据共享技术，也可以被用作一个可灵活定制的高可用性方案。 它可以实现两个数据库之间数据库...
-
编辑 删除
oltp,olap
数据处理大致可以分成两大类：联机事务处理OLTP（on-line transaction processing）、联机分析处理OLAP（On-Line Analytical Processing）。OLTP是传统的关系型数据库的主要应用，主要是基本的、日常的事务处理，例如银行交易。OLAP是数据仓库系统的主要应用，支持复杂的分析操作，侧重决策支持...
-
编辑 删除
Oracle Label Security
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 Control
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...
-
编辑 删除
SGA
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...
-
编辑 删除
UGA,PGA
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  ...
-
编辑 删除
Undo Segments
Undo SegmentsOracle Database maintains records of the actions oftransactions, collectively known as undo data. Oracle Database uses undo to dothe following:? Rollback an active transaction? Recover aterminate...
-
编辑 删除
Overview of Tablespaces
Overview of TablespacesA tablespace is a logicalstorage container for segments. Segments are database objects, such as tablesand indexes, that consume storage space. At the physical level, a tablespacestores data in one or more data files or temp files. A database must have the...
-
编辑 删除
Logical Space Management
Logical Space ManagementOracle Database must use logical space management to track and allocatethe extents in a tablespace. When a database object requires an extent, thedatabase must have a method of finding and providing it. Similarly, when anobject no longer requires an extent, the datab...
-
编辑 删除
Chained and Migrated Rows
Chained and Migrated RowsOracle Database must managerows that are too large to fit into a single block. The following situationsare possible:· The row is too large to fitinto one data block when it is first inserted.In row chaining, Oracle Database stores the data...
-
编辑 删除
checkpoint
checkpoint扫盲 什么是checkpoint checkpoint的作用 检查点分类 checkpoint相关概念术语 RBA（Redo Byte Address）, Low RBA（LRBA）, High RBA（HRBA） Buffer checkpoint Queues （BCQ） ...
-
编辑 删除
Transactions
一，Enqueued TransactionsDepending on the scenario, transactions waiting for previouslylocked resources may still be blocked after a rollback to savepoint. When atransaction is blocked by another transaction it enqueues on the blockingtransaction itself, so that the entire blocking tra...
-
编辑 删除
Oracle 常见的33个等待事件
之前整理过一篇文章： Oracle 等待事件 http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/WE1/Default.aspx 13.&...
-
编辑 删除
锁 死锁 阻塞 Latch 等待 详解
锁这东西是纯概念性的东西，但是作用又非常大。 以前整理过两篇文章，今天又看了点书，觉得还不是很清楚。 就重新整理了下。 在想要不要把以前的文章删掉，这样在blog里是比较简介的，但后来又一想。 这些连接在其他的地方可能被引用了。 就决定还是保留着了，也算见证自己成长的一个过程。 ORACLE 锁机制...
