ITPub博客

并行cpu查询分区表测试 12月01日(星期四) 这篇文章是回应玉面飞龙所提出的均匀分布数据的情况而实验测试均匀数据分布的并行查询与非并行查询，结果是均匀数据分布的并行查询要优于非并行查询测试环境: OS: HP9000 DB:9201(数据文件分布在裸设备上)[@more@]并行cpu查询分区表测试 12月01日(星期四) 这篇文章是回应玉面飞龙所提出的均匀分布数据的情况而实验测试均匀数据分布的并行查询与非并行查询，结果是均匀数据分布的并行查询要优于非并行查询测试环境: OS: HP9000 DB:9201(数据文件分布在裸设备上)1.创建一个200M的data1逻辑卷，在系统

1.用sys用户运行脚本ultxplan.sql建立这个表的脚本是：（UNIX:$ORACLE_HOME/rdbms/admin, Windows:%ORACLE_HOME%rdbmsadmin）ultxplan.sql。SQL> connect sys/sys@colm2 as sysdba;SQL> @C:oracleora92rdbmsadminutlxplan.sql;SQL> create public synonym plan_table for plan_table; --建立同义词SQL> grant all on plan_table to public;--授权所有用户[@more@]1.用sys用户运行脚本ultxplan.sql建立这个表的脚本是：（UNIX:$ORACLE_HOME/rdbms/admin, Windows:%ORACLE_HOME%rdbmsadmin）ultxplan.sql。SQL> connect sys/

.bash_profile#export LD_ASSUME_KERNEL=2.4.20export ORACLE_BASE=/export/home/oracleexport ORACLE_HOME=$ORACLE_BASE/9iexport ORACLE_SID=ECOMexport ORACLE_TERM=xtermexport ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/libexport LD_LIBRARY_PATHexport PATH=$PATH:$ORACLE_HOME/binexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport

oracle92安装 如果是一台干净的机器，一般是一路顺利，最后通过dbca配置等。如果以前安装过oracle10client等，导致环境变量对oracle92有影响后， dbca等工具就会配置失败。 这样的话默认的sid没有创建[@more@]oracle92安装 如果是一台干净的机器，一般是一路顺利，最后通过dbca配置等。如果以前安装过oracle10client等，导致环境变量对oracle92有影响后， dbca等工具就会配置失败。 这样的话默认的sid没有创建成功， connect / as sysdba时就会弹出：ORA-12560修改的方法有： （1） 修改环境变量使dbca能够启动创建默认数据库， 启动对应s

手工创建oracle数据库-数据库专家作者：佚名 文章来源：不详 [@more@]系统环境： 1、操作系统：Windows 2000 Server2、数据库：　Oracle 8i R2 (8.1.6) for NT 企业版/Oracle 9i for NT 企业版3、安装路径：D:ORACLE步骤：1、手工创建相关目录2、手工创建初始化参数文件3、通过oradim创建一个ORACLE服务4、创建数据库5、创建数据库数据文件，执行脚本6、创建数据字典，运行手工创建数据库完整步骤系统环境操作系统：Windows 2000 Server 数据库：Oracle 9i安装路径：C:Oracle1、手工创建相关目录C：OracleadminwebC：OracleadminwebbdumpC

#!/bin/sh# Linxs ck_tablespaces.shsqlplus $1/$2@$3 <<EOFset feed offset lines 160set pagesize 999[@more@]#!/bin/sh# Linxs ck_tablespaces.shsqlplus $1/$2@$3 <<EOFset feed offset lines 160set pagesize 999col tablespace_name format a10col DBfile_name format a50col b.file_id format a10spool $4.txtselect b.file_id,b.FILE_NAME DBfile_name,b.tablespace_name,b.bytes,b.maxbytes maxbytes,( b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) SHENGYU,sum(nvl(a.bytes,0))/(b.bytes)*100 SHENYUpre

Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference[@more@]Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference必须打patch，安装patch 3006854，然后可以启动runInstaller；//跟踪$ORACLE_HOME/9i/install/make.log文件报错:/export/home/orac

　　1、说一说Oracle的Optimizer及其相关的一些知识。　　　　2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。　　　　3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。[@more@]　　本文的目的：　　　　1、说一说Oracle的Optimizer及其相关的一些知识。　　　　2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。　　　　3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。　

Modify /etc/sysctl.conf, add the following content:[@more@]Modify /etc/sysctl.conf, add the following content:kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.shmall = 2097152 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000If you have more then 2G ram, you can set kernel.shmmax = 2147483648

