RAC功能:fail over
負載均衡
并行查詢
LSNRCTL:靜態和動態
Alter system register; 立加加入LSNRCTL
Netmgr配置TNS
HD格式:FS:CFS
RAW
ASM
DATABASE三個文件:data file,control file,redo log file
執行語句過程:
1. connect
2. 語法檢查
3. 權限
4. 對象是否存在
5. 執行計划
6. 查看內存是否有數據
7. 若無,從HD讀取數據到內存
8. 返回給client
SGA兩個參數:SGA_MAX_SIZE靜態參數,SGA_TARGET動態參數
SGA可自動管理和手動管理
Alter system set sga_max_size=XX scope=pfile;
Alter system set sga_target=XX scope=both;(spfile or memory or pfile)
Shared_pool_size(只能合并指定大小):data dictionary cache,library cache
Library cache:store SQL and PL/SQL
Database Buffer cache參數:DB_CACHE_SIZE,跳過LRU:DB_KEEP_CACHE_SIZE,DB_RECYCLE_CACHE_SIZE
DB_BLOCK_SIZE參數determines primary block size
V$DB_CACHE_ADVICE建義參數
Redo log buffer參數:log_buffer
查看后台進程:ps aux |grep ora_
查看服務進程:ps aux |grep oracle
DBWn隨機寫:1.Dirty buffers reach threshold
2.check point occurs
3.no free buffers
4.timeout occurs
5.RAC ping request is made
6.tablespace offile or read only or Begin backup
7. table truncate or drop
LGWR(WAL:日志先寫原則)順序寫:1.After commit
2.when 0ne-third full
3.wher there is 1 MB of redo
4.every three seconds
5.Before DBWn writes
SMON:1.instance recovery
2.Coalescence(合并) free space
3.Deallocates temporary segments
PMON:1.Rolling back the transaction
2.Release locks
3.Releasing other resources
4.Restarting dead dispatches
CKPT: 1.signaling DBWn at checkpoints
2.Update datafile headers with checkpoint information
3.Updating control files with checkpoint information
ARCn:
V$FIXED_TABLE see all view names
ROWID包括:塊號,塊內行號(偏移號),從屬于哪個對象
段管理:自動管理---bitmap管理
手動管理—freelist管理
表空間管理:本地管理—表空間級別管理,bitmap管理
數據字典管理
啟動 vi /etc/oratab vi /etc/hosts vi /etc/rc.d/rc2.d (0:shutdown;2,3,5:startup;6:reboot)
執行$oracle_home/bin/dbstart
$oracle_home/bin/dbshut
Grant connet,resource to outuser;
Connet:是ROLE,包括create session
Authentication :password
External—OS
Global –ldap
OS創建用戶:useradd t_user
useradd –G oinstall t_user
刪除用戶:groupdel t_user
Userdel t_user
su:有“-”,進行環境切換,沒有,則繼承
xhost +
alter user t_user account unlock/lock/expired
Data Integrity:
1. 實體完整性—PK
2. 參照完整性—FK
3. 域完整性—數據類型及取值范圍,約束
4. 用戶自定義完整性—自行定義
PK=UK(NOT NULL),UK可以為null
Disable NOVALIDATE:原數據不check,新數據不check
Enable NOVALIDATE:原數據不check,新數據check
Disable VALIDATE :原數據check,新數據不check
Enable VALIDATE :原數據check,新數據check
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/784441/viewspace-681705/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/784441/viewspace-681705/