-
编辑 删除
Creating Tablespaces
1.Locally Managed TablespacesLocally managed tablespaces track all extent information in the tablespace itself by using bitmaps, resulting in the following benefits:1.Fast, concurrent space operations. Space allocations and deallocations modify locally managed resources...
-
编辑 删除
Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
Use the DBMS_SPACE_ADMIN package to migrate the SYSTEM tablespace from dictionary-managed to locally managed. The following statement performs the migration:SQL> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('SYSTEM');Before performing the migration the following conditions must be me...
-
编辑 删除
Oracle Wallet
一．官网对Wallet的说明http://docs.oracle.com/cd/E11882_01/network.112/e10746/asowalet.htm Security administratorsuse Oracle Wallet Manager to manage public key security credentials on Oracleclients and servers. The wallets it creates can be read by Oracle Database,Oracle Applic...
-
编辑 删除
Managing Archive redo log
1. Archive redo logOracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log. The process of turning redo log files into archived redo log files is called archiving. This process is only possible if the database i...
-
编辑 删除
ORA-16019 和 ORA-16018 错误的处理方法
一． ORA-16019 和 ORA-16018 错误产生描述同事在修改归档目录，一不小心把参数设置错误了， 他设置的是log_archive_dest参数。 这个参数和默认log_archive_dest_n 和 DB_RECOVERY_FILE_DEST是冲突的。也就是说， 只能用一个。 先看相关的代码来说明这个问题...
-
编辑 删除
Managing Redo File
1、How Oracle Database Writes to the Redo LogThe redo log of a database consists of two or more redo log files. The database requires a minimum of two files to guarantee that one is always available for writing while the other is being archived (if the database is in ARCHIVELOG mode).LG...
-
编辑 删除
Control Files
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...
-
编辑 删除
企业管理器（OEM）介绍： Grid Control 和 Database Control
Oracle 自10g 以后，企业管理器（Oracle Enterprise Manager：OEM）变成了网页形式。 OEM 分两种：Grid Control(网格控制) 和 Database Control（数据库控制）。 Grid Control 是具有完整功能的全企业Oracle 生态系统管理工具。 Dat...
-
编辑 删除
alert and trace
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...
-
编辑 删除
Summary of Memory Management Methods
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 Processes
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...
-
编辑 删除
Oracle Dedicated server 和 Shared server（专用模式 和 共享模式) 说明
一. 官网说明 在DBCA 建库的时候，有提示让我们选择连接类型，这里有两种类型：专用服务器模式和共享服务器模式。默认使用专用模式。如下图： Oracle 官方文档对这两种文档的说明如下：About Dedicated andShared Server Processeshtt...
-
编辑 删除
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是数据仓库系统的主要应用，支持复杂的分析操作，侧重决策支持...
