data-pump-expdp-and-import-datapump-impdp.html
http://infodba.wordpress.com/2010/08/11/checklist-for-slow-performance-of-export-data-
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
very slow if CURSOR_SHARING is not EXACT
ALTER SESSION SET cursor_sharing='EXACT'
alter system flush shared_pool;
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
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
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
7243560 High "db file sequential read" IO times when using ASM
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25243263/viewspace-697343/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
expdp version
下一篇：
shrink
请登录后发表评论
登录
全部评论
