⌘KCtrl+K 快速搜索

> 文章列表 / Page 251

2011-09-09

了解高水位与truncate

什么是High Water Mark 高水位? "The high water mark starts at the first block of a newly created table. Ads data is inserted, the high water mark rises. And the HWM will remain at that level in spite of dele...
#POST 16 MIN READ
2011-09-08

Exadata用户的困境

当然这是Oracle-Sun Exadata V2 数据库一体机的竞争者,Netezza公司制作的一个小视频,但并非空穴来风! 很多人告诉我有了Exadata这么智能的一体机后都可以不需要dba了,那么这是事实吗? 就我个人的体验,部署了Exadata之后DBA花在管理上的时间更多了。 Exadata上复杂的数据库升级步骤: Infiniba...
#POST 4 MIN READ
2011-09-08

LIBCLNTSH.SO: WRONG ELF CLASS: ELFCLASS32错误一例

某套数据库以dba组用户登录正常,但以非dba组用户登录时出现LIBCLNTSH.SO: WRONG ELF CLASS: ELFCLASS32错误,如下例子: su - maclean sqlplus ld.so.1: sqlplus: fatal: /s01/orabase/product/10.2.0/dbhome_1/lib32/libclntsh.so.10.1 : wrong ELF ...
#POST 10 MIN READ
2011-09-08

Booting Exadata!

Booting Exadata! It's a joke here!.
#POST 1 MIN READ
2011-09-08

dbms_logmnr Unsupported SQLREDO

Question: Try Testing Oracle Logminer SQL> create table maclean (t1 varchar2(100)) tablespace users; Table created. SQL> insert into maclean values ('MACLEAN'); 1 row created. SQL> com...
#POST 7 MIN READ
2011-09-08

Know more about RAC statistics and wait event

以下列出了RAC中的主要统计信息和等待事件: 1. Statistics: 1.1 V$SYSSTAT, V$SESSTAT (join to V$STATNAME) gc cr blocks served gc cr block build time gc cr block flush time gc cr block send time gc current blocks ser...
#POST 14 MIN READ