ORACLE STUDY STEP BY STEP

第一天
1.Oracle全备份数据，首先，先把数据库关闭了。
SQL>shutdown immediate
SQL>host F:\oracle\product\10.1.0\oradata\orcl\*.* E:\oracle\backup
SQL>host F:\oracle\product\10.1.0\db_1\database\*.* E:\oracle\backup\database
2.嘎嘎,查看一下控制文件
select * from v$controlfile;
3.更改数据库高速缓存区大小
alter system set db_cache_size=48m;
4.修改共享池大小
alter system set shared_pool_size = 32m;
5.内存缓冲区顾问we can process the sql to see the detail message about 内存缓冲
区:select id ,name , block_size , advice_status from v$db_cache_advice;besides,we can
execute the sql to alter the status of 内存缓冲区:alter system set db_cache_advice =
off.
6.we cat get the 内存缓冲区信息 when we execute "show sga" or "select name , type ,
value from v$parameter;" about 254 records can you get.