Subscribe to Blog via Email
It’s that time of year again and the massive undertaking of the Collaborate conference is upon us. This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database.
The conferene is held in different cities, but recently its been sticking to the great destination of Las Vegas, NV. We’ll be at the Mandalay, which like many casinos, is like it’s own little self-contained city within a city.
The week will be crazy and I’ll start right out, quite busy with my partners in crime, Courtney Llamas and Werner De Gruyter with Sunday’s pre-conference hands on lab. “Everything I Ever Wanted to Know About Enterprise Manager I Learned at Collaborate” was a huge hit last year, so we’re repeating it this year, but we’ve updated it to the newest release, EM13c. For those that are able to gain a coveted spot in this HOL, it will be a choice event. We’re going to not just cover the new user interface, but some of the coolest need-to-know features of the new release.
Sunday evening is the Welcome Reception and Awards Ceremony. This year I’m receiving the Ken Jacobs award for my contributions to the user community as an Oracle employee. I’m very honored to be receiving this and thank everyone at IOUG for recognizing the importance that even as an Oracle employee, you can do a lot to help make the community great!
Throughout the week, I’ll have a number of technical sessions:
Now my Database as a Service Session is up first for the week on Monday, 9:15am in Palm B, but I’m going to warn you, since this abstract was submitted very early on, the abstract isn’t as descriptive as I wanted. Know that this is a DBaaS session and I’ll be covering on-premise, private cloud and even Oracle Public Cloud! Come learn how easy it can be and forget all those datapump, transportable tablespace and other silly commands people are telling you have to do to provision… ☺
Right after my DBaaS session, 10:15, same room, (Palm B) we’ll have a special session covering the new product that so many of us have put so much energy, time and vision into- The Oracle Management Cloud, (OMC)! Read more about this session here.
The Welcome Reception in the Exhibit Hall is from 5:30-8pm. Don’t miss out on getting there first and see all the cool exhibitors. I’ll be at the EM13c booth, so come say hi!
So Tuesday morning, the 12th, I’m back in Palm B at noon for the first of my certification sessions, covering 30 minutes of Enterprise Manager 13c New Features.
Wednesday, at noon, I’m back in my favorite room, Palm B to finish the second part of the certification sessions on new features with Enterprise Manager 13c.
I’ll be presenting at Oak Table World at Collaborate at 2pm in the Mandalay Bay Ballroom. I’ll be doing my newest session on Enterprise Manager 13c and DB12c. It’s always a great venue when we have Oakies at conferences and I almost squeaked out of it this year, but dragged back in at the last minute!
The Enterprise Manager SIG is right afterwards at 3-4 in the South Seas Ballroom E. This is where we meet and geek out over everything Enterprise Manager, so don’t miss out on that!
For the last day, Thursday at 9:45am, I’ll be in- wait for it…. Palm B! Yes, I know it’s a surprise for both of us, but I’ll be using my experience helping customers Upgrade to Enterprise Manager 13c and sharing it with everyone at Collaborate. This is another certification session, so collect those certificates and get the most out of your conference!
I’ve made a lot of updates with new material to my slides recently, so I promise to upload my slides to SlideShare after the conference, too!
See you next week in Las Vegas!
While at Collaborate on Monday, Oracle has been offered a spot to highlight The Oracle Management Cloud. OMC is a suite of next-generation monitoring and management cloud services designed for heterogeneous environments, all empowered by Oracle’s own cloud! The first three OMC services (Application Performance Monitoring, Log Analytics and IT Analytics) were launched at OpenWorld 2015. Both Log Analytics and IT Analytics contain must-have capabilities for DBAs. This is the only OMC session that will be available at Collaborate and it’s a not to miss session with an all-star cast to present on it. Manning the slides will be Brian Hengen and Yuri Grinshteyn, while Courtney Llamas and I will be sharing our expertise during the demonstrations.
We’ll be covering how to grapple with large environment resource usage, identifying what really needs your time allocated to it (versus what you can just let go!) and how you can help your manager manage your infrastructure better. We all know how much damage false assumptions can cause to your ability to respond to priorities and demands. IT Analytics has the intelligence you need built in, so no more guesswork based on capacity planning scripts, Excel spreadsheets and graphing to prove to the business that you have a handle on where your energy is most needed.
We’ll also discuss how to extract valuable insight from mountains of logs. We DBAs know how valuable log data is but we also know how voluminous it is. Having it reduced to human-scale and correlate seamlessly with the analytics discussed above is an impressive feat and you’ll see how powerful log data can be when displayed this way for the business. No more “going down rabbit holes” trying to digest log data on one server, matching it to output from a user interface from a tool on another server and finally verifying that it actually had anything to do with the actual problem you were investigating in the first place.
So ensure you’ve added this session to your Collaborate schedule on Monday, at 10:15 in room Palm B. An impressive group of folks from Oracle have made sure it’s going to be an interesting, informative and empowering session on the Oracle Management Cloud. I have a feeling the room may be packed, so make sure to register beforehand!
Working with test data is always fun and teaches those of us inside Oracle how best to use the new products that will be offered to benefit customers. To me, it’s pretty straight forward and I didn’t first understand why it was necessary, but as I sit in on calls as we do performance testing of these great, new products, I understand why they need to direct so many, so often. Anything performance is as much a mindset as it is a science.
Application Performance Monitor, aka APM, is no different. I didn’t exactly “follow” the hands on labs each time we’ve been taken through them, as I find it’s important for me to run through the product on my own and find out if its intuitive when I use it on my own.
I commonly ask myself a few questions as I review the results afterwards:
Slow Ajax performance is what we are experiencing in our example today.
Clicking on Ajax Calls will display this information and confirm the customers experience.
Notice that currently there is almost 40% errors, 257 errors in total. By clicking on Checkout, where the errors are showing, we can then drill down into the details:
I then click on the link for the procedural call name, (/RideShare/checkout) and it takes me to a page that starts to break down the response time, (including faults, which we’ll focus on today) along with Calls and Errors, plus the Tier Average Response, (which includes the time spent on the AppServer calls vs. Database and External Calls).
If I click on the Links tab, I can see all the correlated links for this application and how they are performing. I can quickly see what calls are experiencing errors, (no matter if they are a parent call or a child call):
And what calls are NOT connected to the issue and aren’t experiencing any errors:
Although I’m only showing a snippet of the database calls, you can also click on the Database tab and verify that the database is excluded from the issue.
I click on Instances and it quickly shows a list of everything connected via ECID and reasons for the capture. For our experience today, we’ve focused on the ones listed by Fault.
Now I can click on the Reason Captured and I can sort by Faults to see if there is a pattern to what is going on:
It confirms that all the issues are resulting from the App Server. If I click on one of the Instances that experienced the faults, it will then display the details of what occurred:
Notice that the checkout, when it calls the OrderService.submit, there is a failure when the OrderService.submitWithid is called. If we expand the view for this call, we get to see all the calls involved in this application code and can then see that the error occurs during the RestaurantService.placeOrder.
If you hover over the time “Self-time”, we find out that over 76% of the total time is spent on this step and is the source of the response time impact.
I can then click on the upper right and leave APM to Log Analytics, (which we’ll cover in detail in future posts) and View Related Logs, which gives me the log data that confirms what I’ve already found out from the Instance Information:
I prefer to check mark the “Show Message Field” to eliminate the need to parse the message out of the log text, (future tech tip for working with this product…) and again, you see the error that is experienced by the user when they try to submit RestaurantService.placeOrder.
So I’m about to depart for one day in San Antonio, Tx. to present at the International Performance and Capacity Conference, but I wanted to try to get another blog post out, this time regarding my survival at the 2015 Oracle Open World.
I’m not sure if it just that the schedule was a month later than usual or that it was just more demanding this year, but I left on Friday, feeling utterly exhausted and judging by the tweets and posts from others on social media, I don’t think I was the only one! I always regret what I didn’t get to do or those I didn’t get to meet, but this year, there were even events that I was supposed to attend that I wasn’t able to! There were just too many demands on my time- I’d get up at 5-6am each morning and collapse in bed at 11pm to midnight each night thinking about what I still had to get done!
Some of my favorite times were at the demo booths. I really enjoyed talking to everyone and getting the chance to introduce the attendees to Enterprise Manager 13c was a joy. The great new interface and features were impossible not to get excited about!
I’ve always tried to get everything prepared before I leave for the event and outside of anyone’s control, my poor co-presenter for Oak Table World, Stewart Bryson, had to go in for emergency surgery on his knee. Rather than do my well-known AWR Warehouse presentation sans the great OBIEE tier from Stewart, I chose to build out something new. My mistake- I chose to decide on the topic after drinking out with Alex Gorbachev on Friday evening. I really should know better than this, but instead attempted to build a Raspberry Pi project with missing hardware until I finally had to admit to Alex that I’d coded my way into a hardware corner without the time or resources to get out of. Needless to say, I found myself without slides or a technical topic on Sunday for my presentation Tuesday morning.
I ended up having to skip the bridge run, (in my arthritis case, walk) and got down to building out a new project after seeing the stuffed bears in the Oracle retail store. I knew I wanted to inspire the attendees to get involved with the younger generation, but what could I quickly build out without too much demands on my time that would do that? After purchasing one of the bears, I went over to Central Computers and added a PiCamera to my already purchased Raspberry Pi investment.
Thanks to some jumper wires from Mark Vilrokx and, a few misc. buttons, safety pins and such from stores downtown, I was ready to start operating on the bear. The amount of odd comments as I sat in the OTN area, cutting open the bear and pulling the stuffing out to insert the Raspberry Pi was pretty humorous. I had to warn my husband as he went into our room much later in the day, that no, I was not building a bomb and to hide the hardware from the poor maids before they freaked out upon cleaning our room!
The end product was pretty cool though- The RPI_OracleBear is a picture taking, tweeting stuffed bear when you pushed the button on his paw! You can check him out on Twitter, as he was a guest to a couple of the parties and locations throughout the conference week. The session at OTW went well and I was very happy with the response, especially considering I’d just put it together the last 48 hours between booth duty and other demands. The worst part was that in the middle of coding the python piece for the project, I lost track of time and missed the Enterprise Manager SIG meeting on Monday evening! This is where hyper-focusing is more of a liability than a gift.
I was able to make all my other commitments throughout the week, including publisher meetings representing my group, meeting with many customers and getting the word out about Oracle Management Cloud and even demoing Enterprise Manager 13c! I really noticed just how busy I was when I’d finished having a lunch debriefing with Oracle Education Foundation on Thursday afternoon and the realization hit me that I didn’t have anything to do for the next three hours. I’d been running non-stop for so many days that I just didn’t know how to handle any downtime, but ended up going back to my room to mail out RPI Oracle Bear, (no one wants to know what would have happened if I’d tried to take him through TSA scanners…) and packed my bags to gladly go home the next morning. All and all, it was a great year, but looking forward to the event next year to be a bit earlier than the end of October! 🙂
Things we learned this year:
Last but not least- Kudos to Oracle not just for putting on a great conference, but of all things, the backpack attendee gift this year. I know it sounds strange, but I give away these bags or turn them down. This year, I talked my husband out of his in less than a day and will be using it on my trips for quite some time. Its compact, attractive and stays on my small shoulders. I expect conferences to cater to the majority of attendees and let’s be honest, it’s men, but this bag is something that both men and women found very functional and appealing. Great job on a small but cool detail for the attendees.
This is one of about 40 blog posts I’ve been eagerly awaiting for permission to post on the Oracle Management Cloud, (OMC)! There are three main products that will be offered initially through the Oracle Management Cloud–
This post will focus on one area of the third offering of IT Analytics– Database Performance Analytics.
How can advanced IT Analytics investigate database performance at the cloud level vs. on premise? We’ll take a look deeper into this Oracle Management Cloud feature today and hopefully give you just a taste of this incredible upcoming suite of products from Oracle.
In the IT Analytics Dashboard, we can click on Database and we’ll be brought to the Performance Analytics: Database page. The view, unlike what we are accustomed to in Enterprise Manager, introduces us to a global view of performance activity.
Now this may seem very foreign to what the database administrator is accustomed to viewing, but just as one acclimates to viewing performance for any given database, the DBA will acclimate to viewing performance at this new global view. The nuances of performance changes will be noticed soon enough and the DBA will find peace knowing that the global view allows them to inspect their entire database environment vs. just a single one.
The DBA can focus on any day or performance by hovering their cursor on the Database Activity graph and the overall wait hits will be demonstrated. It’s very clear that on Sept. 10th, a high amount of IO waits were experienced across the database environment.
If you were interested in CPU or other wait type, notice that where you hover makes a difference:
Below the Top Activity, the most impacting SQL is displayed by SQLID and then the change in response time is shown in variations of red to green, red signifying larger percentages of change in performance impact.
This redistributes the tuning exercise from the database level to the global SQL level. Although the SQL identified with ‘bqvs6ypax0dtn’ and ‘gm6py648gu6x5’ may be very good statements for overall tuning, the SQL identified with ‘4ztz048tq32s’ is most likely to result in user complaint due to recent performance degradation from the most number of users.
Now IT Analytics offers incredible opportunities at this global view, but this may be where the DBA wishes to dig into the issue on-premise. IT Analytics Database Performance ensured the DBA was able to quickly identify where their time could be allocated with the most value for a performance tuning exercise and now the DBA may wish to proceed to a trusty AWR SQL specific report or SQL ID details information or Search SQL for the SQLID identified Oracle Management Cloud IT Analytics, thanks to Database Performance Analytics.