declare i integer; begin i:=1; loop insert into T(ID, dt, VALUE) values(SEQ.nextval, to_date('2005-10-10', 'YYYY-MM-DD'),i);i:=i+1; exit when i>10; end loop;commit;end;/[@more@]declare i integer; begin i:=1; loop insert into T(ID, dt, VALUE) values(SEQ.nextval, to_date('2005-10-10', 'YYYY-MM-DD'),i);i:=i+1; exit when i>10; end loop;commit;end;/

<?xml version = '1.0'?><DatabaseTemplate name="scripts" description="" version="9.0.1"><CommonAttributes><option name="Oracle Ultra Search" value="true"/><option name="Oracle Label Security" value="false"/><option name="Oracle JVM" value="true"/><option name="Oracle Spatial" value="true"/><option name="Oracle Intermedia" value="

============oracle 816 /etc/oratab=============ANET:/export/home/oracle/8.1.6:N =============oracle 9i /etc/oratab==============ECOM:/export/home/oracle/9.0.1:N =============oracle 817 /etc/oraInst.loc=============inventory_loc=/export/home/oracle/oraInventoryinst_group=dba =============oracle 9i /etc/oraInst.loc==============inventory_loc=/export/home/oracle/ora9i/oraInventoryinst_group=dba [@more@]============oracle 816 /etc/oratab=============ANET:/export/home/oracle/8.1.6:N =============orac

=================oracle 817===============. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.shexport LD_ASSUME_KERNEL=2.2.5export LDEMULATION=elf_i386_glibc21[@more@]=================oracle 817===============. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.shexport LD_ASSUME_KERNEL=2.2.5export LDEMULATION=elf_i386_glibc21export GCC_EXEC_PREFIX=/usr/i386-glibc21-linux/lib/gcc-lib/export ORACLE_BASE=/export/home/oracleexport ORACLE_HOME=$ORACLE_BASE/817export PATH=$PATH:$ORACLE_HOME/binexpo

db_name=DEFAULTdb_files = 80 # SMALL[@more@]db_name=ECOMdb_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL # db_block_buffers = 100 # SMALL --oracle 9i已经废除 shared_pool_size = 3500000 # SMALLlog_checkpoint_interval = 10000processes = 50 # SMALL parallel_max_servers = 5 # SMALLlog_buffer = 32768 # SMALLmax_dump_file_size = 10240 # limit trace file size to 5 Meg eachglobal_names = TRUEcontrol_files = (ora_control1, ora_control2)

db_name=""db_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL db_block_buffers = 100 # SMALL [@more@]db_name=""db_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL db_block_buffers = 100 # SMALL shared_pool_size = 3500000 # SMALLlog_checkpoint_interval = 10000processes = 50 # SMALL parallel_max_servers = 5 # SMALLlog_buffer = 32768 # SMALLmax_dump_file_size = 10240 # limit trace file size to 5 Meg eachglobal_names = TRUEcontrol_files = (ora_control1, or

*.aq_tm_processes=1*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'*.compatible='9.2.0.0.0'*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'[@more@]*.aq_tm_processes=1*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'*.compatible='9.2.0.0.0'*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/

db_name = "ANET"instance_name = ANETservice_names = ANETcontrol_files = ("/export/home/oracle/oradata/ANET/control01.ctl", "/export/home/oracle/oradata/ANET/control02.ctl",[@more@]db_name = "ANET"instance_name = ANETservice_names = ANETcontrol_files = ("/export/home/oracle/oradata/ANET/control01.ctl", "/export/home/oracle/oradata/ANET/control02.ctl", "/export/home/oracle/oradata/ANET/control03.ctl")open_cursors = 100max_enable

cat ANETrun1.sh#!/bin/shORACLE_SID=ANETexport ORACLE_SID[@more@]cat ANETrun1.sh#!/bin/shORACLE_SID=ANETexport ORACLE_SID/export/home/oracle/8.1.6/bin/svrmgrl << EOFspool /export/home/oracle/admin/ANET/create/crdb1.logconnect internalstartup nomount pfile = "/export/home/oracle/admin/ANET/pfile/initANET.ora"CREATE DATABASE "ANET"maxdatafiles 254maxinstances 8maxlogfiles 32character set ZHS16GBKnational character set ZHS16GBKDATAFILE '/export/home/oracle/oradata/ANET/syst