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 ..read more

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 ..read more

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 ..read more

Learn how to use Machine Learning with in Oracle Database using OML4PY ..read more

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 ..read more

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 ..read more

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 ..read more

When flashback or point-in-time recovery is performed on the primary database, a standby that is in mounted mode can automatically follow the same recovery procedure performed on the primary When flashback or point-in-time recovery is performed either on a primary database or a PDB in the primary database, the primary ..read more

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 ..read more

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 ..read more