|
||||
|
SecureFiles Defragmentation SecureFiles defragmentation provides online defragmentation of allocated and freed space in SecureFiles segments, for all types of SecureFiles LOBs - compressed, deduplicated, encrypted. Defragmentation can be done automatically by a background process, and the segment advisor can estimate the fragmentation levels and how much space can be saved. Defragmentation can […] Starting 20c, One can keep expression in Initialization Parameters. some examples from documentation as below Initialization parameter expressions can contain the following constructs:Integer values OLAP_PAGE_POOL_SIZE = 1073741824 Decimal values, only when they are part of a numeric operation CPU_COUNT = 8 * 0.6 If the operation resolves to a decimal value, then the result […] In oracle 20c, JSON is a new SQL and PL/SQL data type for JSON data. The data is stored in the database in a binary form for faster access to nested JSON values. You can use JSON data type and its instances in most places where a SQL data type is allowed, including: […] As per recent update in blogs.oracle.com, Oracle is planning to include a Standard Edition High Availability solution with Oracle Grid Infrastructure that provides cluster-based failover for Standard Edition Oracle Databases using Oracle Clusterware. Image Source: Blogs.oracle.com This will help customers who are on standard edition license to level high availability features that are […] Oracle Open world 2019 - Interesting updates so far. Oracle Cloud - Free Tier - Always Free Services- 1 ADW, 1 ATP , 2 Compute services always free Oracle Database 20c BlockChain table type Desupport of non-cdb architecture, facilitating 3 PDB’s with no cost Native Persistent Database Memory (PMEM) - Automated Machine Learning Binary Json […] |
||||
Follow Me!!!