Blog for Database and System Administrators

This blog is a collection of articles on analyzing and troubleshooting for all system and database administrators. These guides come from my experience, I hope they can help everyone.

MENU
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Skip to content
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Oracle Database 20c

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 »

Oracle    exadata, oracle, oracle 12c, Oracle Database 12c Release 2, Oracle Exadata
Oracle Database 20c

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 »

Oracle    audit, AUDIT_TRAIL_UNIFIED, oracle 12c, Oracle 18c, Oracle 19c
Oracle VM logo

How to install Oracle VM 3.4

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 VM    hypervisor, Oracle Linux, Oracle VM, Virtualizzation, VM
Oracle Database 20c

How to Find Oracle Hidden Parameters

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 »

Oracle    hidden, oracle, oracle10g, oracle11g, oracle12c, parameters
oracel 20c

Script to find the worst waits events in Oracle database 19c

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 »

Oracle    oracle, oracle12c, performance, script
oracel 20c

Script to disable all jobs in Oracle Database (all editions)

Script to disable all jobs in Oracle

Oracle    dbms, dbms_job, oracle, oracle_sch, oracle_scheduler, oracle12c, scheduler
Oracle Database 20c

Oracle DBMS_SCHEDULER vs DBMS_JOB

DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for… Read more »

Oracle    dbms_job, oracle, oracle_scheduler, oracle10g, oracle11g, oracle12c
Oracle Database 20c

How to view if there are jobs in running on oracle databases?

you want to know if there are jobs in state running? don’t worry enough to read this article!

Oracle    dbms_job, job, oracle, oracle_scheduler

Posts pagination

« Previous 1 … 8 9 10

Recent Posts

  • Flatpak Search not working on Oracle Linux/Red Hat 9.4 June 3, 2024
  • Configuring and Using Oracle Global Data Services: Optimizing Distributed Workloads October 3, 2023
  • OCFS2 File system and Snapshot with REFLINK February 25, 2023
  • Oracle UEK7 Oracleasm kernel module has been removed May 30, 2022
  • How do fsck at corrupted vm guest in Oracle OVM or Xen Server from vm images. May 2, 2022
  • Oracle Dataguard queries check April 12, 2022
  • Unable to open ‘/boot/vmlinuz-*-dpkg-new’: Operation not permitted March 10, 2022
  • Pre-built Oracle Database 12.2/19c/21c Virtualbox Image January 23, 2022
  • Upgrading Oracle Linux 7 to 8 using Leapp January 21, 2022
  • Oracle Database tracing LDAP from CMU to AD November 15, 2021
Copyright 2020
dbsysupgrade.com
Ribosome by GalussoThemes.com
Powered by WordPress
Social Media Auto Publish Powered By : XYZScripts.com