-
编辑 删除
sql tuning (three utilities)
1. using the explain plan The EXPLAIN PLAN tool is great for this experimentation, as it immediately lets you know how the query will perform. with each change in the code...
-
编辑 删除
segregated among tablespaces
The following bulleted points identify some of the conditions you might use to determine how segments should be segregated among tablespaces. They are not prioritized here because the priority depends...
-
编辑 删除
create index-organized table
How to create index-organized table===key clauseORGANIZATION:The ORGANIZATION clause lets you specify the order in which the data rows of the table are stored.INCLUDING column_name:Specify a column at...
-
编辑 删除
create the database manually
1. ORACLE_SID=ocm export ORACLE_SID2. orapwd file=$ORACLE_HOME/dbs/orapwocm password=sys entries=10 force=y3. cd $ORACLE_BASE mkdir -p ocm/bdump mkdir -p ocm...
-
编辑 删除
install oracle on redhat9
1. check the memory grep MemTotal /proc/meminfo（physical） grep SwapTotal /proc/meminfo（swap）2. check the package rpm -p rpm -q make gcc glibc compat-db compat-g...
-
编辑 删除
硬解析和软解析
开篇：不积跬步，无以至千里1.硬解析和软解析（如果硬分析率每秒大于100，则认为硬分析过多）p932 分析软硬解析的方法有几种？ 1. sql trace, tkprof查看分析信息 &...
