OCM_Session1_8_Schema Statistics and Parameter File Configuration
来源:互联网 发布:淘白菜淘宝客 编辑:程序博客网 时间:2024/06/04 19:31
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
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_stats.htm#CIHEHDFB
- 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
- OCM_Session1_8_Schema Statistics and Parameter File Configuration
- ubuntu u盘启动错位:missing parameter in configuration file
- DOCSIS config file-Configuration File and Registration Settings
- params.c:Parameter() - Ignoring badly formed line in configuration file: ignore errors 解决方法
- Call WCF Rest Service without svc file and wcf configuration
- Index and Statistics
- Statistics and Operation
- Medians and Order Statistics
- 重学Statistics,Cha1 Data and Statistics
- Oracle 11gExtension Statistics and Expression Statistics
- Control File and Server Parameter File Autobackup Options实验详细解析
- Phred Parameter File Problems
- 53.You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TAR
- STATSPACK and AWR Statistics Comparison
- STATSPACK and AWR Statistics Comparison
- Ural 1548 Sakura and Statistics
- Probability and statistics (part I)
- graphic and parameter EQ
- vector实现(待补充)
- 【COCOS2DX-BOX2D游戏开发之二】 Box2d教程链接
- java--封装
- sharepoint2010 当人员控件显示为中文姓名时 如何获得此人的登录名--SPFieldUserValue用法
- python判断文件和文件夹是否存在、创建文件夹
- OCM_Session1_8_Schema Statistics and Parameter File Configuration
- 在 Web 项目中应用 Apache Shiro
- 机器学习系列(2):logistic回归,贝叶斯(bayes)方法
- 【ObjC那点儿事儿】block练习
- 修改MySql默认编码
- 砝码称重
- sicily 1136 山海经
- Windows C++迁移Linux C++问题集锦
- 快速排序非递归算法的java实现