|
||||
|
Oracle 19c and 20c (preview) now contains Machine Learning algorithms directly can called from database itself. And as I am not at all expert in this and I was looking for right examples and came across this superb video on how to use them from none other than oracle analytics expert “Brendan Tierney” Oracle […] Starting 20c, one do not need to bother about index rebuilding, shrinking, managing them. We can automate this using feature Automatic Data Optimization option + marking the indexing to certain tier/policies. The optimization process includes actions such as compressing, shrinking, or rebuilding the indexes: Compress: Compresses portions of the key values […] Starting 20c, the following datapump enhancements are available as per new features guide which are more useful to DBA on day to day. Resume Transportable Tablespace Jobs Oracle Data Pump resumes transportable tablespace export and import jobs that are stopped. Oracle Data Pump has the capacity to resume transportable tablespace export and […] Most of time developers writes multiple procedures or pl/sql code with relevant conditions and blocks to simplify operations , but the complexity grows and number of joins increases the operations of SQL Engine and PLSQL engine has to involved more and do more context switching at the cost of performance. In Oracle Database 20c, […] With Oracle 20c, (as per preview details), introduced a new BASE_LEVEL value for the INMEMORY_FORCE parameter. When this new value is set the INMEMORY_SIZE parameter can be set up to a value of 16GB without having to license the Database In-Memory option. In fact, when the BASE_LEVEL value is set you cannot set the […] 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: […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!