Hakan Factor

There’s a question on the MOSC forum (needs an account) at present that started with the performance of the datapump API over a database link but moved on to the topic of how to handle a scenario that I’ve described in the past involving a table where rows are intially short and eventually become much longer and a requirement comes up to rebuild the table. In this case the OP has to use datapump (selecting truncate as the “action...

blog.dbi-services.com blog.dbi-services.com

Warning: ODA HA disk enclosure is not smart!

Introduction Apart from the number of servers (1 vs 2), the main difference between Oracle Database Appliance lite (S/L) and High-Availability (HA) is the data disks location. They are inside the server on lite ODAs, and in a dedicated disk enclosure on HA ODAs. Obviously, this is because when 2 nodes want to use the same disks, these disks have to be shared. And this is why HA needs a SAS disk enclosure. Disk technology on ODA On lite...

blog.dbi-services.com blog.dbi-services.com

Latency test from Client to Oracle DB: Minimum number of rows fetched in sqlplus and sqlcl

Some time ago I wrote a Blog on how to calculate the network latency fetching a row to a Client from an Oracle database. The tool I used was sqlcl, because it just requires Java and hence no Oracle Client needs to be installed. Some people executed the script provided in the blog with sqlplus (also because current versions of sqlcl require Java 11) and saw only 1669 network round trips with 5000 rows and an arraysize of...

blog.dbi-services.com blog.dbi-services.com

ODA X9-2 and CPU speed

Introduction It’s been several months now that Oracle released new Oracle Database Appliance X9-2 series. And my first project with 4 of these servers is coming to an end as moving to production is planned for the next weeks. What is the real speed of the Xeon CPUs inside these new servers? Let’s find out. Intel Xeon and CPU speed I already addressed this topic in a previous blog post, and it’s still relevant...

blog.dbi-services.com blog.dbi-services.com

ODA – HDD manuel firmware patching

I recently patched ODAs X7-2-HA and X8-2-HA from version 19.8 to version 19.12 and then 19.16 at one of our customer environment. I faced some HDD firmware that was not patched during storage patching, and I had to manually patched them. Through this blog I wanted to share how I performed this, hoping that it might help you. All the HDD firmware disks were in A3Y1 version and the last available one was A680. There was no new version...