share cursor

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25243263/viewspace-697343/