> 文章列表 / Page 326

ORA-07445: [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x5A1113A] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ]一般是Windows平台上常见的内存不足问题引起，在64 bit 或 32bit 平台均可能发生，一般建议通过增加SGA_MAX_SIZE和SGA_TARGET(ASMM)来解决该问题...

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 ge...

there's no HWM for datafiles, it's just a virtual term to describe the last block containing data in the data file, which is the minimum size allowed for sizing down the data file. This article intend...

pga_aggregate_target is a target, as opposed to a hard limit – so it isn’t unusual to go above that. 13G above that, now that’s unusual though! There IS an enhancement request in, to make a hard-limit...

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; se...

事件 说明 例子 Event 10013 - Monitor Transaction Recovery 在Startup时跟踪事务恢复 ALTER SESSION SET EVENTS '10013 trace name context forever, level 1'; Event 10015 - Dump Undo Segment Headers- 在事务恢复后做Dump回退段头信息 ALT...

以下脚本用于列出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...

Value Name(s) Table method (TM lock) 0 No lock n/a 1 Null lock (NL) Used during some parallel DML operations (e.g. update) by the pX slaves while the QC is holding an exclusive lock. 2 Sub-share (SS) ...

From Vinod Haval's <Inside Overview of ASM Metadata> These Views helps in understanding the following metrics Physical Mapping Provides Undocumented Information 18 X$ Tables (May be more) TABLE ...

View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ADDR RAW(4) address of this row/entry in the SGA INDX...