How to test securefile vs basicfile lob performance

Hi

Oracle 12.1.0.2.0 RAC, ASM, standby present, so force logging on primary.

Oracle Enterprise Linux 7.6

I have done some tests in my sandbox environment.

Taken some table, where there are many basicfile lob columns (21 million rows). At first I created new table base_table (CTAS, basicfile lobs), with ID column and 2 LOB columns (created new table, so the data will be more organized and to eliminate row chaining and migration).

Then did this:

alter system flush shared_pool;alter system flush buffer_cache;set timing on;

And then, using previously created base_table, I created new table (CTAS, basicfile lobs, everything else default). And saved the time it took to create this table.