Re: Oracle Myths

On Monday, February 9, 2015 at 11:59:17 PM UTC+11, are..._at_gmail.com wrote:

> When I was DBA on Oracle 7.3.4 I always set pctincrease on tables (not tablespaces) to 1% to trigger autocoalesce on extents. Perhaps this was a myth too? I can't check anymore, our 7.3.4 database was shut down late 2011.

Does anyone still use any rel7 dbs? Amazing! I've been on LMT uniform tablespaces with a suitable size since rel8.1 and haven't looked back since. Have yet to do a complete db re-org since upgrading all to 10g. Now on 11gr2 and looking at 12 next year. And all bigfiles, too: fed-up with heaps of file units open in *n*x. Received on Tue Feb 10 2015 - 01:22:38 CET