- 博客(15)
- 收藏
- 关注
原创 Oracle instance & media recovery structure
<br />1、large pool:备份恢复时使用(rman) 若不设置则使用sharedpool<br />2、表空间备份策略:<br /> system:备份频度轻,用户数据不要放在system<br /> temporary:不需要备份<br /> undo:当作用户数据表空间备份恢复,非常重要<br /> readonly:每次修改后备份<br /> highly volatile data:用户表空间,
2010-10-14 09:15:00 1011
原创 Oracle backup and recovery overview
<br />1、increase mean-time-between-failures mtbf ,decrease mean-time-to-recovery mttr<br />2、failures types:<br /> statement failure:语句错误,权限不足,空间不足<br /> user process failure:用户session被kill,程序有bug断开连接 》》pmon负责解决,无需手工干预<br />
2010-10-12 11:29:00 568
原创 Oracle Manage Shared Server
<br />1、server type: dedicate,shared<br />2、dedicate:client:server 1:1<br />3、listener create dedicate server for us (use fork exec in unix)<br />4、shared:dispatcher process,Shared server process <br /> one dispatcher server 250-300 client<b
2010-10-11 15:12:00 471
原创 Oracle Naming method configuration
1、easy connect naming : connect username/password@host:port/service_name/server/instance(windows下cmd直接sqlplus user/pass在任务管理器中容易泄漏信息,可以sql
2010-10-11 09:18:00 1892
原创 Oracle net server side configuration
<br />1、listener 传递连接 types: spawns and bequeaths(父子),hands off(邻居),redirect(某些操作系统不能传递socket连接)<br />2、service config register: dynamic, static (使用OEM需要static)<br />3、listener 中host需要在 /etc/hosts配置<br />4、工具:netca netmgr
2010-10-08 09:58:00 478
原创 Oracle net architecture
<br />1、jdbc drivers :oci,thin(性能高)<br />2、service name: show parameter service<br />3、pmon process provide information to listener(db name ,instance name,service handler )<br />4、pmon every 60s to register listener , during this can immediately : alt
2010-10-08 09:56:00 356
原创 Oracle net
<br />1、向后兼容: 客户端高版本可访问服务端低版本 <br />2、shared server 用于多用户连接<br />3、oracle connection manager,encryption?
2010-10-08 09:55:00 343
原创 Oracle Globalization support
<br />1、character sets , national character sets<br />2、超集 :ascii<iso 8859-1 <br /> 配置情况需服务器>客户机,反之造成数据丢失<br />3、查看系统字符集 select * from nls_database_parameters<br />4、主字符集 NLS_CHARACTERSET 辅助:NLS_NCHAR_CHARACTERSET<br />5、length semantics :byt
2010-10-08 09:47:00 682
原创 Oracle load data into db
<br />1、direct load types:serial, parallel<br />2、串行:insert /*+ append */ into emp nologging select * from t_employees<br /> 数据直接插入hwm后面,速度最快,块对块拷贝,commit后才可查询<br />3、并行:alter session enable parallel dml;<br /> insert /*+ parallel(hr.
2010-10-08 09:41:00 815
原创 Oracle auditing
<br />1、types:standard,fine-grained(细粒度),administrator<br />2、信息存放在os日志文件或db中(sys.aud$)<br /> <br /> <br />数据字典:<br />dba_audit_trail<br />dba_common_audit_trail<br />dba_audit_(trail|exists|object|session|statement)
2010-10-08 09:36:00 459
原创 Oracle manage roles
<br />数据字典:<br />dba_roles<br />dba_role_privs<br />role_role_privs<br />role_sys_privs<br />role_tab_privs<br />session_roles
2010-10-08 09:32:00 344
原创 Oracle manage privilege
<br />1、privilege types:system ,object<br />2、grant revoke any <br />3、grant create session to usr1 with admin option;授权传递,撤销无法传递<br />4、select any table<br />5、grant select on t to u3;<br />6、grant grant any object privileges to u2;<br />7、with g
2010-10-08 09:31:00 372
原创 Oracle manage user
<br />1、user=(schema)<br />2、user default tablespace :sys<br />3、认证类型:<br /> 数据库认证<br /> 操作系统认证前缀字符串 default ops$<br />4、drop user 不删除用户的对象 需要加cascade参数<br /><br /><br />数据字典:<br />dba_users<br />dba_ts_quotas
2010-10-08 09:28:00 350
原创 Oracle manage password security resource
<br />1、每个用户一个profile<br /><br /><br />数据字典:<br />dba_users<br />dba_profiles
2010-10-08 09:26:00 474
原创 Oracle maintain data integrity
<br />1、data integrity:app code ,db trigger, integrity constraint 优先级增高<br />2、constraints type: not null,unique,primary key,foreign key,check<br />3、unique: allow null value foreign key:allow null value<br />4、primary key: alter table (enable|disable
2010-10-08 09:23:00 532
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人