Month: December 2024
-
Table Statistics vs. SELECT COUNT: What to Choose?
Counting rows in database tables is a common concern for DBAs, as it’s highly discussed in forums like ASKTOM and Stack Overflow. Despite its performance drawbacks, developers/dbas often use row counts for data validation during migrations, capacity planning, anomaly detection, and performance tuning. The use of table statistics and computing the exact row count with ‘SELECT COUNT(*) FROM’ is debated. The article emphasizes the need to question the necessity of exact row counts in business requirements perspective.
-
Installing Oracle Database 23ai on ARM Macs with Sample Schemas
Released on 12th November 2024, Oracle Database 23ai now offers free container images optimized for ARM-based Apple MacBook computers with M-series chips, enhancing development efficiency. Two image options, Full and Lite, are designed to meet diverse requirements. This post details the process for setting up the Oracle Database using Docker, checking logs, connecting with SQLcl, and importing sample schemas(HR,SH and CO), providing Mac developers with an efficient way to create test environments.
-
File System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7
A file system corruption issue was detected on the root partition of an Exadata storage server running Oracle Linux 7.9. This was identified by AIDE due to changes in file attributes. Investigations revealed errors in the logs pointing to inode inconsistencies. Attempts to resolve the corruption faced obstacles due to the unavailability of diagnostic ISO images. Ultimately, the file system corruption was fixed by using an Oracle Linux 7.9 installation ISO and running fsck manually.
Osman’s DBlog 