摘要：
第八章： managing password security and resources 1.controlling account lock and password sql> alter user juncky identified by oracle account unlock; 2.us 阅读全文
posted @ 2007-06-26 17:44 徐正柱- 阅读(638) 评论(1) 推荐(0) 编辑
摘要：
第六章：load数据 1.loading data using direct_load insert sql> insert /*+append */ into emp nologging sql> select * from emp_old; 2.parallel direct-load insert sql> alter session enable parallel dml; sql> insert /*+parallel(emp,2) */ into emp nologging sql> select * from emp_old; 3.using sql 阅读全文
posted @ 2007-06-26 17:43 徐正柱- 阅读(430) 评论(1) 推荐(0) 编辑
摘要：
第四章：索引 1.creating function-based indexes sql> create index summit.item_quantity on summit.item(quantity-quantity_shipped); 2.create a b-tree index sql> create [unique] index index_name on table_name(column,.. asc/desc) tablespace sql> tablespace_name [pctfree integer] [initrans integer] [ma 阅读全文
posted @ 2007-06-26 17:41 徐正柱- 阅读(405) 评论(1) 推荐(0) 编辑
摘要：
一、ORACLE的启动和关闭1、在单机环境下要想启动或关闭ORACLE系统必须首先切换到ORACLE用户，如下su-oraclea、启动ORACLE系统oracle>svrmgrlSVRMGR>connectinternalSVRMGR>startupSVRMGR>quitb、关闭ORACLE系统o... 阅读全文
posted @ 2007-06-26 17:37 徐正柱- 阅读(276) 评论(0) 推荐(0) 编辑
摘要：
第十二章: BACKUP and RECOVERY 1. v$sga,v$instance,v$process,v$bgprocess,v$database,v$datafile,v$sgastat 2. Rman need set dbwr_IO_slaves or backup_tape_IO_slaves and large_pool_size 3. Monitoring Parallel Rollback > v$fast_start_servers , v$fast_start_transactions 4.perform a closed database backup .. 阅读全文
posted @ 2007-06-26 17:36 徐正柱- 阅读(312) 评论(1) 推荐(0) 编辑
摘要：
第一章：日志管理 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4] sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log m 阅读全文
posted @ 2007-06-26 17:30 徐正柱- 阅读(507) 评论(1) 推荐(0) 编辑