I loved this one … yes my code is wordy, it prints a lot of helpful text, and it has a lot of comments. Funny how anyone can open up my scripts and edit them without any other documentation or discussion. To be fair, I don’t know if his prices came from server-class hardware, but [...]
Archive for October, 2010
variable/column names and making code tiny
Posted in Code on October 22, 2010 | Leave a Comment »
Upgrading small databases on big servers (ORA-04031 / 11g)
Posted in Memory, unix, Upgrade, tagged zones on October 18, 2010 | 3 Comments »
Today I received an ORA-04031 error when upgrading to 11.2.0.2, with the memory allocation error happening during the final utlrp.sql recompilation step and referring consistently to the large pool. ERROR at line 1: ORA-12801: error signaled in parallel query server P237 ORA-12853: insufficient memory for PX buffers: current 84352K, max needed 13280400K ORA-04031: unable to [...]
ggrep is my new BFF
Posted in unix on October 15, 2010 | Leave a Comment »
Picked up a handy log file search tip today, for searching those pesky log file formats that list date on one line, then the log message on the next line (alert logs, for instance). It’s annoying to grep for just what you want to see, then not have any idea what the timestamp was. I’ve [...]
