Hi, I have a problem: when Oracle increase the extent automatically it take more than 20 min. How can we optimize the extent increase without percentage option or non manually? Thanks
Are you using locally managed tablespaces?
is creating the extent causing the datafile to extend automatically? If it is increase the datafile by a large chunk manually and always ensure there's 20% space free say, so the extent does not need to ask the O/S for more filespace.