Kill The Inactive Session After 12 Hours
Hi all, If you can not set up an ad hoc profile to automatically end all sessions in idle state, perhaps this script could help you. Oracle Single Instance: select… Read more »
Tag: oracle 12c
ROWNUM vs ROW_NUMBER() and Oracle 12c fetch first
Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required… Read more »
Purging Unified Audit Trail in Oracle 12c R1
The Unified Audit Trail has become too big, you cannot directly delete or truncate the table. You must call the dbms_audit_mgmt.clean_audit_trail. But then you want to know if it will… Read more »
Kill, cancel and resume or restart datapump expdp and impdp jobs
The expdp and impdp utilities are command-line driven, but when starting them from the OS-prompt, one does not notice it. When you want to kill, cancel, start or resume a… Read more »
How To Configure OCR Backups
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 »
Exadata Storage list of commands
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 »
Oracle Database 12.2 for Exadata available
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 »
How to enable Unified Auditing in Oracle 12c
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 »