Author: Louis Liu

由于此前的mysql salve服务器没有进行规划,一些参数都是使用的默认参数,导致innodb datafile 无限制增长,所以需要重新规划一下datafile空间的分配,以及其他参数的优化

version:

mysql>
mysql>
mysql> select version([……]

Read more

Regular Pages and HugePages

This section aims to give a general picture about memory access in virtual memory systems and how pages are referenced.[……]

Read more

修改过的show_space 支持ASSM

create or replace
procedure show_space
( p_segname_1 in varchar2,
p_space in varchar2 def[……]

Read more

NOLOGGING is supported in only a subset of the locations that support LOGGING. Only the following operations support the NOLOGGING mode:
DML:
1. Dir[……]

Read more

今天遇到一个奇怪的问题，3个logic standby 中有一个delay 查看任何日志都没有发现错误，有一个transaction在apply一个SQL，这条SQL没有任何问题，SQL所涉及到的表也没有任何问题
当时的apply情况如下：

SID USERNAME MACHINE[……]

Read more

Alter session set sql_trace=true;
Alter session set STATISTICS_LEVEL = ALL;

set echo off verify off termout off
set doc off
doc
— ———-[……]

Read more

收到开发人员报告，oracle出现坏块，信息如下：

Hex dump of (file 7, block 1407500) in trace file /data/oracle/admin/orcl/bdump/orcl_p004_7383.trc
Corrupt block relativ[……]

Read more

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance
Modified 04-AUG-2010 Type BULLETIN Status ARCHIVED
In this[……]

Read more

Oracle Wallet的使用

最近看到一封邮件，该网友提出了如下需求：

This is not exactly an Oracle question, but I am asking it here in case
someone has solved this. We hav[……]

Read more

分区表中 local 索引的维护会在oracle 操作表分区的时候自动进行，需要注意的是global 索引，当global索引所在表执行alter table 涉及下列操作时，会导至该索引失效，需要重新建立：

——————————-[……]

Read more