|
||||
|
Oracle 23ai is made generally available and it has got 300+ new features including AI related. Here is the list of new features from Oracle Blog (Dominic Giles) and I will write detailed posts on some of these features which may useful to DBAs and Developers. AI Vector Search Oracle Announces General Availability […] From various blogs and posts, here is the summary of New features in upcoming release of Oracle database 23c. OLTP and Core DB: Accelerate SecureFiles LOB Write PerformanceAutomatic SecureFiles ShrinkAutomatic Transaction AbortEscrow Column Concurrency ControlFast Ingest (Memoptimize for Write) EnhancementsIncreased Column Limit to 4kManaging Flashback Database Logs Outside the Fast Recovery AreaRemove One-Touch […] Here is the script and snippet of Average Active Sessions plotted by Hour in Oracle database. This is similar to Oracle Log switch history. This helps DBA to understand the hourly metric of AAS and determine any spikes of the active sessions for the problematic period or gather some particular trend of AAS. […] Looks like some more exciting features / enhancements is going to appear in Oracle 23c as per DAOUG presentations. Hope lot more will be announced in OCW22. From Productivity Stand point view 4K ColumnsSQL DomainsJSON SchemaDeveloper RoleSchema-Level PrivilegesJS Stored ProceduresSingle Server rolling maintenanceNative property graphs From Simplicity stand Rest API’s for auto upgradeOracle […] Hello All, This post is intended to give you an understanding of upcoming series of Timeseries analysis and how it can be useful to predict issues that may arise in future or predict growth etc. Think of this, Many of the SRE’s or admins work today mostly by doing reactive fixes (some may not) […] Learn how to use Machine Learning with in Oracle Database using OML4PY. 20c Preview edition and its features porting to 21c and here is the update from AIOUG Sangam 2020 and a pictorial representation of upcoming release model. Thanks to Jenny Tsai Smith and Rich Niemiec for sharing this. Source : AIOUG Sangam20, Twitter, Oracle […] Database landscape become vast and we have seen unprecedented growth and usage of many database technologies in the organizations and no one size fit for all tool is available in the market to monitor all of those databases. I have started the journey with Prometheus monitoring couple of years back and found its […] 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 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!