New Features and Enhancements in SQL Server 2022 SQL Server 2022 introduces a variety of innovative features and performance enhancements. Below is a detailed overview of these advancements: Azure…
Read MoreTimescaleDB introduces Hypertables, a feature that automatically partitions data based on time. While Hypertables behave like regular Postgres tables, they offer specialized functionality tailored for storing and managing time-series data.…
Read MoreTimescaleDB, is a revolutionary open-source database engineered specifically for time-series data. Built on the robust foundation of PostgreSQL, TimescaleDB combines the reliability and versatility of traditional relational databases with the…
Read MoreIn the realm of data management and analysis, the spotlight often shines on a variety of databases designed to handle specific types of data and workloads. Among these, timeseries databases…
Read MorePlease use the below query. set lines 132 col waitevent head EVENT format a5 trunc col username format a10 col osuser format a10 trunc col p1 format 9999 col…
Read MorePlease follow the below steps to delete all the latest inactive patches using the following command. One inactive patch remains, to allow the current patch to be rolled back. cd $ORACLE_HOME/OPatch . /opatch util deleteinactivepatches…
Read MoreSteps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp p33355570_135000_Generic.zip /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 unzip…
Read MoreStep:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database Step:-2 execute the below packages and triggers ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;…
Read MorePatch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015 Step: -1 Environment Details export ORACLE_HOME=/u01/app/19c/grid export PATH=/u01/app/19c/grid/bin: $PATH [oracle@rac1 ~]$ srvctl config database -verbose oradb /u01/app/oracle/product/19c/dbhome_1 19.0.0.0.0…
Read More