OCM_Session1_8_Schema Statistics and Parameter File Configuration

8. Schema Statistics and Parameter File Configuration
 8.1 Compute statistics for the various schemas in the database as necessary for use with cost based optimization.
 8.2 Investigate the parameter file for reasonable sizes for each parameter listed. Add additional parameters as you deem necessary to support an optimal database environment. In addition,modify or add the following listed parameters:
      UTL_FILE_DIR=('/home/oracle','/home/oracle/temp','/home/oracle/scripts')
      Note: Applications that use Oracle 10g features will be running therefore,ensure the database and instance are appropriately configured.


参考联机文档:
PL/SQL Packages and Types Reference ==> 103 DBMS_STATS ==>GATHER_DATABASE_STATS Procedures



  • 8.1收集资料
  • 8.1 Compute statistics for the various schemas in the database as necessary for use with cost based optimization.不同schema收集资料
SQL> begin
  2  DBMS_STATS.GATHER_DATABASE_STATS(degree=>3);  这里的3表示并发的操作,也可以指定其他数字
  3  end;
  4  /

PL/SQL procedure successfully completed.

  • 8.2修改参数
  • 8.2 Investigate the parameter file for reasonable sizes for each parameter listed. Add additional parameters as you deem necessary to support an optimal database environment. In addition,modify or add the following listed parameters:修改或添加下列参数
  •       UTL_FILE_DIR=('/home/oracle','/home/oracle/temp','/home/oracle/scripts')
  •       Note: Applications that use Oracle 10g features will be running therefore,ensure the database and instance are appropriately configured.

[oracle@ocm1 Disk1]$ cd /home/oracle/
[oracle@ocm1 ~]$ mkdir temp
[oracle@ocm1 ~]$ ll
total 8
drwxr-xr-x 2 oracle oinstall 4096 Mar 19 14:22 scripts
drwxr-xr-x 2 oracle oinstall 4096 Mar 19 14:51 temp

此处注意题干给的有括号,而操作时没有括号
SQL>   alter system set utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts' scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                  1220360 bytes
Variable Size             163578104 bytes
Database Buffers          356515840 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值