OS: IBM AIX Version 5.3
DB:
SQL> select* from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Productio
NLSRTL Version 10.2.0.1.0 - Production
进行exp 的时候出现等待,exp无法进行
-bash-3.00$ exp userid=scott/tiger file=scott.dmp
Export: Release 10.2.0.1.0 - Production on Fri Apr 6 09:35:21 2007
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
在这个地方exp就不动了,出现等待
查询v$session中的wait event
SQL> column EVENT formata30;
SQL> column wait_class format a30;
SQL> select sid,event,wait_class from v$session where program like '%exp%';
SID EVENT
WAIT_CLASS
---------- ------------------------------ ------------------------------
159 library cache pin
Concurrency
在v$session中 的 等待事件中发现 library cache pin 等待类型为
Concurrency,library cache pin 应该为shared pool 中library等待
exp 为什么会出现这个等待呢 ?
是什么原因导致这个等待事件的 发生呢 ?
|