oracle 系统drop 事件,drop tablespace temp~等待事件 enq: TS - contention

ODM DATA:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_2

System name:    Linux

Node name:      game

Release:        2.6.9-55.ELsmp

Version:        #1 SMP Fri Apr 20 17:03:35 EDT 2007

Machine:        i686

==> 10.2.0.5 on Linux x86

[root@vrh2 ~]# awk -f ass109.awk wending_ora_2545.trc

Blockers

~~~~~~~~

Above is a list of all the processes. If they are waiting for a resource

then it will be given in square brackets. Below is a summary of the

waited upon resources, together with the holder of that resource.

Notes:

~~~~~

o A process id of '???' implies that the holder was not found in the

systemstate.

Resource Holder State

Enqueue TS-00000003-00000001     8: waiting for 'smon timer'

Object Names

~~~~~~~~~~~~

Enqueue TS-00000003-00000001

SMON 持有Enqueue TS-00000003-00000001     ，SMON本身  'smon timer' 空闲等待

PROCESS 8:

----------------------------------------

SO: 0x9fab23e8, type: 2, owner: (nil), flag: INIT/-/-/0x00

(process) Oracle pid=8, calls cur/top: 0x9d2c41d0/0x9d2c41d0, flag: (16) SYSTEM

int error: 0, call error: 0, sess error: 0, txn error 0

(post info) last post received: 0 0 121

last post received-location: kcbzww

last process to post me: 9fae39cc 196 0

last post sent: 0 0 24

last post sent-location: ksasnd

last process posted by me: 9fab1860 1 6

(latch info) wait_event=0 bits=0

Process Group: DEFAULT, pseudo proc: 0x9fc2287c

O/S info: user: oracle, term: UNKNOWN, ospid: 6098

OSD pid info: Unix process pid: 6098, image: oracle@game (SMON)

Short stack dump:

ksdxfstk()+19

mmon()+536

SO: 0x9d3a96f4, type: 5, owner: 0x9d26be50, flag: INIT/-/-/0x00

(enqueue) TS-00000003-00000001    DID: 0001-0008-00000002

lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  res_flag: 0x2

mode: SX, lock_flag: 0x0, lock: 0x9d3a9708, res: 0x9d513e74

own: 0x9d26be50, sess: 0x9d26be50, proc: 0x9fab23e8, prv: 0x9d513e7c

SO: 0x9d26be50, type: 4, owner: 0x9fab23e8, flag: INIT/-/-/0x00

(session) sid: 1125 trans: (nil), creator: 0x9fab23e8, flag: (100051) USR/- BSY/-/-/-/-/-

DID: 0001-0008-00000002, short-term DID: 0000-0000-00000000

txn branch: (nil)

oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS

service name: SYS$BACKGROUND

waiting for 'smon timer' wait_time=0, seconds since wait started=126

sleep time=12c, failed=0, =0

blocking sess=0x(nil) seq=1829

Dumping Session Wait History

for 'smon timer' count=1 wait_time=2 min 2 sec

sleep time=12c, failed=0, =0

for 'db file sequential read' count=1 wait_time=0.000147 sec

file#=1, block#=11d8, blocks=1

for 'db file sequential read' count=1 wait_time=0.000254 sec

file#=1, block#=11df, blocks=1

for 'db file sequential read' count=1 wait_time=0.000201 sec

file#=1, block#=f017, blocks=1

for 'db file sequential read' count=1 wait_time=0.000252 sec

=====================================>

SMON hold TS-00000003-00000001  in SX mode , and wait for 'smon timer'

SO: 0x9d3a7f64, type: 5, owner: 0x94586f90, flag: INIT/-/-/0x00

(enqueue) TS-00000003-00000001    DID: 0001-0065-002008D5

lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  res_flag: 0x2

req: X, lock_flag: 0x0, lock: 0x9d3a7f78, res: 0x9d513e74

own: 0x9d17ae90, sess: 0x9d17ae90, proc: 0x9fad3c1c, prv: 0x9d513e84

SO: 0x9d17ae90, type: 4, owner: 0x9fad3c1c, flag: INIT/-/-/0x00

(session) sid: 931 trans: 0x9cd39300, creator: 0x9fad3c1c, flag: (100041) USR/- BSY/-/-/-/-/-

DID: 0001-0065-002008D5, short-term DID: 0000-0000-00000000

txn branch: (nil)

oct: 41, prv: 0, sql: 0xb72dfc04, psql: 0x91dc06d8, user: 253/DBA_LIUJINLIN

service name: WENDING_TAF.LK

O/S info: user: Liujinlin, term: LIUJINLIN, ospid: 4960:6756, machine: WORKGROUP\LIUJINLIN

program: plsqldev.exe

application name: PL/SQL Developer, hash value=1190136663

action name: SQL ′°?ú - grant select on ECHAT, hash value=1064613069

waiting for 'enq: TS - contention' wait_time=0, seconds since wait started=34

name|mode=54530006, tablespace ID=3, dba=1

blocking sess=0x0x9d26be50 seq=211

Dumping Session Wait History

for 'enq: TS - contention' count=1 wait_time=1.207939 sec

name|mode=54530006, tablespace ID=3, dba=1

for 'enq: TS - contention' count=1 wait_time=2.930486 sec

name|mode=54530006, tablespace ID=3, dba=1

for 'enq: TS - contention' count=1 wait_time=2.931502 sec

name|mode=54530006, tablespace ID=3, dba=1

for 'enq: TS - contention' count=1 wait_time=2.931485 sec

name|mode=54530006, tablespace ID=3, dba=1

for 'enq: TS - contention' count=1 wait_time=2.930535 sec

name|mode=54530006, tablespace ID=3, dba=1

==============================>

sid: 931 wait for   'enq: TS - contention',  request to hold   TS-00000003-00000001  X mode ,  SID 931 被阻塞