As always, there has to be someone pointing out the issue or solution. In this case it was Mike Dietrich (Mr. Upgrade). In the Oracle Upgrade Guide for 12c it is in black and white: Cite: “The non-CDB architecture is deprecated in Oracle Database 12c, and may be desupported and unavailable in a later Oracle Database release. Oracle recommends use of the CDB architecture.” (Oracle 12c Database Upgrade Guide, chapter 8.1.1).
Non-CDB Deprecated Blogbeitrag lesen »
Automatic Segment Space Management (ASSM) helps to distribute your data across the data blocks. It’s no longer necessary to take care about the parameter PCTUSED, which was in former years responsible for the space within one Oracle block. Those days a block was filled until it reaches the high water mark PCTFREE (default 10%). At that point the block was released from the list of free blocks and as long as the low water mark PCTUSED (default 40%) hasn’t been reached again no data will be stored in that block. So only if a massive amount of data will be
Automatic Segment Space Management Blogbeitrag lesen »
Over the last couple of years I was asked repeatedly because the SYSTEM Tablespace is constantly growing. The reason is pretty simple: Since Oracle 11.2 DDL commands not executed with SYSDBA privilege and all logins (failed or successful) are logged in the AUD$ table. And against some documentation this table is located in the SYSTEM tablespace and not in SYSAUX.
Manage Audit Data Blogbeitrag lesen »
