Thanks for the question, Ramki.
Asked: July 18, 2023 - 2:13 pm UTC
Last updated: July 19, 2023 - 4:55 am UTC
Version: Multiple
Viewed 1000+ times
You Asked
We are moving lob objects from one table space to another.
We are currently in oracle 19c.
When the table was first created it was in 11g, then we migrated to 12c.
We had around 14k lob objects.
When we move from one tablespace to another 10k moved faster but remaining 4k is slower.
The lob object type is basic (not secure)
Is there any difference the lob gets created in 11g,12c
and Connor said...
Maybe check 'db_securefile' to ensure that you are not migrating to securefile inadvertently (although that would probably be a good thing).
Also, a database trace
exec dbms_monitor.session_trace_enable(waits=>true)
or a look at v$active_session_history
will give you some details as to the "why" the slowdown is occurring.
If downtime is an issue, you could always explore dbms_redefinition, or "alter table move online" depending on your version
Is this answer out of date? If it is, please let us know via a Comment