Database Solutions

  Oracle Database Statistics: Understanding HyperLogLog from a DBA’s Lens After years of working with Oracle databases, one of the constant challenges has been balancing accuracy and performance—especially when dealing with large-scale data. Cardinality estimation plays a critical role in query optimization, and traditional approaches often required heavy scans or large memory usage to compute distinct values. This is where HyperLogLog (HLL) becomes extremely relevant in modern Oracle environments. HyperLogLog is a probabilistic algorithm used to estimate the number of distinct values (NDV) efficiently. Instead of computing exact counts, it uses hashing and compact data structures to provide highly accurate approximations with minimal overhead. From a DBA perspective, this is a major step forward in managing large datasets and improving optimizer efficiency. Below are key aspects along with practical commands to understand and use this feature effectively: ⸻ • Effic...

  Oracle Database 26ai: New features  Below are the new features in oracle Database 26ai. AI Vector Search Built into the Core Engine One of the most transformative features is the native support for vector data. Previously, if a business wanted to implement semantic search or AI-driven recommendations, we had to integrate external vector databases. Now, Oracle allows storing and querying embeddings directly within the database. From a DBA standpoint, this simplifies architecture, reduces data movement, and improves performance consistency. It also means we need to start understanding AI workloads as part of our core responsibilities. True AI-Native Database Capabilities Oracle 26ai is designed with AI embedded into its foundation rather than added as an afterthought. This shows up in areas like query optimization, workload prediction, and anomaly detection. The database learns from usage patterns and adapts automatically. For someone who has spent years analyzing AWR ...

 In this blog, we will list down the steps to uninstall oracle database binary.  Step 1) Login as Oracle binary owner. <Oracle home>/oui/bin/runInstaller -detachHome -local ORACLE_HOME=<Oracle home> Step 2) Make sure Home get deleted from Inventory. <Oracle Home>/OPatch/optach lsinv |grep -i <Oracle Home> Step 3) Remove Binaries  cd <Base directory for Oracle Home> ls -lrt <version> rm -rf <version> ls -lrt <version> You can learn more about oracle RAC using below books: Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting Expert Oracle RAC 12c  ==========================================================      Please check our other blogs for Oracle                        

 In this blog , We will list down the steps to clone a OEM agent from an existing host.  Step 1) Create agent Base directory and provide required permission. mkdir -k /u01/app/oracle/agent_base_13 Step 2) On OEM Console, navigate to the "Add targets Manually."  screen. Setup->Add target->Add Targets Manually  Step 2) On next screen click Ïnstall Agent on Host" Step 3) On Host and platform page. Give unique session and click +Add button and enter fully qualified name and select the platform for the host. Step 4)    On the Installation Details page, In the Deployment Type section, select Clone Existing Agent. Then, for Select Target, click the torch icon and select the Management Agent you want to clone From the table, select the first row that indicates the hosts grouped by their common platform name Enter the installation details and click the "Next" button Installation Base Directory : /u01/app/oracle/agent_base_13 Instance Directory Named Credenti...

In this blog , we will list down all the steps to install or push the OEM agent to target host. Step 1) Create agent Base directory and provide required permission. mkdir -k /u01/app/oracle/agent_base_13 Step 2) On OEM Console, navigate to the "Add targets Manually."  screen. Setup->Add target->Add Targets Manually  Step 2) On next screen click Ïnstall Agent on Host" Step 3) On Host and platform page. Give unique session and click +Add button and enter fully qualified name and select the platform for the host. Step4) Enter Installation details and click "Next"button Installation Base Directory : /u01/app/oracle/agent_base_13 Instance Directory Named Credential : /u01/app/oracle/agent_base_13/agent_inst (default) : (click the "+" button and add the credentials of the "oracle" user) Privileged Delegation Setting: (leave blank) Port : 3872 Step 6) Check information on the review screen and click "Deploy Agent"Button. Step 7) Re...