This blog is a collection of articles on analyzing and troubleshooting for all system and database administrators. These guides come from my experience, I hope they can help everyone.
SYMPTOMS The alert message looks like EM Event: Warning:TEST_PDB1 – Total global cache block lost is 15. Host=db-test01.local Target type=Database Instance Target name=TEST_PDB1 Categories=Error Message=Total global cache block lost is… Read more »
This post describes the 5 main differences between ATP-D & ATP-S and the 5 main ATP-D physical characteristics and constraints. Autonomous Transaction Processing Dedicated (ATP-D) is a deployment choice that… Read more »
To give customers more flexibility and time to take advantage of the latest features offered with Oracle VM 3.4, Oracle has extended the Premier Support end date for Oracle VM… Read more »
Oracle has finally certified Oracle Database solutions for KVM products.To have less problems with the Oracle auditor it is advisable to use their (free) solution called Oracle Linux Virtualization. Oracle Linux… Read more »
Do you want update all sequences? make it simple! If you ever do data refreshes from production to development or test environments you may run into an issue where your… Read more »
Oracle RAC? Oracle Real Application Clusters (Oracle RAC) is the only solution to build an active – active cluster using shared storage for your Oracle database. Up to Oracle 18c… Read more »
In this article we are going to see use of Oracle Block Change Tracking concept in 19c database. 19c-Block Change Tracking(BCT) Oracle 10g introduced the Block change tracking (BCT) feature… Read more »
History Since December 2015, Oracle released Oracle Standard Edition 2 (SE2), replacing the previous Standard Edition (SE) and Standard Edition One (SE1) releases. Customers on versions before 12.1.0.2 (running Standard… Read more »
Since the release of Oracle 12c it is now easier to move columns logically. Oracle 12c added support for making columns invisible and that feature can be used to rearrange… Read more »
Hi guys! Have you ever encountered this error ORA-06512: at “SYS.OWA_UTIL” during a package compilation using for example the Oracle sql developer software? Problem: line 1: ORA-06502: PL/SQL: numeric or… Read more »