>ASKMACLEAN_

> 文章列表 / Page 328

2008-10-29

Network Interface No Longer Operational?

Solaris平台上的Oracle数据库，Alert日志偶尔会出现”Network Interface No Longer Operational”的相关记录： ospid 11223: network interface with IP address 192.4.1.22 no longer operational requested interface 192.4.1.22 ioctl…
#POST 1 MIN READ
2008-07-08

Know about Oracle High Water Mark

there’s no HWM for datafiles, it’s just a virtual term to describe the last block containing data in the data…
#POST 11 MIN READ
2008-07-03

Gather DBMS_STATS Default parameter

What are the default parameter values ? select dbms_stats.get_param('cascade') from dual; select dbms_stats.get_param('degree') from dual; select dbms_stats.get_param('estimate_percent') from dual; select…
#POST 1 MIN READ
2008-06-30

Oracle常用诊断事件清单

事件 说明 例子 Event 10013 – Monitor Transaction Recovery 在Startup时跟踪事务恢复 ALTER SESSION SET EVENTS ‘10013 trace name context forever, level…
#POST 5 MIN READ
2008-06-25

Script:Datafile Report

以下脚本用于列出Oracle中数据文件的状况: REM Datafile Report set linesize 120 pagesize 1400; SELECT t.tablespace_name, 'Datafile' file_type, t.status tablespace_status, d.status file_status, ROUND((d.bytes - NVL(f.sum_bytes,…
#POST 2 MIN READ
2008-06-22

Know Oracle Lock Mode

Value Name(s) Table method (TM lock) 0 No lock n/a 1 Null lock (NL) Used during some parallel DML operations…
#POST 3 MIN READ
2008-06-19

Fixed X$ Tables in ASM

From Vinod Haval‘s <Inside Overview of ASM Metadata> These Views helps in understanding the following metrics Physical Mapping Provides Undocumented…
#POST 2 MIN READ
2008-04-19

EVENT 10051:"trace OPI calls"

Error:  ORA 10051 Text:   trace OPI calls ——————————————————————————- Explanation: This is NOT an error but is a special EVENT code.…
#POST 1 MIN READ