Hello Michael,
Stefan, the inserts are not parallel. They come from different sessions, one
at a time.
Michael Cunningham <napacunningham@xxxxxxxxx> hat am 4. Mai 2016 um 16:59--
geschrieben:
These answers are incredible. I learned a lot and got some great ideas.
Stefan, the inserts are not parallel. They come from different sessions, one
at a time.
Jonathan, the primary key is fom a sequence and, to date, I have not
witnessed any problems with waits. However, if you have something in
particular I should be cautious of please let me know and I'll look into it.
I'll move the partitions with pctfree 0 initrans 2, and look into using
basic compression, but I'll leave the last partition at pctfree 10. I'll
also look at sorting the data in each partition. In fact, I'll use Stefan's
idea of dumping some of the latest blocks to see the ITL list count. It
seems that pctfree 10 leaves room for 34 ITL's (24 bytes each). The inserts
are not parallel so I'll assume they stay at 24 bytes. I have a couple
days before all the partitions are moved until I get to the latest partition
where I'll be using dbms_redefinition.
Thanks for all the info, if there is any more, I'll take it.
Michael