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 18c: New features are no longer available on premises

Everybody knows:  the licensing of Oracle databases is quite difficult. There are so many things to consider in order to be sure that everything is correct. In the past, it… Read more »

Oracle    Engineered Systems, new features, oracle, Oracle 18c, premises

Oracle Database 18c – Some important changes

I know that Oracle Database 18c is available in the Oracle Cloud and on Exadata engineered systems only right now. But actually I’ve had conversations with some customers who downloaded… Read more »

Uncategorized    Multimedia, oracle, Oracle 18c, Oracle Multimedia, Oracle Streams, RPM, runInstaller, Streams
Oracle Database 20c

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2

Oracle Multimedia (ORDIM) clean up in Oracle Database 11.2-12.2 is not complicated especially as the removal script checks for the usage of the option first. Oracle Multimedia (ORDIM) Clean Up… Read more »

Oracle    11.2.0.4, 12.1.0.2, clean; ORDIM, deprecated, Oracle 11g, oracle 12cR1, oracle 12cR2, Oracle Multimedia
Oracle Database 20c

SQL Plan Management and Auto Capture

SQL Plan Management (SPM) is an Oracle database feature that allows you to establish a set of SQL execution plans that will be used even if the database is subject… Read more »

Oracle    Auto Capture, Oracle 11g, oracle 12c, Self Tuning database, SQL Management Base, SQL PLAN, SQL Plan Management, Tuning
Oracle Database 20c

Why should you use the most recent version of OPatch?

Opatch. A tool nobody really loves but everybody has to use (at least those of you who patch or aren’t in our cloud deployment). Opatch gets distributed via MOS. And… Read more »

Oracle    opatch, oracle 12c, oracle 12R2, Oracle 18c, patching
Oracle Database 20c

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 »

Oracle    kill session, oracle 12c, Oracle Database, script, sessions
MongoDB Logo

Tuning MongoDb for Linux

In this post, we’ll discuss tuning Linux for MongoDB deployments. By far the most common operating system you’ll see MongoDB running on is Linux 2.6,3.x. and 4.x (only Oracle Linux… Read more »

MongoDB    Centos, Debian, Kernel, mongodb, mongodb 3.6, Oracle Linux, Redhat, Tuning, Ubuntu
Oracle Database 20c

Hybrid Columnar Compression Common Questions

In this blog we’re going to discuss some of the most common, user asked, questions related to Hybrid Columnar Compression (HCC), these questions include: How to enable Hybrid Columnar Compression… Read more »

Oracle    exadata, FS Flash Storage System, HCC Compression, Hybrid Columnar Compression, ILM, ODA, Oracle Database, Oracle Database 12c Release 1, Super Cluster, ZFS Storage Appliance
Oracle Database 20c

Oracle 12c : Improve your security with Oracle data redaction

Sensitive data is everywhere in our organization’s systems. Today, organizations are required to protect sensitive data; these requirements come from regulations, laws and the necessity of the organization to protect… Read more »

Oracle    advanced security, Data masking, Database, Dynamic Data Masking, new features, oracle, oracle12c, security

Oracle 18c Features and Advantages

Oracle 18c : We are now using the latest Oracle database which is 11g version of oracle and Oracle 12c version to do the database operations in day to day… Read more »

Oracle    machine learning, Oracle 18c, Self Driving database, Self Tuning database

Posts pagination

« Previous 1 … 5 6 7 8 9 10 Next »

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