You are on an 11g/12c Oracle Database and wish to reduce the usage of space in the SYSAUX tablespace dedicated to the SQL Management Base (SMB), which is where SQL… Read more »
BACKGROUND The Oracle Cluster Registry (OCR) contains important cluster and database configuration information for RAC and Oracle Clusterware. One of the Oracle Clusterware instances in the cluster, the CRSD master,… Read more »
It is not an easy to remember the commands since most of the UNIX administrators are working on multiple Operating systems and different OS flavors. Exadata adding additional responsibility to… Read more »
Overview Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at which point… Read more »
Oracle Database 12.2.0.1 on-premises for Exadata is now available for download from Oracle eDelivery/SoftwareCloud!! Connect to eDelivery and login: Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …”… Read more »
Actually one of our slides gives a parameter recommendation to set AUDIT_TRAIL since Oracle 11g explicitly to the value you want as otherwise it may switch to “DB” and you… Read more »
Oracle VM for X86 is a native hypervisor which is directly runs on the host’s hardware.This hypervisor is based on xen technology and it requires very small footprint on the… Read more »
Oracle has many of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems…. Read more »
This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical i/o, logical i/o, memory and CPU processes),Top CPU usage by… Read more »