-
编辑 删除
Use of the NVL2 Function[akadia]
NVL2: check for the existence of NOT NULLMost of us are familiar with the NVL function which checks for the existence of NULL values. Oracle provides a new function called NVL2 which checks for the ex...
-
编辑 删除
部署了一个Data Guard数据库
os:p570 aix5.3db:oracle9.2.0.4 两边都是裸设备管理 存储是异地的.模式：采用最大性能并多次测试了switchover功能[连用户和新来的同事都练了手],挺爽的.经验教训：关键时候还是要看oracle的官方文挡，网上的很多帖...
-
编辑 删除
The Power of Inline Views[akadia]
A subquery in the FROM clause of a SELECT statement is also called an inline view. When a query contains an inline view, the inline is merged into the query. Powerful constructs can be built using inl...
-
编辑 删除
Oracle Applications Release 10.7 Installation Checklist
最近在做一个ERP项目http://appsdba.omp.net/oa_check.htmAuthor: Andy Rivenes (arivenes@appsdba.com)Copyright AppsDBA Consulting, all rights reservedLast Updated: September 1, 1999 This is a checklist th...
-
编辑 删除
ora-00600[6302]错误解决一例
一个旅业系统,insert数据库时偶尔会抱:ora-00600[6302][8]经检查,是跟index的pctfree(=5)过小有关,加大到10,重建所有的索引,ok
-
编辑 删除
How to connect to a system regardless of machine failure ? [akadia]
You can place multiple address entries for a single connection alias in the TNSNAMES.ORA file. This means that you can connect to a database, even if some kind of physical failover occurred. Look at t...
-
编辑 删除
64位曙光x86_64 linux 安装64位的oracle9204
遇到一个link出错，参考以下博客后解决：http://yangtingkun.itpub.net/在安装过程中，报错误： Error in invoking target install of makefile /opt/oracle/product/9.2/rdbms/lib/ins_rdbms.mk ，这里也点击 ignor...
-
编辑 删除
Sizing of Locally Managed Tablespaces[from akadia]
More and more we are using locally managed tablespaces. They offer a large amount of benefits, so why should we not use this new feature?Some thoughts are needed when you decided to use Uniform Extent...
-
编辑 删除
Top-N SQL queries with Inline Views[akadia]
Top-N queriesSuppose you want to retrieve and sort information on the 4 most recently hired employees in a very efficient way. This can be achieved using an inline view combined with ORDER BY and ROWN...
-
编辑 删除
Speed up Queries using Function based Indexes[akadia]
When you use an application that often select rows based on an expression, then a function based index (an index on a function) can help to avoid full table scans. A function-based index is based on e...
-
编辑 删除
磁盘柜的常用操作(控制卡为hsz70)
1.磁盘柜的连接2.添加盘 (add disk disk-name scsi-location )3.删除盘 (delete disk-name)4.添加镜像(add mirrorset mirrorset-name disk-names)5.手工移掉镜像中的盘 (set mirrorset-name remove=disk-name)6.手工...
-
编辑 删除
oracle中有没有针对字符串做位运算的方法 ？
4pal提出如下问题：数据库中有如下数据：字段1 字段21 0a0000001 c00000001 00000b001 000a00002 0000000d2 00000a003 0c0000003 0000b0003 000000g0......字段2是个N位字符串，有规律的，要么全部是0，要么只有一位...
-
编辑 删除
一个在8i上运行很好,但在9i上很慢的sql语句
上周六在支队遇到的 下面这个SQL,在8174上很快,但在9204上很慢.select aaa from tabname where sfzh = username.pg_name.functionname(bbb);其中:select aaa from tabname where sfzh = ... 很快.单独调用 username....
