Lessons learned from managing Oracle performance in a high-volume 24x7 web-based environment that includes OLTP, batch processing, web service APIs, and database synchronization. Since real-world problem solving requires collaboration, persuasion, and patience, it includes advice on communicating with managers, developers, and sysadmins. Sunday, August 14, 2011. Places the USL into an Oracle contex.

Understanding CPU on AIX Power SMT Systems. This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. Nevertheless, I got thrown for a loop this week. In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. Time that the process spent on the CPU.

Thursday, April 28, 2011. We started our Data Warehouse quest adventure on Tru64 back in 2003. At that time the Oracle 9i RAC and Tru64 was the best fastest platform on TPCH tests. We used OCFS2 as file system on the newly 2 node RAC environment. The migration went fine and the performance seems fine for most of the business users. Evidently blame the storage groups! On the.

Color Coded SQL, UNIX and Database Essays. Good bye and thanks for the memories! Hello fellow reader,. 8 years ago I set up a goal to share my knowledge with fellow database engineers via this blog. Many thanks to everyone who read and commented on the posts, asked questions and pushed me to be a better engineer. Apologize for the inconvenience,.

Helping a customer I was creating a job running a procedure I created.

Oracle database and software engineering works. A wonderful day with Oracle Team USA! It was an absolute pleasure to watch Oracle Team USA. Performing at Rhode Island Airshow this year, and was delighted to meet the famous and inspirational aerobatic pilot, Sean D. Smallest closed loop made by Sean D. Flying between Oracle flags! Spiral stunt by Sean D. Tucker! Links to this post.

Mercury Distributed Cache for Oracle. Getting Psyched for Collaborate 2015. Also, thanks to friend and Oracle performance colleague, Craig Shallahamer.

Export the stats table using. Scp the dump file to the destination server.