Ardent Performance Computing
Technical
Understanding CPU on AIX Power SMT Systems
This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. I’ve worked with databases running on AIX a number of times over the years now. Nevertheless, I got thrown for a loop this week. TLDR: In the end, it came down to a fundamental change in resource accounting that … Continue reading
Patching Time
Just a quick note to point out that the October PSU was just released. The database has a few more vulnerabilities than usual (31), but they are mostly related to Java and the high CVSS score of 9 only applies to people running Oracle on windows. (On other operating systems, the highest score is 6.5.) … Continue reading
Grid/CRS AddNode or runInstaller fails with NullPointerException
Posting this here mostly to archive it, so I can find it later if I ever see this problem again. Today I was repeatedly getting this error while trying to add a node to a cluster: There were two notes on MOS related to NullPointerExceptions from runInstaller (which is used behind the scenes for addNode … Continue reading
OSP #3a: Build a Standard Cluster Platform
This is the fifth article in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth. We’ve looked in some depth at the process of defining a … Continue reading
Chicago Oracle User Community Restart
Chicago is the third largest city in the United States. There are probably more professional Oracle users here than most other areas in the country – and yet for many years now there hasn’t been a cohesive user group. But right now there’s an opportunity for change. If the professional community of Chicago Oracle users … Continue reading
Command Line Attachment to Oracle Support Service Request
For those who haven’t looked at this in awhile: these days, it’s dirt simple to attach a file to your SR directly from the server command line. Or to use a proxy server, There is lots of info on MOS (really old people call it metalink); doc 1547088.2 is a good place to start. There … Continue reading
OEM CLI Commands for Bulk Property Changes
This will be a brief post, mostly so I can save this command somewhere besides the bash_history file on my OEM server. It may prove useful to a few others too… it has been absolutely essential for me on several occasions! (I was just using it again recently which reminded me to stick it in … Continue reading
November/December Highlights
In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and … Continue reading
Readable Code for Modify_Snapshot_Settings
It annoyed me slightly that when I googled modify_snapshot_settings just now and all of the examples used huge numbers for the retention with (at best) a brief comment saying what the number meant. Here is a better example with slightly more readable code. Hope a few people down the road cut-and-paste from this article instead … Continue reading
Largest Tables Including Indexes and LOBs
Just a quick code snippit. I do a lot of data pumps to move schemas between different databases; for example taking a copy of a schema to an internal database to try to reproduce a problem. Some of these schemas have some very large tables. The large tables aren’t always needed to research a particular … Continue reading
Disclaimer
The views expressed here are mine alone and may not reflect the views of my employer.
Recent Comments