What is Log shipping? SQL Server Log shipping is an automatic process that sends transaction log backups from a primary database server instance to secondary databases server on secondary server instances.…
Read MoreINTRODUCTION: In today’s world, businesses create and uses a huge amount of data, so they need storage solutions that are both efficient and able to grow as needed. Oracle Cloud…
Read MoreIntroduction: In cloud computing, choosing the right storage solution is important to ensure good performance, manage costs, and handle data efficiently. Oracle Cloud Infrastructure (OCI) provides different storage options, including…
Read MoreIntroduction In today’s data-driven world, database performance is crucial for business success. SQL Server 2022 introduces significant advancements, including the Buffer Pool Parallel Scan feature, designed to optimize performance on…
Read MoreThis post talks about the issue you may encounter when applying R12.2.10 RUP patch as part of R12.2.11 Upgrade. ERROR: sqlplus -s APPS/<passwd> @/pvebsuat_pebsuat_cls/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/pvebsuat_nebsuat_cls/apps/fs2/EBSapps/appl/asn/12.0.0/patch/115/sql/asndelff.sql ‘ Connected. PL/SQL procedure…
Read MoreTempDB Files space issue What is the purpose of tempdb in SQL server.? Ans: Tempdb is a temporary database which contains tables data for temporary purpose SQL Server PDW system…
Read MoreNew 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 MoreIntroduction In the demanding environment of database administration, managing multiple tasks efficiently is vital. For Oracle DBAs working on Linux systems, tmux (Terminal Multiplexer) is an essential tool. It enables…
Read MoreIntroduction: When it comes to managing Oracle E-Business Suite (EBS) R12.2, applying patches swiftly to tackle urgent issues is crucial. In the past, DBAs were used to the idea of…
Read MoreIntroduction: ADOP cutover phase has failed in a PRODUCTION system while running a patch cycle. But the roles between Run and Patch file systems have switched, though the adop cutover…
Read More