Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/slow expdp impdp.md

Last active September 23, 2022 16:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/b245722f22ceabb8e25e98e7c49a3ca0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/b245722f22ceabb8e25e98e7c49a3ca0 to your computer and use it in GitHub Desktop.
Download ZIP
Slow expdp/impdp #oracle
Raw
slow expdp impdp.md 
SQL> show parameter stream

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_disable_streams_pool_auto_tuning    boolean     TRUE
streams_pool_size                    big integer 256M

select shrink_phase_knlasg from x$knlasg;
-- if
--    shrink_phase_knlasg = 1
-- then
    alter system set events 'immediate trace name mman_create_def_request level 6';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment