Anas Darkal

-->

Latest Posts

Oracle 23ai: Bigfile Tablespace Shrink

Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond requested RESIZE value” because there are..

Read More

Oracle 23ai: Managing Flashback Database Logs Outside the Fast Recovery Area

Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23ai Database introduces the option to store flashback..

Read More

Oracle 23ai: Read-Only Users and Sessions

Overview: Oracle 23ai Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the privileges of the user that..

Read More

Oracle 23ai: Hybrid Read-Only Mode for Pluggable Databases

Overview: Oracle 23ai database introduces a new feature to open Pluggable database in a new mode called hybrid read-only Hybrid read-only mode enables a PDB to operate as either..

Read More

MySQL: Updating the Configuration of a MySQL DB System on OCI

Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to the my.ini or my.cnf files that you use in..

Read More

MySQL: Creating a MySQL Configuration on OCI

Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to the my.ini or my.cnf files that you use in..

Read More

Oracle 23ai: INTERVAL Data Type Aggregations

Overview: Oracle 23ai introduces the use of SUM and AVG functions with INTERVAL datatype This enhancement makes it easier to calculate totals and averages over INTERVAL values In..

Read More

ExaCC: Scale VM Cluster Exadata Usable Storage

Overview: With multiple VMs per Exadata Infrastructure feature release, you can scale up or down the following resources on the VM cluster: Local storage /u02. Scaling memory..

Read More

ExaCC: Scale VM Cluster Local Storage Size

Overview: With multiple VMs per Exadata Infrastructure feature release, you can scale up or down the following resources on the VM cluster: Local storage /u02. Scaling memory..

Read More

ExaCC: Create a Custom Database Software Image

Overview: ExaCC users patch and provision their Oracle Database Homes using standard Oracle-published images Oracle makes the major Oracle database versions with the last 4..

Read More