Oracle Tips 1 (Oracle Architectural Components)
来源:互联网 发布:个性定制软件 编辑:程序博客网 时间:2024/04/28 16:15
Oracle Server consists of an Oracle instance and an Oracle database
instance: memory structure, background process
database: datafile, log file, control file
shutdown immediate
startup nomount
alter database mount;
alter database open;
show sga;
select * from v$bgprocess
select * from v$logfile
select * from v$controlfile
show parameter shared
SGA is dynamic and sized using SGA_MAX_SIZE
show parameter sga;
alter system set db_cache_size=640m;
Shared pool is used to store the most recently executed SQL statements and the most recently used datadefinitions.
Database Writer(DBWn) writes when: CheckPoint, Dirty buffers threshold reached, No free buffers, Timeout, RAC ping request, Tablespace read only, Table DROP OR TRUNCATE, Tablespace BEGIN BACKUP.
Log Writer(LGWR) writes when: write commit, one-third full, there is 1 MB of redo, every 3 secods, before DBWn writes.
System Monitor(SMON) Responsibilities: instance recovery, Coalesces free space ever 3 sec, Deallocates temporary segments.
Process Monitor(PMON) cleans up after failed processes by: rolling back the transaction, releasing locks, releasing other resource, restarts dead dispatchers.
Checkpoint(CKPT) Responsible for: Singanlling DBWn at checkpoints, Updating datafier headers with checkpoint information, Updating control file with checkpoint information.
Archiever(ARCn) Optional background process, Automatically carchieves online redo logs when ARCHIVELOG mode is set, Preserves the record of all change made to the database.
- Oracle Tips 1 (Oracle Architectural Components)
- OCP第一课:Oracle Architectural Components
- Fundamental I 01 Oracle Architectural Components
- ORACLE学习笔记:Chapter 01--Oracle Architectural Components
- ORACLE学习笔记:Chapter 02--Oracle Architectural Components
- ORACLE学习笔记:Chapter 03--Oracle Architectural Components
- ORACLE学习笔记:Chapter 04--Oracle Architectural Components
- Oracle Architectural(Oracle 体系结构)!!!
- 第一章 Oracle Architectural基础结构
- Oracle Tips
- Oracle - Tips
- Oracle Tips
- Oracle tips
- Oracle RAC Clusterware Components
- Oracle Architecture Components
- Oracle Data Access Components (ODAC)
- Oracle学习笔记_Oracle体系结构1_Primary Components
- Oracle FAQs and Tips
- HttpHand和HttpModule的详细解释,包括Asp.Net对Http请求的处理流程。 .
- 数字图像处理--空间变换
- Word快捷键大全
- c语言中标识符的链接属性简介
- 虚拟主机上用Asp.net实现Urlrewrite .
- Oracle Tips 1 (Oracle Architectural Components)
- WM_LBUTTONDBLCLK和WM_LBUTTONDOWN的触发解决方法
- 本来想写点什么的,可是近阶段忙着项目,没有时间
- ASP.net实现无扩展名的URL重写。简单、方便、无需ISAPI .
- android adb常用指令
- 程序如何在32位机子上支持大文件读写
- LED驱动实例5(信号量+udev)
- 电脑/计算机快捷键
- APSys'2011见闻