ITPub博客

首页 > Linux操作系统 > Linux操作系统 > share cursor

share cursor

原创 Linux操作系统 作者:nolpwd 时间:2011-06-08 04:32:35 0 删除 编辑
http://www.eggheadcafe.com/microsoft/Oracle-Server/35953256/expdp-is-painfully-
slow.aspx
http://www.oracledatabase12g.com/archives/checklist-for-slow-performance-of-export-
data-pump-expdp-and-import-datapump-impdp.html
http://infodba.wordpress.com/2010/08/11/checklist-for-slow-performance-of-export-data-
pump-expdp-and-import-datapump-impdp-id-453895-1/
very slow if CURSOR_SHARING is not EXACT
 ALTER SESSION SET cursor_sharing='EXACT'
alter system flush shared_pool;

http://space.itpub.net/35489/viewspace-666209
http://www.dbtan.com/2010/04/db-file-sequential-read.html
SQL> oradebug setorapid 13
Unix process pid: 19751,
image: oracle@dbserver.acme.com (TNS
V1-V3)
SQL> oradebug session_event –
>    10046 trace name context forever, level 8

Statement processed.
SQL>
http://www.moon-soft.com/doc/51571.htm
http://space.itpub.net/19423/viewspace-676331
http://blog.chinaitlab.com/html/99/1720699-153892.html
!!http://space.itpub.net/35489/viewspace-683646

7515779 Direct path load operations incur waits for "control file sequential read"
event
7243560 High "db file sequential read" IO times when using ASM
http://www.myoraclesupports.com/content/10205-patch-set-list-bug-fixes-problem-type

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25243263/viewspace-697343/,如需转载,请注明出处,否则将追究法律责任。

上一篇: expdp version
下一篇: shrink
请登录后发表评论 登录
全部评论

注册时间:2011-05-25

  • 博文量
    44
  • 访问量
    72464