It’s my life – 第 2 页

博客运行在vultr主机上一个月的性能数据

2016-12-20 没有评论

我申请的vultr主机是单核CPU，15GB的ssd的硬盘，768M内存，每月1TB的流量，对于ss来说已经完成足够，目前有日本，新加坡，美国，德国，荷兰，法国等地的服务器。价格是每月5刀（每小时0.007刀），首次注册，如果用我这个Summer Promo Code，你可以额为获得20刀的费用；或 […]

It's my life

给vbox磁盘空间扩容

2016-11-03 没有评论

我的vbox的根目录磁盘空间快不够用了，

[root@testdb2 ~]# df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/vg_testdb2-lv_root
                      27431124  21329720   4707948  82% /
tmpfs                  3481600        88   3481512   1% /dev/shm
/dev/sda1               495844     56258    413986  12% /boot
[root@testdb2 ~]#

1

2

3

4

5

6

7

[root@testdb2 ~]# df -k

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/mapper/vg_testdb2-lv_root

27431124 21329720 4707948 82% /

tmpfs 3481600 88 3481512 1% /dev/shm

/dev/sda1 495844 56258 413986 12% /boot

[root@testdb2 ~]#

我原来的oracle软件和数据，都放在根目录的/u01下，现在根目录已经82%了。我决定给vbox加一块盘，扩大根目录的空间。首先，在vbox的图形化界面添加一块硬盘。当然，如果不用图形 […]

It's my life

flashback standby database

2016-06-15 没有评论

Flashback之后的standby database如何打开，操作如下：

SQL> flashback database to restore point myrs1;

Flashback complete.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             356517912 bytes
Database Buffers          159383552 bytes
Redo Buffers                3780608 bytes
Database mounted.
SQL> 
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01665: control file is not a standby control file


SQL> 
SQL> 
SQL> alter database convert to physical standby;

Database altered.

SQL> 
SQL> 
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> 
SQL> startup
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             356517912 bytes
Database Buffers          159383552 bytes
Redo Buffers                3780608 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

SQL> flashback database to restore point myrs1;

Flashback complete.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 356517912 bytes

Database Buffers 159383552 bytes

Redo Buffers 3780608 bytes

Database mounted.

SQL>

SQL> alter database recover managed standby database using current logfile disconnect;

alter database recover managed standby database using current logfile disconnect

*

ERROR at line 1:

ORA-01665: control file is not a standby control file

SQL>

SQL> alter database convert to physical standby;

Database altered.

SQL>

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 356517912 bytes

Database Buffers 159383552 bytes

Redo Buffers 3780608 bytes

Database mounted.

Database opened.

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL>

..experience, It's my life, Working case

基于Solaris sparc的Oracle调优

2014-09-28 没有评论

一、RAC 中cluster wait time高问题 1.设置LMS进程为FX 60，不要过多调整lms进程的数量注：在Solaris 10 Update 10之后，以及Solaris 11，才可以设置进程的优先级。可以通过看/etc/release看其版本。如Oracle Solaris 10 […]

It's my life

安装数据库软件时，找不到所有节点

2014-07-29 没有评论

某客户用runInstaller安装RAC软件时，在勾选节点的窗口找不到任何的节点。我们可以参考mos上的这个文档进行修复。 Database runInstaller “Nodes Selection” Window Does not Show Cluster Nodes […]

It's my life

Oracle Database In-Memory 现场发布会视频

2014-06-17 没有评论

这是美国时间6月10日，拉里做的12c inmemory option的现场发布会。

It's my life

台湾之行（DAY ONE and DAY TWO）

2014-03-19 4条评论

这个月休了2周的年假，去了一趟台湾。在饱览台湾的人文之美后，我首先要感谢一下我的公司，甲骨文中国，如果放在别的单位，我估计我休假两周回来后，是否还留有我的岗位……有朋友说，回来之后写个攻略吧，嗯……怎么说呢，如果你按照我的攻略走，你也许不能完全体会到台湾的人文之美，台湾的美，要靠你搭乘它的捷运、扶梯 […]

It's my life

latch:transaction allocation

2014-02-28 没有评论

今天遇到一个sql，发生了大量的134的latch，134的latch是transaction allocation。数据库版本是9208. 该sql是：

SELECT DECODE(l.request, 0, 'Holder: ', 'Waiter: ') || l.sid sess,
       s.SQL_HASH_VALUE,
       l.id1,
       l.id2,
       l.lmode,
       l.request,
       l.type
  FROM V$LOCK l, v$session s
WHERE (l.id1, l.id2, l.type) IN
       (SELECT id1, id2, type FROM V$LOCK WHERE request > 0)
   and l.SID = s.SID
   and exists (select sw.seq#,
               sw.sid || ',' || s.serial# sids,
               s.username,
               s.SQL_HASH_VALUE
          from v$session_wait sw, v$session s, dba_objects a
         where sw.sid = s.sid
           and sw.event in ('latch free', 'enqueue')
           and s.status = 'ACTIVE'
           and sw.STATE = 'WAITING'
           and s.username is not null
           and sw.seconds_in_wait > 30
           and (a.object_id = s.row_wait_obj# or
               a.data_object_id = s.row_wait_obj#))
ORDER BY l.id1, l.request;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

SELECT DECODE(l.request, 0, 'Holder: ', 'Waiter: ') || l.sid sess,

s.SQL_HASH_VALUE,

l.id1,

l.id2,

l.lmode,

l.request,

l.type

FROM V$LOCK l, v$session s

WHERE (l.id1, l.id2, l.type) IN

(SELECT id1, id2, type FROM V$LOCK WHERE request > 0)

and l.SID = s.SID

and exists (select sw.seq#,

sw.sid || ',' || s.serial# sids,

s.username,

s.SQL_HASH_VALUE

from v$session_wait sw, v$session s, dba_objects a

where sw.sid = s.sid

and sw.event in ('latch free', 'enqueue')

and s.status = 'ACTIVE'

and sw.STATE = 'WAITING'

and s.username is not null

and sw.seconds_in_wait > 30

and (a.object_id = s.row_wait_obj# or

a.data_object_id = s.row_wait_obj#))

ORDER BY l.id1, l.request;

据客户反映，这个sql之前没有出现问题，只是昨天做了修改，增加了对v$sess […]

It's my life

Wnnn进程导致buffer busy wait

2013-11-21 没有评论

某日，在一个数据库中，发现大量buffer busy wait的进程，经检查，是监控等查询表空间使用率的进程处于buffer busy wait。而其blocking session wnnnn进程。 (1)看到监控程序被1013进程阻塞，blocking session是1013 [crayon- […]

..experience, It's my life, Working case

安装cluster时报错 PRVF-5636

2013-07-10 没有评论

之前写过一篇为rac建dns server的文章，今天在安装11.2.0.3的grid的时候报错 PRVF-5636 : The DNS response time for an unreachable node exceeded “15000” ms on followin […]

It's my life

12c开始的新一轮Lifetime Support

2013-06-27 没有评论

12c开始的新一轮Lifetime Support 注意，11gR2也有一段Waived Extended Support的时期，和9iR2和10gR2一样，在这一时期不加收10%费用。详情请咨询oracle销售。

It's my life

OOW 2012 keynote摘要

2012-10-01 一条评论

Oracle open world(oow) 2012于9月29日在美国旧金山如火如荼的展开了，开始的前两天，已经有不少激动人心的新产品和新特性发布了，在这里，我根据twitter，微博，youtube上的资料简单做了一些摘要，给大家先尝尝鲜，具体的完整信息，可能要的产品发布之后才能获得了。 Lar […]