>> Did Oracle change this? Last time I looked, I don't think Oracle supported local redo in their multitenant architecture either.
Hi Jeremy, they are moving in this direction (project seems to be called DGPDB internally). And what is interesting for this discussion is that they initially had redo (and even undo) at instance level, but moved this to PDB following what users were asking for: pdb level flashback, pitr, switchover,...But it is hard to compare those needs with PostgreSQL. Multiple db clusters in PG is lightweight and is the right place to isolate (users, cgroups,...). Oracle CDB is too heavy to have multiple on one host. And many isolation features is made at PDB level (lockdown profiles, resource manager)