Detecting and resolving performance problems in SQL Server is crucial for database developers and administrators. Utilizing dynamic management views (DMVs) can provide insights into a server instance’s current state and…
Read MoreRunning Oracle Database on Amazon Web Services (AWS) Relational Database Service (RDS) provides a variety of advantages, including scalability, flexibility, and managed services. However, in order to secure your sensitive…
Read MoreOracle Database 23c, Oracle Corporation’s most recent release, includes a slew of new features and changes designed to provide organizations with expanded capabilities and improved performance. Overview: Enhanced machine learning…
Read MoreHow to create a cost estimate with the AWS Pricing Calculator? Concepts: Create a logical pricing group. Create weekly, monthly, and yearly estimates for Amazon EC2 instances. Step 1: …
Read MoreHUGE PAGES What are Huge Pages? Linux Manages memory in pages while loading data from disk to memory or writing back to disk from memory. Huge pages is a…
Read MoreThe most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces. Here below are the steps: Step 1. find tablespace “BMW” whether…
Read MoreThere are 2 ways we can do it as short and detail version . Short startup sequence : 1) OS 2) Cluster 3) ASM 4) INSTANCE 5) Listener 6) Service…
Read MoreOracle Goldengate supports the replication of data for various heterogeneous platforms. It provides support for IBM Informix and extended support for Microsoft SQL Server and MySQL. Oracle GoldenGate is now …
Read MoreFaced a strange issue in oracle 12c. In automated maintenance task, sql tuning advisor was enabled. However, it was still not running. Validated dba_autotask_operation, that “sql tuning advisor” is enabled.…
Read More