This is the last week for RMOUG Abstract Submissions for Training Days 2014! Last day is Aug. 31st and we want your abstract to show us all you know and how much everyone else can learn from you! I’m thrilled to announce I have a great conference committee and we are on the road to a fantastic event this February, but we can’t do it without you, the great speakers of the Oracle Community. Submit your abstract today and don’t be left out on all that RMOUG Training Days has to offer. If you are a seasoned speaker, you know how great…
-
-
Seeing more and more questions on “where do I start with Oracle if I want to be a DBA?” My perspective is a bit off since I’ve been surrounded by Oracle for over 20 years. I hardly remember what it was like to start with Oracle and starting with Oracle now in 2013 is quite different than starting with Oracle in 1990. Here is my list and everything on this list is excellent. I’m sure I missed a few good ones, but maybe people can add them in the comments. Start with Oracle Docs, they are free and good! http://www.oracle.com/pls/db112/homepage…
-
How do we know where latency comes from when there is a disparity in reported I/O latency on the I/O subsystem and that of the latency reported on the client box requesting the I/O. For example if I have an Oracle database requesting I/O and Oracle says an 8Kb request takes 50 ms yet the I/O storage subsystem says 8Kb I/Os are taking 1ms (averages) , then where does the 49 extra ms come from? When the I/O subsystem is connected to Oracle via NFS then there are a lot of layers that could be causing the extra latency. Where…
-
Effective Monitoring This is going to be a five part series discussing how to set up EM12c effectively and productively so DBAs are offered critical alert notification and the ability to manage the environment through the incident manager in a (possibly) different way than first conceived. For any DBA who serves an on call schedule, the importance of receiving pages that are production critical outages and contain no “white noise” is essential to your success and your sanity. Its been a goal that Enkitec has been striving towards regularly and I can attest to this as a Remote DBA I’ve…
-
I have a number of sessions going on the week of Oracle Open World and figured I better get some info out there with it just over a month away! My main sessions, along with others offered by my phenomenal, fellow Enkitec folks can be found here. I have also traded in my technical session at Oak Table World for two WIT, (Women in Technology) sessions. The wonderful Kyle Hailey has built us a great web site to promote it and we’ve got Oracle’s support as we bridge between Oak and Oracle for these two exciting sessions where the women…
-
Oracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight forward such as time_waited_micro, but what unit is “TIME_WAITED” or “WAIT_TIME” in? For example v$session WAIT_TIME – centi SECONDS_IN_WAIT – seconds v$session_wait WAIT_TIME – centi SECONDS_IN_WAIT – seconds v$system_event TIME_WAITED – centi AVERAGE_WAIT – centi TIME_WAITED_MICRO – micro v$system_wait_class TIME_WAITED – centi v$eventmetric TIME_WAITED – centi v$waitclassmetric DBTIME_IN_WAIT – “percentage of the measured wait time that was actually in foregrounds and therefore part of DB time” * TIME_WAITED – centi v$waitclassmetric_history DBTIME_IN_WAIT – “percentage of the measured wait time that…
-
See Brendan Gregg’s blog on how important and cool heatmaps can be for showing latency information and how average latency hides what is really going on: Now if we want to create heatmap graphics, how can we do it? Two popular web methods for displaying graphics are Highcharts and D3. Two colleges of mine whipped up some quick examples in both Highcharts and D3 to show latency heatmaps and those two examples are shown below. The data in the charts is random just for the purposes of showing examples of these graphics in actions. Highcharts Heatmap see code at http://jsfiddle.net/vladiweb/GNd3G/ D3 Heatmap…
-
Post a recent migration to consolidate a number of new databases to one of my client’s Exadatas, I found myself staring at a familiar wait event on one of them that I run into way too often when hopes of Exadata migration performance glory is reviewed. Where, with all the features that are available to the consolidated database to perform more effectively on Exadata, Temp usage just isn’t one of them. Many know that I’m a proponent of ensuring design and code is as efficient as possible to not “over run” PGA allocation per session and “swap” over to temp.…
-
Didn’t know that was the name of a little know feature in 11g, eh? OK, so I may have named it that, but this is where I’m at right now with dynamic sampling at many of the shops I’ve worked at. I know it’s due to the common sizes and types of databases I’ve worked on, too. Many of them have unique hybrid databases that require unique solutions. These databases often have both transactional and ETL processing/reporting, along with adhoc queries from GUI tools. For best results we’ve implemented the following in most of them: 1. Throughout ETL loads, I work…
-
Thanks to everyone that tuned in for Redgate’s All things Oracle Webinar I did on Database 12c today. I know we went way over on time and appreciate everyone staying on for the extra time as we went through and demo’d how many ways we can create, copy and clone DB12c pluggable databases. As promised, here’s the demo playbook and the links to the Virtualbox image with the DB12c installation files on it. You will need to do the following to set everything up: 1. Set the host name in the /etc/hosts file, (in case you want to rename your…
-
I will be presenting another webinar with my good friends at Redgate this Wednesday, July 17th on the new Database 12c feature, Pluggable Databases. This session will be one hour, but will include a live demo on the pluggable database feature. Seats are limited and I know in just one week, over 500 have already registered, so if interested, register here! See you on Wednesday and thanks!
-
So for those of you that aren’t going to be “deep diving” soon, there will be two interfaces for creating a pluggable database- a GUI or through a CLI and for many, the former is going to be the choice as we ascend into DB12c land. Many are still asking why we even want to go the pluggable database route, “What’s all the fuss?” The concept is easy for any MSSQL DBA to comprehend- they’ve had a lot of the feature set in place for quite some time as we detached and attached SQL Server databases since version 7. So what…
-
As we all know, it’s always the little things that come back to bite us when we are working with our own VM setups. I’m using the newest Oracle Virtualbox 4.2.16 and have been quite happy with my new Linux6 installation. I configured my listener and was ready to work with EM Express, but when logging in, received the error that I needed Adobe Flash Player to proceed. Strange thing was, I was quite aware of this and had already updated it. Just for the fun of it, I tried again, and was told that it was already installed…which means…
-
I returned home last night after a week in the great city of New Orleans for ODTUG’s KSCOPE 2013. We arrived last Thursday, Tim is a director on the board, so were picked up from the airport in grand fashion and were delivered to our lovely suite at the hotel- ODTUG making sure we were all well cared for. This is one of three conferences that Enkitec has a booth at. I am very fortunate to work for a supportive company that includes RMOUG in that list, but know that KSCOPE, a very developer oriented conference is one of those…
-
I will be presenting this next week at KSCOPE 2013. I have a number of presentations, both technical and WIT, (Women in Technology) related. My main presentation can be found listed with my speaker bio And the WIT panel, although a bit out of date, (our line up has changed a little…) is here. I just forwarded my Imposter Syndrome slides onto Maria Colgan so she can review them and let me know what she thinks. It’s a subject that seems to be very near to any successful woman’s heart, but what really surprises me is how many men I…
-
The idea of providing databases as a service to customers and companies can be a very foreign idea to the database administrator. The DBA’s job is to carefully control and dole out resources. The concept that “in the cloud” the user can just “order up” a database on demand is a difficult one. How does it work? Infrastructure First, the a cloud-based Paas Infrastructure zone must be created. Without this, the plug-in for the “database as a service” will function. Once this is setup, then the “Database for a Service” can be completed. The DBA must create a couple users for…
-
As many know, I joke about being a strange, ADHD kid. I didn’t really fit in with the other kids and was really, really small for my age. I was bullied and very much a loner. Growing up, my closest friend was my middle sister, Kristi who is 2 1/2 years younger. She was the golden child- blond hair, blue eyes and very, very sweet. She was so easy-going that she was often frustrated by other kids, so my easy-going, but, hyper personality was preferable to them and we were happy to hang out together. We grew up in a…
-
How many performance specialists have experienced projects where reporting was horrid in the beginning, maybe didn’t even complete? The focus of the project may have sat with data loads or due to the data architect’s design specialty, etc., the reporting aspect was just the last thing on everyone’s mind until it was too late. I come into this conversation with companies all the time and it is a difficult one, as there are so many database myths. “Can’t you just do something to make the database go faster? I don’t know, isn’t there a parameter that can be updated, maybe…