[计算机软件及应用]OCP笔记.doc

OCP 第一章：Oracle 体系架构 1、oracle 网络架构及应用环境 2、oracle 体系结构 1）oracle server ：database + instance 2）database：data file 、control file 、 redolog file 3）instance（实例）：access a database oracle memory: sga + pga 4）instance ： sga + backgroud process 5）sga组成：sga 在一个instance只有一个sga，sga所有的session共享;随着instance启动而分配，instance down ，sga被释放。 查看OS分配给oracle的内存 [oracle@work oradata]$ ipcs Shared Memory Segments key shmid owner perms bytes nattch status 0x995eb2e8 65537 oracle 640 379584512 18 Semaphore Arrays key semid owner perms nsems 0xbe3edae0 98304 oracle 640 44 Message Queues key msqid owner perms used-bytes messages [oracle@work oradata]$ ipcs -m Shared Memory Segments key shmid owner perms bytes nattch status 0x995eb2e8 65537 oracle 640 379584512 18 Solaris [oracle@sun ~]$ipcs -a IPC status from running system as of Wednesday, May 9, 2012 10:27:20 AM CST T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME Message Queues: T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME Shared Memory: m 1 0xb8bd04d0 --rw-r oracle oinstall oracle oinstall 17 289411072 958 1086 10:26:08 10:27:13 9:43:18 T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME Semaphores: s 3 0xb694b4e4 --ra-r oracle oinstall oracle oinstall 154 10:27:14 9:43:20 启动实例会自动分配内存空间 10:29:07 SQL startup ORACLE instance started. Total System Global Area 289406976 bytes Fixed Size 1279820 bytes Variable Size 113248436 bytes Database Buffers 171966464 bytes Redo Buffers 2912256 bytes Database