Oracle 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 MoreWe were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…
Read MoreAfter upgrading database from oracle 11g to 12c in Oracle Apps R12.1.3, got a strange issue where SOA webservices- SOAP, REST stopped. The following url showed 404 http://host.domain:8000/webservices/SOAProvider/?testquery The issue…
Read More