Archive for the ‘DB Dev’ Category

Last year, at the end of Kscope11, I had the privilege of talking with longtime ODTUG friend, Sue Harper, who at the time was the product manager for SQL Developer and SQL Developer Data Modeler. While Sue no longer works at Oracle, she remains active in the software development community, working for Microgen (http://www.microgen.com/uk-en/) in London in their Aptitude Solutions Division. Sue still maintains a blog here: http://sueharper.blogspot.com/.

One of my fondest memories of Sue dealt not with Oracle, but rather one night at a reception in one of the ODTUG rooms at a conference hotel (pardon my faulty memory for not remembering which one). Sue took the time to relate about one of her trips to work on a clinic in Delhi, India, and shared many of her experiences and photographs of this trip. It was a great way to spend part of my evening learning about Sue’s endeavors outside of Oracle. You can check out her Delhi blog here: http://delhiminimission.blogspot.com/.

Take a quick trip down memory lane as we talk about Kscope11 with Sue Harper.

Sue can be found on Twitter (@sueharps) here: http://twitter.com/#!/SueHarps.

Sue, your ODTUG family will miss you at Kscope12! Cheers!  http://www.kscope12.com.

Read Full Post »

Kellyn Pot’VinGuest Blogger: Kellyn Pot’Vin

Short Introduction:

I’m Kellyn Pot’Vin, pronounced Poet-vaughn, and I’m a senior technical consultant with Enkitec, an Oracle-centric consulting partner, (www.Enkitec.com).  I have a technical blog, dbakevlar.com, am part of the board of directors for RMOUG, and thanks to Chet Justice, (ORACLENERD.com) also part of the database track for Kscope12. I live in Westminster, CO with my partner, Tim, along with my three children, Sam, Cait, and Josh.

You can reach me via gmail at dbakevlar or I can be followed on Twitter @DBAKevlar and Facebook or LinkedIn as Kellyn Pot’Vin.

Now for the post:

All DBAs have experienced this. We come in after a weekend or a couple days have simply gone by when suddenly, a user or your manager approaches you and says, “You know, we had a performance problem on XYZ at 00 o’clock. I’d like to know what happened and why the database performed so poorly…”

The database is always guilty until proven innocent and the DBA must be the one to represent it. The more you know about how to find historical information that can justify the database is innocent; the better off your database environment is from becoming the source of blame every time something goes awry. The additional benefit of having the users and managers coming to you to find out what *REALLY* happened when performance challenges occur vs. having assumptions rule the day.

The example below has occurred just recently for a client. The manager wants to know why he continues to have blocked sessions in his APEX application. Even though this example is from an APEX issue, I felt it was a good one to use for this example.

As the DBA, we start by viewing Top Activity from Enterprise Manager and it’s easy enough to capture the issue in the grid historical view (click on the image to see in full size):

I know they say “Girls love pink,” but no matter what gender DBA you are, you don’t like anything in the pink, red, orange, or brown family on our grid. As the red section is easy enough to pinpoint the area of concern and the complaint, you can direct all of your attention to this point in time.

As the Active Session History is aggregated, the specifics seen in the left side is obscured. We clearly see the two sessions on the right that are also in red and can drill down, making the easy assumption that they are related:

Having the same SQL_ID substantiates the assumption and we can move forward.

You could drill down and come up with your own data, but today, my preference is to have a report that will clearly link all data and leave less to assumption. You have the time of the impact by the issue, running an ASH report is an easy way to see what occurred.

An ASH report is a simple task to run from the Enterprise manager, but we’re going to run this from the command line for the example.

Log into the database server, set your environment and change directories to the one you would like to write the report to. Log into the database with SQL Plus, as a user who has the privileges to execute an ASH report and execute the following:

You will only need the snapshot in time you want the report for:

Yes, the format for the snapshot is not the same as for an ADDM or AWR report but not difficult and Oracle ensures to even remind you of the format to use. My snapshot is from 9:09 AM and the duration I chose is thirty minutes. I then simply name the report and that’s all there is to the command line version to generating an ASH report.

The report is then deposited in the current directory you have run the report from and you can view/vi the report from a Linux/unix prompt.

The top wait event is something we would expect to see and the second not so much- CPU and Waits for CPU.

The second wait event line is less common and a serious concern for any DBA- transaction row lock contention.

The TCP socket (KGAS) is the network waits we could see at the top and are part of a separate export process, (can be seen as a light brown section in the Grid of the first graphic). It should not be considered as part of the scenario at and justifies why having a second view, such as EM, is handy when looking into an issue. It often quickly helps you rule out what is NOT part of the problem.

The next section of the ASH report shows us a bit more info:

Again, we see the transaction row lock contention. This section also shows us what is seen as the cause of the wait. Top service/modules show the problem from APEX and which “page” is the heaviest percent of the activity.

We can see what applications are experiencing the contention and which area of the application, in this case APEX, is the heaviest percentage of the action. This can be very valuable for the developer who may be assisting you on resolving the issue. I strongly believe that to come to the right solution, you should involve all the right skilled individuals. I’m the DBA- yes, I can and have been in the development role, but I would be wise to include the developer who knows this code, this application best. To not include him would be arrogant and ask for assumptions to be made.

We have now approached the section of our report that lists out the sid/serial# for the top sessions.  This offers us a clear view, which happens to include our two SIDs that we saw on the first grid panel in red, of the wait TX, (transaction) row lock contention. Note that there is one sid that is shown above it for top sessions. This is something you definitely want to take note of. We can then see in the next section why there is the wait and why sid 412 is listed first:

Well, no wonder SIDs 423 and 458 aren’t happy-  412 is blocking them! Now we need to know why 412 is blocking.

It is easy to see the matched % Event on the XXX_RPTS table and the 412 blocking session above.

We also know that the TX Row Lock Contention is showing on a sequence. A sequence should not be holding up a transaction, unless odd circumstances-

Check the sequence…

Hmmm…not as good as I would prefer…  This we can fix up, but THERE has to be something more…

So what is the sequence being used for?  Check for triggers-

Now I’m really curious and want to see all of this trigger’s code, so let’s take a look:

Now I’ve experienced triggers with more complex logic coded into them and this is packaged code from Oracle, too, but this is a “hidden” wait that often is difficult to find for most DBAs and Developers. What started out as a simple update to a table becomes much more when a trigger has a bit of complexity added into it, just a bit of logic that might be better put elsewhere.

Triggers are powerful, but they must be gauged wisely and understand the performance risk that can arise when too much complexity occurs either in the trigger or in the application logic or due to database growth, (or all three.)

The questions to ask the developer or application support person could be similar to the following:

  • Why can’t these columns have default values when null?
  • What is the business reason for the insert/update to the secondary table, (many times the trigger may have outlived its use, ask them to justify it.)
  • Note the indices- are indexes present that may help the process and/or are their indices impacting it that are not used, (need to monitor a few indexes)?
  • Could the complex logic be moved to a procedure or package that can be called from the application?
  • If the trigger is used for auditing or reporting tables, would a materialized view or other option be a better choice at this stage in the database’s life?
  • Can the logic in the trigger be simplified?

This is a lot of data for any developer to take in and the developer may get frustrated when they fully understand what is occurring inside the database each time this trigger fires vs. what they may have assumed was a simple transaction. Your job as a DBA is to support him/her and if the design/code can be changed to improve performance to stop the blocking session issue, then proceed forward to do so.

I will be speaking/attending the following conferences the next couple of months:

Miracle World 2012, Denmark, http://mow2012.dk/

April 19th: ASH Analytics- Top Activity, the Next Generation

April 20th: EM12c, Making it work for you!

OUG Harmony, Finland, http://www.ougf.fi/

May 30st: EM12c, Making it work for you!

OUG Harmony, Latvia, http://www.ougf.fi/

June 1st: EM12c, Making it work for you!

Kscope12, San Antonio, TX, http://kscope12.com/

June 27th: EM12c, Making it work for you!

E4, Enkitec Extreme Exadata Expo, Los Colinas, TX, www.enkitec.com

August 13-14, New Date and More Details to Come!

Read Full Post »

Guest Blogger: Jeff Smith

I am a tools freak. Wait, that didn’t sound quite right. I’m extremely passionate about tools in the database space. After a short stint in the real world, I decided to make a career of it. I’ve been an advocate for database tools since 2001 and recently became the Product Manager for Oracle in the database tools group.

So why am I so obsessed by tools? Like any good IT professional I am extremely lazy. If I can do the job just as well but in fewer steps using a tool, I’ll jump on that with both feet. So when ODTUG asked me to share my favorite tools, I was like a pig in slop. Hmm, I’m not sure how that translates outside the US, so let’s just say that ‘I was very happy.’

Everyone loves a good Top 10 list, but remember that I am lazy, so let’s do a Top 5 instead (in no particular order).

1.  The Internet, 2.0

Message boards, Yahoo! Groups, Stack Overflow, and the Oracle Technology Networkforums are all great examples of what I would call Internet 1.0 resources. You should find a group that speaks to you and take advantage of it. Many of you are already there or else you wouldn’t be reading this ODTUG blog post. So I am going to challenge you to join…wait for it…Twitter!

Twitter is social network that works for me. It’s instant access to the smartest and most helpful database professionals in the world. Folks like Cary Millsap and Mike Riley are there – you know those guys, right? Find tuning a challenge? Follow people like Maria Colgan. All she does is manage the database optimizer and answer tough tuning questions in her spare time.

Want to get to know the folks hanging out at Kscope12 before you show up? Most of the presenters are on Twitter. ( Follow @ODTUG and use #Kscope for conference updates.) We love meeting our followers in person, so don’t be shy at the user group conferences!

Ready for that next step in your career? The best jobs are never posted. They get leaked and filled on Twitter. Want to stand out in a crowd? I asked for a show of hands at my last presentation of those who were on Twitter. About 5 hands out of 100 were raised. That’s only 5 percent. Be a “five-percenter” and help us take over the database world! Oh, and how do you think I got asked to write this blog post?

If I’ve convinced you and you’re ready to give Twitter a try, I recommend you read this free Twitter book. Then you’ll want to follow me and check out my OraclePeeps list of interesting folks to follow.

2.  Regular Expressions (RegEx)

Sometimes the data doesn’t look the way you need it to. But you know there’s a pattern there. Regular Expressions are what might be holding you back from taking your code to the next level. Don’t be afraid of RegEx. I was first exposed to RegEx when I started writing some Perl scripts. And then of course I noticed how much easier UNIX scripting got when I understood RegEx. But here’s my dirty secret – I don’t have RegEx memorized. Instead I know enough to know when I need them, then cheat and jump onto Google for the rest. How many times have you noticed a table that just has a big junk VARCHAR or CLOB column? A lazy architect decided to let you parse out what you need instead of breaking it up. This would be a nightmare without RegEx!

And of course you already know about Oracle’s functions for RegEx, right?

3.  DBMS_ Support Packages

There’s something like 500 of these packages. No one expects you to know all of them. I once was asked to help review a tools book that had an entire set of chapters dedicated to all the SYS.DBMS_ packages. It was not an exciting read, but it did open my eyes to some really helpful tools I had overlooked. Now when I need to tackle a new task, the first thing I ask is ‘Maybe there is a package out there that already does what I need?’ There are a few overlooked packages that I think any developer should be not only aware of, but should be using on a regular basis:

  •  DBMS_PROFILER – shows lines executed in your stored procedures, with number of executions per line and amount of time spent per line and execution. The #1 tuning tool for a stored procedure?
  • DBMS_MONITOR – trace a session. You know how to trace, right? I should probably split this out as its own tool, but I’m greedy and promised to stick to only 5. If you don’t have the ability to trace your own sessions in your development environments and access the resulting trace files, go talk to your DBA RIGHT NOW.
  • DBMS_SCHEDULER – DBMS_JOBS is so yesterday. Scheduling tasks in the database can get complicated. If you’re on an 11g database but still using an 8i package to handle it, you’re really missing out. I could say the same thing about continuing to use EXP instead of EXPDP!

4. A Great Offline Text Editor

Notepad is a popular utility for many reasons. It doesn’t do anything you don’t ask for. Have you ever tried to author an HTML document in Word? Now some of you are going to laugh and shake your head in amazement that I am wasting an entire entry in this list to ask people to stop using Notepad. But how many of you notice your co-workers still using it when there are awesome free utilities like Notepad++ out there? If you’re a *NIX person, I don’t even have to mention vi, right?

5A Database IDE That Works for You

You saw this coming a million miles away, right? Of course you know what my favorite IDE is, but I really just want to make sure that the tool you ARE using does what you need it to do. Here’s what I look for when evaluating a database tool:

  • Platform support – does it run on Windows, OSX, and *NIX? Windows is still the  dominate desktop OS, but most techies lean towards Apple. You shouldn’t have to compromise your choice of tools based on your OS. And you shouldn’t have to license     Windows and spin up a VM on your MAC just so you can work with your database.
  • Ease of use – the tool is there to help you, not make you feel stupid. You’re debugging a stored procedure, not practicing your Flight Simulator skills, right?
  • Cost  – if you don’t have to pay any extra money to use the tool, then why would  you want to? I’ll break down and buy a tool from time to time – SnagIt comes to mind –but only after I exhaust what comes out-of-the-box for free.
  • Platform Support – How soon can the tool support the latest and greatest database features and products? While I might not need to use version.  Next in production environments, I am constantly evaluating and building the ‘next best thing.’ As an example, SQL Developer will support Oracle’s new Database Public Cloud offering on Day1.

Again, tools are here to help us. If you are using a tool and it is not saving you time and effort, then you are probably using it incorrectly, or it is just not the right tool for you.

I’ll be at ODTUG’s Kscope12 event with two presentations featuring my favorite database tool and IDE:

Can’t wait? Head on over to my blog and catch up on my favorite tutorials, tips, and did-you-know posts dedicated to Oracle SQL Developer.

Read Full Post »

Chet Justice, Database Content Track Team LeadGuest Blogger: Chet Justice

I will be your host today. My name is Chet Justice, also known as ORACLENERD (note the all caps, I’m particular). You can find my musings on my blog, Twitter, LinkedIn, or Google (even better, UNTAPPD).
In 2010, I was asked to join the Kscope Database Committee by the track lead, Lewis Cunningham. I also got to put together the Kscope Sunday Symposium; Tools. Tools. Tools. Guess what it was about? That was a great experience. It was a lot of work getting all those people to speak, but it was well worth it.

Around that time, Cary Millsap shared with me a great presentation by Dominic Delmolino. The essence of this presentation was related to DevOps. If you don’t know what DevOps is, I’ll save you some time:

In computing, “DevOps” is an emerging set of principles, methods and practices for communication, collaboration and integration between software development (application/software engineering) and IT operations (systems administration/infrastructure) professionals.[1] It has developed in response to the emerging understanding of the interdependence and importance of both the development and operations disciplines in meeting an organization’s goal of rapidly producing software products and services.[2][3][4][5][6]

This is a concept I had been talking about (arguing?) for years…I didn’t know it had a name. I was hooked. Let’s be clear, I’m not a fan of the movement, I am a fan of the principles behind it. Mr. Cunningham had to reel me back in; after all, this was a Tools conference.

Back to this year. I was asked to lead the Kscope12 (June 24-28 in San Antonio, TX) Database track. Known for my…humor, I wasn’t the first choice as ODTUG people are incredibly serious. No one else would take the job though so they were stuck with me. OK, I jest…

As the Database Committee lead, guess what one of my goals is? Get DevOps, or just devops, into the stream. While Operations was the official sub-track, our committee reached out to people in the community to help support the devops theme, and that they did.

With moral support from Jonathan Lewis and Tom Kyte (who may both provide more assistance at the actual event) we got some very cool devops-themed presentations including:

  • Ron Crisco of Method R – Data Design for Developers: An Agile Approach
  • Dominic Delmolino – From Administration to Collaboration, Transforming DBAs Through the Concept of DevOps
  • Susan Duncan of Oracle – Continuous Integration: Put It at the Heart of Your Development
  • Bryn Llewellyn of Oracle – Oracle E-Business Suite’s Use of Edition-based Redefinition for Online Patching
  • Martin Buechi of Avaloq – Tools & Processes for Efficient Development of High Quality PL/SQL in a Large Environment
  • Cary Millsap of Method R – Instrumentation: Why You Should Care

The Database Sunday Symposium, led by Kris Rice of Oracle, will have a DevOps theme as well. Very cool stuff.

Are you looking for a point to this article? Kscope is an excellent event. Make plans to attend—now and volunteer with ODTUG. You’ll get to rub elbows with some of the best and the brightest in the Oracle community.

You know what to do now…go register for Kscope12. I might buy you a beer.

Read Full Post »

Guest Blogger: Eddie Awad

Hi, my name is Eddie Awad and I will be attending ODTUG Kscope this year. In case you don’t know me, here is a quick introduction: I have been developing applications using Oracle technologies and tools since 1994. I am an Oracle ACE Director and the creator of OraNA.info and OracleCommunity.net. You can find me on Twitter, Linkedin, Facebook, and my blog.

Kscope 2012 is going to be my third ODTUG conference I attend. The first one was Kaleidoscope 2009 in Monterey, California. Yes, it was named Kaleidoscope back then. The second one was Kscope 2011 in Long Beach, California. The upcoming Kscope 2012 is going to be held in San Antonio, Texas.

This year’s Kscope is a special one to me. I volunteered to lead the Developer’s Toolbox track team. My task was to build a team of volunteers from the Oracle community and then together determine appropriate sub-tracks, review and rate the submitted abstracts and create a draft schedule for the track.

More than 85 abstracts were submitted to the Developer’s Toolbox track alone. The team then engaged in a blind review, meaning that each team member rated all the abstracts without knowing the authors and rated all the authors without knowing their abstracts. The end result was the selection of 32 abstracts. It was not easy but we made it. Without further ado, I present to you the Developer’s Toolbox track team:

I was also in contact with Steven Feuerstein who offered valuable input and feedback regarding the PL/SQL related abstracts.

I would like to thank everyone for their help in putting together the best Developer’s Toolbox track ever. Also, kudos to the ODTUG Kscope12 Conference Committee for their support during the whole process.

I am not the first one and will not be the last one to tell you that Kscope is the best technical conference for Oracle professionals. You would not want to miss it this year, here is why:

  • 250+ technical presentations from the brightest minds in the Oracle community
  • 3 days of Hands-on Training
  • 5 all-day symposiums
  • Great networking opportunities including: Lunch-and-learn sessions with Oracle ACE Directors, meet the Oracle experts, vendor showcase, and special events
  • Great venue: the JW Marriott resort in San Antonio which has two golf courses, spa, five restaurants, six acres of heated pools, fountains, waterfalls, 650-foot rapid river ride, 1,000-foot lazy river, 100-acre nature preserve and more.

One more reason to attend: I will be presenting too. My presentation will be about data caching in SQL and PL/SQL, in other words, how to make your application run faster.

I guarantee that if you attend Kscope you will come out of it full of new ideas and knowledge about tips, tricks, techniques and technologies you never even knew existed.

Hope to see you there… FYI REGISTER before March 25th to get the Early Bird Rate.

Read Full Post »

For those of you that decide that money is not important to you, you can stop reading the rest of this blog post.

For those remaining, I have some news for you. You have until June 9th to register for KScope11, June 26-30 in Long Beach, CA, and save $250.00 off of the standard registration rate.

Why should you attend? I’d suggest that you read back on some of the previous posts in this blog. You could even revisit those posts from the Kaleidoscope 2010 run-up.

Not enough to convince you? Here’s some suggestions:

  1. Talk to members of the ODTUG Board. We believe passionately in what we do. While not saying anything bad about other conferences, I believe that if you are a developer or architect, there is no comparison between what KScope offers you and what other conferences offer.
  2. Talk to members of the conference committee. They’ve been putting their efforts into making this conference the most memorable and worthwhile conference in ODTUG history.
  3. Talk to the speakers at KScope11. Some of these have been featured in this blog. Many more are just as passionate and are convinced that KScope is the place to be.
  4. A huge list of vendors – Oracle, interRel, Ernst & Young, PITSS, MTG, and many, many more
  5. Look at the agenda:
  • Fusion Middleware – three rooms of cutting edge presentations giving you the inside track of developing application using the Fusion Technology stack. Jellema, Mills, Eisele, Vesterli, King, Koletzke, Schmeltzer…Monday Night Birds of a Feather Sessions.
  • Application Express – three rooms of the best speakers in the world talking about one of the hottest development platforms around. Remember last year, and the release of Oracle Application Express right before the conference? What might you learn and experience about Oracle Application Express 4.1 this year? Speakers like Spendolini, Scott, Gielis, Peake, Kallman, Hichwa, Wolf…Monday Night features Open Mic Night.
  • Database Development – 2 rooms plus of some of the greatest speakers on all things relating to database development. Names like Kyte, Millsap, Feuerstein, Dorsey, King, Rice, Harper, Hotka, Llewellyn, Morgan…the list goes on and on. Add a special database guru panel Monday night featuring Tom Kyte, Steven Feuerstein and Cary Millsap. Nowhere else but KScope.
  • BI/EPM – 5 rooms plus of the shining stars of the BI/EPM world. Led by conference chair Edward Roske, the names are familiar to all – McMullen, Schwartzberg, Lackpour, Rittman, Bryson, Moore, Crisci, Nath…again, there are too many to list all here in this post. Hyperion Midnight Madness Monday Night, sponsored by MTG.

Hands on training, always free, is also included. Networking events galore. Special Event on the Queen Mary!

Community Service Day on Saturday June 25, where we’ll be painting and landscaping at the Boys and Girls Club of Long Beach.

I guess if you don’t need to further your education, or don’t care about money, this blog posting isn’t for you.

For the rest of you, and those still reading, I hope to see you there!

If you cannot attend for some reason, please drop me a line at mriley@odtug.com to let me know why.

Read Full Post »

In somewhat of a break from my regular question and answer session, I bring to you a posting directly from one of the people that I admire most in this industry, Cary Millsap. Cary is an Oracle ACE Director, and founder and President of Method-R Corporation. Cary is also a member of the Oak Table Network, and author of the book “Optimizing Oracle Performance“. Cary will also be a key member for the team presenting at the KScope Sunday Symposium on Database Development “Tools, Tools, Tools“.

Have you registered for KScope11 yet?

I’ve added in some hyperlinks to supplement what Cary wrote about, and added some more information about KScope and about Cary himself. If any of these links are incorrect, it is my problem, and not Cary’s, and I apologize in advance (and promise to correct them as soon as they are pointed out to me).

All it took to get Cary to write me back about KScope was one question…

Cary Millsap

MR: Why KScope?

CM: “Most people in the Oracle world who know my name probably think of me as a database administrator. In my heart, I am a software designer and developer. Before my career with Oracle, I worked in the semiconductor industry as a language designer. I wrote compilers for a living. Designing and writing software has always been my professional true love. I’ve never strayed too far away from it; I’ve always found a reason to write software, no matter what my job has been. [Ed: Examples include the Oracle*APS suite and a compiler design project he did for Great West Life in the 1990s, the queueing theory models he worked on in the late 1990s, the Method R Profiler software (Cary wrote all the XSLT code), and finally today, he spends about half of his time designing and writing the MR Tools suite.]

My career as an Oracle performance specialist is really a natural extension of my software development background. It is still really weird to me that in the Oracle market, performance is regarded as a job done primarily by operations people instead of by development people. Developers control at least 90% of the leverage over how fast an application will be able to run. I think that performance became a DBA responsibility in the formative years of our Oracle world because so many early Oracle projects had DBA teams but no professional development teams.

Most of those big projects were people implementing big off-the-shelf applications like Oracle Financial and Manufacturing Applications (which grew into the Oracle E-Business Suite). The only developers that most of those implementation teams had were what I would call nonprofessional developers. Now, I don’t mean people who were in any way unprofessional. I mean they were predominantly businesspeople who had never been educated as software developers, but who’d been told that of course anybody could write computer programs in this new “fourth-generation language” called SQL.

Just about any time you implement a vendor’s highly customizable new application with 20,000+ database objects underneath it, you’re going to run into performance problems. Someone had to attend to those problems, and the DBAs and sysadmins were the only technical people anywhere near the project who could do it. Those DBAs and Oracle sysadmins were also the people who organized the early Oracle conferences, and I think this is where the topic of “performance tuning” became embedded into the DBA track.

The resulting problem that I still see today is that the topic became dominated by “tips and techniques”—lists of tricks that operational people could try to maybe make their systems go a little bit faster. The word “tuning” says it all. I almost never use the word except facetiously, because it’s a cheap imitation of what systems really need, which is performance optimization, which is what designers and developers of software are supposed to do. Even the evolution of Oracle tools for the performance analyst mirrors this post-production tips-and-techniques “tuning” mentality. That’s why most performance management tools you see today are predominantly oriented toward viewing performance from a system resource perspective (the DBA’s perspective), rather than the code path perspective (the developer’s perspective).

The whole key to performance is the application design and development team, especially when you realize that the performance of an application is not just its code path speed, but its overall interaction with the person using it. So many of the performance problems that I’ve found are caused by applications that are just stupid in how they’re designed to interact with me. For example, if you’ve seen my “Messed-up apps” presentation before, you might remember the self-service bus ticket kiosk that made me wait for over a minute while the application tallied the more-than-2,000 different bus trips for which I might want to buy a ticket. That’s an app with a broken specification. There’s nothing that a run-time operations team can do to make that application any fun to use (short of sending it back for redesign).

My goal as a software designer is not just to make software that runs quickly. My goal is also to make applications that are delightful to use. It’s the difference between an application that you use because you must and one that feels like it’s a necessary part of who you are. Making software like that is the kind of thing that a designer learns from studying Don Norman, Edward Tufte, Christopher Alexander, and Jonathan Ive. It’s a level of performance that just isn’t on the menu for operational run-time support staff to even think about, because it’s beyond their control.

So: why Kscope? The ODTUG conferences are the best places I can go in the Oracle market where I can be with people who think and talk about these things. …Or for that matter, who understand that these ideas even exist and deserve to be studied. KScope is just the right place for me to be.”

Thanks Cary! Now everything will be juuuust fine!

Cary has his own blog located at http://carymillsap.blogspot.com/. Cary also is pretty active out on Twitter and can be found at http://www.twitter.com/carymillsap.

Look for some more exciting news about some additional content at the right place for YOU to be, KScope11 in Long Beach, CA June 26-30.

See you there!

Read Full Post »

I turned this interview over to Monty Latiolais, fellow ODTUG Board Member and content chair for this year’s Kscope. Monty took the time to solicit the following answers from oraclenerd himself, Chet Justice. Chet is familiar with many in the Oracle community. He is a prolific blogger, and an Oracle ACE. Breaking the mold, he is also the first interview from this year’s Kscope conference series that has never attended a Kscope event before. So, let’s make sure we initiate him properly in Long Beach (don’t worry, Chet, we’ll teach you the secret handshake later).

Chet Justice - a.k.a. oraclenerd

Early Bird Registration ends March 25.  Register now, as registrants can now schedule spots in our FREE Hands On Training labs, which are filling up quickly.

Take it away, Monty…

ML: What’s the best thing about Kscope conferences?

oraclenerd: “I have never been to a Kscope conference, this will be my first. I have bugged a few people about blogger passes the past two years though (I’m never afraid to ask).

I first heard about ODTUG through Lewis Cunningham just a few years ago. Not sure how I missed it during the first 5 years of my Oracle career, but I did.

I’m incredibly excited  to be going. Not only going, but I get the pleasure of organizing the Database Development Tools, Tools, Tools Symposium on Sunday. Not sure exactly what led me to volunteer for such a spot, but I am glad I did. The lineup will be awesome. Cary Millsap, Sten Vesterli, Sue Harper, Kris Rice, Jeff Smith and Marc De Oliveira. And that is just Sunday.”

ML: Who do you most look forward to seeing a presentation from at Kscope and why?

oraclenerd: “I’ve never seen Cary Millsap, he is the one I am most interested in seeing. Why? Well, mostly it’s obvious, it’s Cary Millsap (MR: see Cary’s blog here). From what I have read over the years, Cary is one of the best speakers/presenters out there. What makes it more interesting, from my perspective, is that I don’t understand much of what he is talking about. From a high level I do, of course, but the devil is in the details. That’s where I hear Cary shines. He makes the material easily consumable by mere mortals like myself. That makes him not only a great speaker and topic expert, but a teacher. That’s something I aspire to.”

ML: Why Kscope and not somewhere else?

oraclenerd: “I like the focus on the technical. I do not expect as much marketing fluff as I would get at another conference and from the abstracts that I read through, that is the case. Though I will admit that much of my desire is around the opportunity to meet and talk with all of these people. That’s where I get value from a conference like this. I can bounce ideas off of them or I can just sit back and listen. Either way, I come out ahead.”

ML: Have you ever been to Long Beach or visited the Queen Mary?

oraclenerd: “I have been to both. I lived in Simi Valley, CA when I was younger (8-12 years old). I remember going to the Queen Mary when I was around 9 or 10. It was gigantic. Not as big as today’s cruise ships, but still impressive.”

ML: Your all time favorite Kscope moment is…

OracleNerd: “…I should have a few for you after the event. :)”

I’m sure that you will…

Chet (oraclenerd) can be found out on Twitter as @oraclenerd. Chet also blogs all the time at http://www.oraclenerd.com/

(Join the Twitter revolution – sign up on http://www.twitter.com and remember to also follow @odtug (and me, if you’d like @Mike_ODTUG))

Thanks Monty for reaching out on this interview, and thanks Chet for your input. We’ll see you in Long Beach, and I hope we live up to your expectations!

Read Full Post »