I had worked hard on a report, 47 SQL statements in all to tune it down from 5 hrs to under 30 minutes. The first runs had been quite successful, so when a third run sent an alert on temp usage, I knew something was wrong. SID PROCESS MACHINE SQL_TEXT SQL_ID TOTAL MB -------- ------------ -------------------- --------------------- 507 1137 HOST SELECT *** 7t3muww36xhzn 45516 600 1139 HOST SELECT *** 7t3muww36xhzn 45516 525 1132 HOST SELECT *** 7t3muww36xhzn 45516 509 1135 HOST SELECT *** 7t3muww36xhzn 45516 I checked the stats first, as one of the fixes was to ensure the staging…
-
-
Oracle Open World is over for me now, but what a great event it was. I met so many people and actually was able to spend a little time getting to know a few of them. I attended parties, dinners and meetups. I networked myself, my company and RMOUG. It was a phenomenal turn out, even with a few folks missing that I knew we’d miss terribly Arriving- California Zephyr If you hadn’t heard, we decided to take a train from Denver, CO to San Francisco, CA. via Amtrak, called the California Zephyr. This was a 33 hour train ride,…
-
Yes, typing on my tablet screen again, so patience with my short posts…:-) Had the pleasure of attending both the ACE and Oak table dinners the last two nights. Wonderful, impressive and technically gifted people at every table and a fantastic opportunity to meet so many that I’ve only known virtually. I enjoyed another set of high energy conversations with Gwen Shapira, Debra Lilley, Robyn Sands and Lisa Dobsen- all women who make me proud of the representatives of my gender in the technical world. Spent sometime with Mark Bobak, Kent G., Alex G., Craig S., Jeremy Schneider, Mike Swing…
-
After a long first day and a 33 hr train ride in, I’m ready for a fun and enjoyable Ace dinner that I’m a lucky guest to. First day, being Sunday, is commonly quiet, but Tim had two sessions that I wanted to attend and time flew by with meetups, expert panels, etc. I met a number of great new people today and saw some more old friends, (or as “new blood”, can I refer to them as old?) I was still recovering after a fantastic get-together at Graham Woods from lastnight. I was impressed with the great group of…